[V4MD] Stopping character remapping

[Ruslan Zasukhin]

on 9/16/03 4:00, Deane Venske at dean at eduss.com wrote:

Hi Deane,

> I just wanted to clarify something for myself. I've had some troubles
> deleting from a database using SQL. Now I've nailed it down to the
> following scenario :
> I have a global property in RB that I use for all my cursors (To save
> redeclaring them all the time). I've not been setting the cursor to Nil
> when I'm done with it.
> So this is the problem :
> When I have a cursor open that's done for instance "SELECT * FROM
> userID" and I try to do "DELETE * FROM userDetails" it fails. If I
> create a SELECT on userDetails or set the cursor to Nil then the delete
> works.

This is right. Because your cursor have set LOCKS on its records.

> So my conclusion is that if you have an active cursor that's affecting a
> specific table, you cannot do an SQL query to delete from another table.

Or to UPDATE that locked records.

> Are my assumptions correct and do I need to clear my cursor, or force
> myself to redeclare the cursor variable each time I use it?

Yes.

Or you can use that cursor itself to DELETE its records.

Or you can create cursor that DO NOT lock 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
-------------------------------------------------------------