Devart Forums

Hello,

IBDAC installed the Trial version. Fields Editor / Add Fields I wanted to make the following error message is coming.

"Connection is not defined"

XE2 - 16.0.4504.48759 HotFix 1
IBDac - 4.5.10

[0CF0FDD1]{ibdac160.bpl} Ibcclasses.TGDSCommand.RaiseError + $11
[0CF0FE0A]{ibdac160.bpl} Ibcclasses.TGDSCommand.CheckDatabase + $32
[0CF12A5F]{ibdac160.bpl} Ibcclasses.TGDSCommand.Prepare + $2B
[500A3510]{rtl160.bpl } System.Classes.TList.Clear (Line 3811, "System.Classes.pas" + 2) + $4
[0CF1778B]{ibdac160.bpl} Ibcclasses.TGDSRecordSet.InternalInitFields + $4F
[0CC8801A]{dac160.bpl } Memdata.TData.InitFields + $46
[0CC88049]{dac160.bpl } Memdata.TData.InitFields + $75
[0CC90BE9]{dac160.bpl } Memdata.TMemData.InitFields + $5
[0CD3AF83]{dac160.bpl } Craccess.TCRRecordSet.InitFields + $23
[50448FFF]{vcl160.bpl } Vcl.Forms.TCustomForm.Notification (Line 3775, "Vcl.Forms.pas" + 40) + $C
[50037AEF]{rtl160.bpl } System.@ReallocMem (Line 3640, "System.pas" + 85) + $0
[50041874]{rtl160.bpl } System.DynArraySetLength (Line 28332, "System.pas" + 66) + $14
[0CF17A9F]{ibdac160.bpl} Ibcclasses.TGDSRecordSet.InitFields + $7
[0CC881EA]{dac160.bpl } Memdata.TData.ExplicitInitFields + $2
[0CCEA1B0]{dac160.bpl } Memds.TMemDataSet.InternalInitFieldDefs + $C8
[0CD11D01]{dac160.bpl } Dbaccess.TCustomDADataSet.DataEvent + $59
[508EFBAB]{dbrtl160.bpl} Data.DB.TFields.Changed (Line 4045, "Data.DB.pas" + 3) + $6
[508EFC52]{dbrtl160.bpl} Data.DB.TFields.Add (Line 4063, "Data.DB.pas" + 4) + $2
[508F1D0D]{dbrtl160.bpl} Data.DB.TField.SetDataSet (Line 4956, "Data.DB.pas" + 29) + $5
[508EEE40]{dbrtl160.bpl} Data.DB.TFieldDef.CreateFieldComponent (Line 3644, "Data.DB.pas" + 18) + $B
[508EEF1C]{dbrtl160.bpl} Data.DB.TFieldDef.CreateField (Line 3662, "Data.DB.pas" + 1) + $6
[50037A80]{rtl160.bpl } System.@GetMem (Line 3454, "System.pas" + 20) + $0
[22AB747D]{dcldb160.bpl} DSDesign.TDSDesigner.DoCreateField (Line 271, "DSDesign.pas" + 30) + $1D
[22AB87CB]{dcldb160.bpl} DSDesign.TFieldsEditor.CreateFields (Line 662, "DSDesign.pas" + 23) + $28
[22AB8E67]{dcldb160.bpl} DSDesign.TFieldsEditor.DoAddFields (Line 859, "DSDesign.pas" + 28) + $C
[22AB8CD1]{dcldb160.bpl} DSDesign.TFieldsEditor.AddFields (Line 821, "DSDesign.pas" + 1) + $2
[22AB9E56]{dcldb160.bpl} DSDesign.TFieldsEditor.AddAllFields (Line 1363, "DSDesign.pas" + 0) + $2
[50438083]{vcl160.bpl } Vcl.Menus.TMenuItem.Click (Line 2522, "Vcl.Menus.pas" + 19) + $8
[50439687]{vcl160.bpl } Vcl.Menus.TMenu.DispatchCommand (Line 3435, "Vcl.Menus.pas" + 5) + $2
[5043A8F6]{vcl160.bpl } Vcl.Menus.TPopupList.WndProc (Line 4596, "Vcl.Menus.pas" + 4) + $E
[5043A845]{vcl160.bpl } Vcl.Menus.TPopupList.MainWndProc (Line 4571, "Vcl.Menus.pas" + 2) + $5
[500B688C]{rtl160.bpl } System.Classes.StdWndProc (Line 13878, "System.Classes.pas" + + $0
[50453213]{vcl160.bpl } Vcl.Forms.TApplication.ProcessMessage (Line 10164, "Vcl.Forms.pas" + 23) + $1
[50453256]{vcl160.bpl } Vcl.Forms.TApplication.HandleMessage (Line 10194, "Vcl.Forms.pas" + 1) + $4
[50453595]{vcl160.bpl } Vcl.Forms.TApplication.Run (Line 10332, "Vcl.Forms.pas" + 26) + $3

Hello,

The 'Connection is not defined' error means that you did not define a connection for a dataset for which you are trying to use Fields Editor. To solve the problem, you should set the Connection property of the dataset to one of the TIBCConnection components that you have on your form. If you do not have any TIBCConnection components on the form, you should drop it onto the form from Tool Palette.

Component on the form, there TIBCConnection.

Please make sure that the Connection property of the dataset is set to this TIBCConnection.

transaction component design mode "active = false" This problem occurs when

Please perform the following steps:
- open Delphi XE2;
- create a new VCL Forms Application;
- drop the TIBCConnection component onto the form (it will be named IBCConnection1);
- drop the TIBCQuery component onto the form (it will be named IBCQuery1). Note that IBCQuery1.Connection will be already set to IBCConnection1;
- right click on the IBCQuery1 component and choose Fields Editor;
- right click in the editor and choose Add Fields.
After you perform these steps, you will see the connection dialog prompting connection options. The connection dialog occurs because to add fields, they must be obtained from the server. This is a correct way to work with datasets. Connection must be defined for datasets that obtain any data from the server.