Subject Re: [IBO] TIBOQuery and selectable SP
Author Helen Borrie
At 10:55 PM 14/01/2004 +0100, you wrote:
> > the error message is 'Invalid request handle'.
>Here is how I open the query
>procedure TDataModule2.waGET_MY_PROJECTSExecute(Sender: TObject);
> with IBO_QRY_MY_PROJECT do begin
> if not prepared then prepare;
> IBO_QRY_MY_PROJECT.RequestLive := true;

RequestLive only works on a query on a single physical table and causes IBO
to generate xxxSQL dynamically at Prepare time. Because this is not an
updatable dataset, the first automatic xxxSQL statement that IBO tries to
prepare to comply with RequestLive results in this error.

Refer back to my very detailed responses earlier in the week, where I
explained to you about RequestLive and how to make a non-updatable dataset

For future reference, set RequestLive true when you have a genuinely
updatable dataset; in all other cases, provide xxxSQL properties for each
xxx operation that you want to enable.