Subject | Re: [IBO] Newbie: "Cannot prepare a blank statement" |
---|---|
Author | Helen Borrie |
Post date | 2006-02-14T10:57:42Z |
At 07:21 PM 14/02/2006, you wrote:
2. Remove the TIBOTransaction for now. There is a default one built
into the TIBODatabase. It will be sufficient just to pick up your
IBODatabase1 for the IB_Connection property and the components will
take care of the transaction.
Dataset property to IBOTable1.
Then set the TDBGrid's Datasource property to that Datasource.
If you are a complete newbie to data programming with Delphi, you'll
need to study the Delphi help for the VCL data access
components. The VCL equivalent of TIBOTable is TTable.
Then put "learn SQL" next in your priorities. TIBOTable will be OK
for you to cut your teeth on, using small tables such as those in
employee.fdb, but you won't get far in client/server programming
without knowing SQL.
Helen
>I'm just starting out with Delphi & evaluation of IbObjects and I want1. Do you have a table defined in the IBOTable?
>to stick to the TIBOxxx components. But I can't connect to a table. On
>the form I have:
>
>IBODatabase1:
>Connected = true.
>
>TIBOtransaction:
>IB_Connection = IBODatabase1
>
>IBOTable1:
>IB_Connection = IBODatabase1
>IB_transaction = tr
>
>When I make IBOTable1 "Active" = true I keep getting the error message
>above.
2. Remove the TIBOTransaction for now. There is a default one built
into the TIBODatabase. It will be sufficient just to pick up your
IBODatabase1 for the IB_Connection property and the components will
take care of the transaction.
>Also, if I can connect to the table, how do I get a datasource for useDrop in a TDatasource from Delphi's Data Access palette and set its
>in the TDBGrid?
Dataset property to IBOTable1.
Then set the TDBGrid's Datasource property to that Datasource.
If you are a complete newbie to data programming with Delphi, you'll
need to study the Delphi help for the VCL data access
components. The VCL equivalent of TIBOTable is TTable.
Then put "learn SQL" next in your priorities. TIBOTable will be OK
for you to cut your teeth on, using small tables such as those in
employee.fdb, but you won't get far in client/server programming
without knowing SQL.
Helen