<HTML><HEAD>
<META content="text/html charset=windows-1252" http-equiv=Content-Type></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Thank You Ivan,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>It is working fine now.</DIV>
<DIV> </DIV>
<DIV>Best Regards,</DIV>
<DIV>Johnny Harris</DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'>
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title=ivan_smahin@paradigmasoft.com
href="mailto:ivan_smahin@paradigmasoft.com">Ivan Smahin</A> </DIV>
<DIV><B>Sent:</B> Monday, March 31, 2014 12:09 AM</DIV>
<DIV><B>To:</B> <A title=valentina@lists.macserve.net
href="mailto:valentina@lists.macserve.net">Valentina Developers</A> </DIV>
<DIV><B>Subject:</B> Re: VDN - Primary Key Constraint & Boolean Fields
Question</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'>
<DIV> </DIV>
<DIV>
<DIV>On Mar 30, 2014, at 5:04 PM, Johnny Harris <<A
href="mailto:johnny@southshore.com">johnny@southshore.com</A>>
wrote:</DIV><BR class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: calibri">
<DIV>Ivan,</DIV>
<DIV> </DIV>
<DIV>I can update the record now using the cursor.UpdateRecord method, but the
lock stays on the record unless I close the connection (VConnection).</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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</DIV>
<DIV>connection is kept open.</DIV>
<DIV> </DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>You should close (destroy) the cursor to release all the locks.
<DIV>See our examples.</DIV>
<DIV>
<DIV> </DIV>
<DIV><SPAN class=Apple-style-span
style="FONT-FAMILY: helvetica; FONT-VARIANT: normal; WHITE-SPACE: normal; WORD-SPACING: 0px; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; FONT-WEIGHT: normal; COLOR: rgb(0,0,0); FONT-STYLE: normal; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; LINE-HEIGHT: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">
<DIV>-- <BR>Best regards,<BR>Ivan Smahin<BR>Senior Software
Engineer<BR>Paradigma Software, Inc<BR>Valentina - The Ultra-Fast Database<BR><A
href="http://www.valentina-db.com/">http://www.valentina-db.com</A></DIV></SPAN></DIV>
<DIV> </DIV></DIV>
<P>
<HR>
_______________________________________________<BR>Valentina mailing
list<BR>Valentina@lists.macserve.net<BR>http://lists.macserve.net/mailman/listinfo/valentina<BR></DIV></DIV></DIV></BODY></HTML>