VCursor Changes Locking Type

Sims, John (CDC/NCBDDD/DBDDD) (CTR) ayu8 at cdc.gov
Tue Jun 27 11:11:58 CDT 2006


> Seems like we're back to that problem I encountered earlier, 
> the call is not generating a ReadWrite VCursor. Instead it 
> results in a ReadOnly VCursor.
> 
> Here's the call....
> 
>    thisCursor = App.tDatabase.SQLSelect(sqlString,
> EVCursorLocation.kClientSide, EVLockType.kReadWrite,
> EVCursorDirection.kRandom)
> 
> Where:
> 
> sqlString = "SELECT recID, * FROM tbl_test"
> 
> 
> Is there anything you can see wrong with it?
> 
> Regards,
> 
> Chuck

Hi Chuck,

If I remember correctly, you have to use EVCursorLocation.kServerSide
for writable cursors.  I'm sure Ruslan will correct me if I am wrong.

-John


More information about the Valentina mailing list