Positioned Deletes

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
DavidVTaylor
Zeos Dev Team
Zeos Dev Team
Posts: 13
Joined: 04.02.2006, 05:34
Location: Virginia
Contact:

Positioned Deletes

Post by DavidVTaylor »

Just checking if anyone has worked through the details of using positioned deletes (or updates) with Zeos and Firebird. I can see there is a mechanism for defining the cursor name for a query result set. When I try to set the cursor name I get an AV since the underlying DbcStatement object does not seem to get created until after the query is opened:

Query.DbcStatement.SetCursorName('SelectedRows');

Looking at the code I get the impression that this feature is either not fully functional or perhaps I have missed something along the way. Before "fixing" the problem I thought it wise to see if this is really a design problem with Zeos or lack of understanding on my part.

BTW - This is a feature I would like to get working since it solves some touchy dependency management issues with a framework I created for selectively exporting and/or deleting object graphs in Instant Object applications. Currently I am forced to record the primary keys for all selected rows and then later come back an perform the actual deletion. With positioned updates I avoid this extra step.

David
Post Reply