[VSDK] VDK_Cursor::Update() broken?

Ruslan Zasukhin sunshine at public.kherson.ua
Thu Jan 8 09:54:04 CST 2004


on 1/8/04 5:01 AM, Eric Forget at forgete at cafederic.com wrote:

Hi Eric,

> On a related problem I found that if I execute:
> 
>   myDB->SqlExecute("DELETE FROM Table2");
>   my->SqlExecute("INSERT INTO Table2 ( Code ) SELECT DISTINCT Field1 FROM
> Table1 WHERE Field1 <> ''");
> 
> All the field of Table1 are now locked until I quit the application. I don't
> see why they need to be locked. As far as I understand, this is a one time
> task and no cursor needs to be preserved?

Aha,

1) INSERT in this case use self cursor.
    and probably this cursor set ReadLocks.

May be I have not delete this cursor...


2) what means ALL FIELDS of T1 are locked?
    you mean 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
-------------------------------------------------------------



More information about the Valentina mailing list