[VSERVER WIN] Back to Vserver, Ouch

[Ruslan Zasukhin]

on 11/7/03 4:23 PM, Fred.Stephenson at
Fred.Stephenson at communication-unltd.com wrote:

> Hi Ruslan,
> Either I've missed something somewhere along the line, which is
> highly likely, or  we've got a problem.
> Using the latest build V4RB client and MacOSX Vserver and Win Server.
> 
> this works ie, it adds a record
> 
>  dim res as boolean
>  dim c as vcursor
>  c = mCallerWindow.MDataBase.SqlSelect("SELECT * FROM Person where
> recid=0", kV_server, kV_ReadWrite )
>   c.SetBlank       // Clear memory buffer
>  CollectPanes(c)              // Read data from panes to the fields
> of the table
> res = c.Add
>  mCallerWindow.mDataBase.flush
> 
> 
> but this doesn't
> 
> dim res as boolean
>  dim c as vcursor
>  c = mCallerWindow.MDataBase.SqlSelect("SELECT * FROM Person where
> recid=0", kV_client, kV_ReadWrite )
>   c.SetBlank       // Clear memory buffer
>  CollectPanes(c)              // Read data from panes to the fields
> of the table
> res = c.Add
>  mCallerWindow.mDataBase.flush
> 
> Do cursors have to be "server" to add and update records ???

YES of course!
 
> If so where does it say it in the docs??

I think it is said at least that Client Cursor ALWAYS is READ ONLY!

It get N records to RAM of client computer, and server forget about this
client. In this way work mySQL and others.

Only server side cursor can modify records.

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------