I build a regression test for your specific case and it should work as long
as things are setup properly.

A another possibility is when you set the SQL property the RequestLive
property could have been set to false. Be sure RequestLive is true and that
it remains true after the SQL text is changed. You can also include the FOR
UPDATE clause on your SQL text and it will set the RequestLive property to
true by way of that.

Hope this helps,
Jason Wharton
www.ibobjects.com


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, February 9, 2015 11:01 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Insert problem/question upgrading from v4.8

Hello,



I am upgrading a program from delphi7, ibo v4.8 to the newest ibo v5.5.5.



I have come across a section of code where a query contains



SELECT *

FROM ORDERSM

WHERE OM_ID = :ID



the Delphi code does the following



qyOrdersM.Insert;

xOM_ID := qyOrdersM.FieldByName('OM_ID').AsInteger;

qyOrdersM.FieldByName('OM_CONSOLIDATED_ID').AsInteger:=xOM_ID;

qyOrdersM.FieldByName('OM_CUS_ID').AsInteger := xKeyCustomer;

qyOrdersM.Post;



qyOrdersM.Edit;



the edit is causing an exception of

"Cannot Edit current Row"



I know that the code was working before the upgrade of IBO.



-------------------------------------

I can fix this by inserting the following 3 lines before the "Edit"

qyOrdersM.Close;

qyOrdersM.ParamByName('ID').AsInteger := xOM_ID;

qyOrdersM.Open;





But is this the best way to handle it?





Are there any other problems I am likely to run into while doing the
conversion?



Thanks

Michael Horne





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



------------------------------------
Posted by: "Michael Horne" <guardian_yahoo@...>
------------------------------------

___________________________________________________________________________
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 !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------

Yahoo Groups Links