[SQL] Client and server cursors

jda jda at his.com
Tue Mar 4 16:27:10 CST 2003


>
>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...
>
>-----
>As for me I think this is really MORE EASY and more comfortable way,
>Then generate new SQL string for command.
>
>And this looks to be more effective, because again,
>-- you do not spend time and resources to build SQL string
>-- server do not spend time to parse it.
>
>Data simply go by special protocol in binary form from client to server.
>

I'm very naive about db design and function. With that caveat, I 
think it looks very intuitive. ;->

Jon


More information about the Valentina mailing list