Subject | Re: [IBO] Connection ok in IDE but exception when run |
---|---|
Author | Helen Borrie |
Post date | 2002-09-30T12:18:33Z |
I had asked:
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.
Helen
> > Is there any special reason why you are jumbling up the native IBOAt 09:31 PM 30-09-02 +0930, Raymond Kennington wrote:
> > components (IB_Connection and IB_Transaction) with the TDataset-compatible
> > data access and IP controls?
>I started with a TIB_Query and TIB_Grid connected theThat seems to suggest that it's not a matter of wrong controls, but one or
>Connection&Transaction, but I
>couldn't edit the data in the grid so I connected an InfoPower grid to the
>existing
>connection & transaction components, which also cannot be edited.
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.
Helen