Hi,

At January 14, 2004, 17:55, Ronan van Riet wrote:

> Here is how I open the query

> procedure TDataModule2.waGET_MY_PROJECTSExecute(Sender: TObject);
> begin
> with IBO_QRY_MY_PROJECT do begin
> if not prepared then prepare;

> IBO_QRY_MY_PROJECT.RequestLive := true;
> IBO_QRY_MY_PROJECT.Open;
> end;
> end;

You can't have RequestLive:=True with a selectable SP, it's not
updatable. Set RequestLive to False and then it should work.

If you want to update the data returned by the SP, then enter the
appropriate DML statements in the InsertSQL, EditSQL and DeleteSQL
properties of TIB_Query.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)