Made the change

RequestLive := false;

but the problem is still there. Any other suggestions?

Ronan van riet

----- Original Message -----
From: Daniel Rail
To: IBObjects@yahoogroups.com
Sent: Wednesday, January 14, 2004 11:06 PM
Subject: Re: [IBO] TIBOQuery and selectable SP


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)



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]