Thanks Jason,
If this clause, then, is added to the SQL property of an IB_Query component,
does the component use this method of update? The generated SQL for update
for the query does not imply this method as being used. Or is there another
setting for utilising this method of update?
Alan

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, 10 December 2002 3:55 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] For UPDATE clause?


This is how you tell InterBase to maintain a live cursor such that it will
increment a pointer on the server one record at a time instead of batching
records together into packets for efficiency. Because the server is
maintaining a record pointer to the row just fetched it gives you the
opportunity to perform an update statement like this:

UPDATE atable
SET acol = aval
WHERE CURRENT OF acursorname

This eliminates the need to have a searched record but instead it goes
immediately and directly to the current record pointer and performs the
update.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, December 08, 2002 4:59 AM
Subject: [IBO] For UPDATE clause?


> I see occasionally the clause "FOR UPDATE" in the SQL box. Must ahve
missed
> reading the explanation for it. Can someone enlighten me?
> Alan




___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/