[SQL] Client and server cursors

[john roberts]

on 3/4/03 4:08 PM, Ruslan Zasukhin at sunshine at public.kherson.ua 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 )
> 
> Now if you want do modifications of records you can do simply:
> 
> curs.Stringfield( "name" ) = 'something new'
> curs.Update();  <<<<<<<< this send command to server.
> 
> €€>> What you think about this approach ?
> €€>> Anybody see any potential problems with this ?
> **>> I do not remember if any other db use this way? IT seems I have see
> always generation of new SQL command in background...

I presume this means that only changes are written back to the database.
If so, it is neat and clean. I like that.

John Roberts