[SQL] Client and server cursors // FOR UPDATE

[Ruslan Zasukhin]

on 3/5/03 3:49 AM, Andreas Grosam at agrosam at computerworks.ch wrote:

>> What we try now implement for Valentina is ability to use the SAME cursor
>> API, that we use for local dbs.
>> 
>> So this looks as
>> 
>>    curs = db.SqlSelect( "SELECT ...", ReadWrite, kClient )
> 
> Alternatively, if we want an updateable cursor, we could specify this through
> issueing the query command with the "FOR UPDATE" clause:
> Cursor c = db.SqlSelect("SEELCT * FROM T WHERE ID = 100 FOR UPDATE");
> 
> This has the advantage, that the command string can be retrived from anywhere
> - for instance a SQL console program - and which then creates the appropiate
> cursor.

Correct,

Just I talk now about nearest Server Alpha.,
That is based on 1.x kernel.

Yes for final release with new SQL parser we will have this way also..
And then I am not sure if we need leave in API that parameters...
 
> -> yields to an updateable cursor - provided, the relation is inherently
> updateable, too - which in this example is the case.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------