Subject Re: [IBO] Connection ok in IDE but exception when run
Author Helen Borrie
I had asked:
> > Is there any special reason why you are jumbling up the native IBO
> > components (IB_Connection and IB_Transaction) with the TDataset-compatible
> > data access and IP controls?

At 09:31 PM 30-09-02 +0930, Raymond Kennington wrote:

>I started with a TIB_Query and TIB_Grid connected the
>Connection&Transaction, but I
>couldn't edit the data in the grid so I connected an InfoPower grid to the
>connection & transaction components, which also cannot be edited.

That seems to suggest that it's not a matter of wrong controls, but one or
more of the following:

You have a "regular" query but RequestLive is set False.

You have no KeyLinks set for the dataset.

You have a query which is (by database rules) non-updatable and you have
not supplied statements to the InsertSQL, EditSQL and DeleteSQL properties.

And, now that you are using TDataset-compatible stuff, you might still have
a TIB_Datasource in the mix - needs to be replaced with TDatasource.

Aside from resolving your updating problem, may I suggest that, if using
TIBOTable (ughhh!) and InfoPower controls, you replace the IB_Connection
and IB_Transaction with a TIBODatabase? If/when you need additional
transactions, you can add TIBOTransaction (not TIB_Transaction) objects.