VDN - Primary Key Constraint & Boolean Fields Question

[Johnny Harris]

Thank You Ivan,

I discovered this late yesterday evening. I was just setting the cursor to Nothing, but realized I need to call cur.Dispose to totally destroy the cursor.

It is working fine now.

Best Regards,
Johnny Harris

From: Ivan Smahin 
Sent: Monday, March 31, 2014 12:09 AM
To: Valentina Developers 
Subject: Re: VDN - Primary Key Constraint & Boolean Fields Question


On Mar 30, 2014, at 5:04 PM, Johnny Harris <johnny at southshore.com> wrote:


  Ivan,

  I can update the record now using the cursor.UpdateRecord method, but the lock stays on the record unless I close the connection (VConnection).

  Is there a way to release the lock without having  to close the connection? Sorry for such a basic question, but I can find anything in the docs.

  In my code for the Update you can see I call a CloseDatabase() method in my class, but it only closes the connection if a flag is set to True, otherwise the
  connection is kept open.


You should close (destroy) the cursor to release all the locks. 
See our examples.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



--------------------------------------------------------------------------------
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140331/416fab24/attachment.html>