<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>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>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=johnny@southshore.com
href="mailto:johnny@southshore.com">Johnny Harris</A> </DIV>
<DIV><B>Sent:</B> Sunday, March 30, 2014 8:37 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 dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Ivan,</DIV>
<DIV> </DIV>
<DIV>That was the problem with the UpdateMethod. It was readonly.</DIV>
<DIV>I added the parameters to SQLSelect so the cursor would be readwrite/server
side.</DIV>
<DIV> </DIV>
<DIV>The update completes successfully now.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thank You,</DIV>
<DIV> </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=johnny@southshore.com
href="mailto:johnny@southshore.com">Johnny Harris</A> </DIV>
<DIV><B>Sent:</B> Sunday, March 30, 2014 8:33 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 dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Below is the code I used to test the Cursor.UpdateMethod. I was trying to
update the one field only.</DIV>
<DIV>I might not be doing it correctly as I always use the SQLExecute method.
</DIV>
<DIV> </DIV>
<DIV>I updated to version 5.5.5b1 yesterday on my development server which is
Ubuntu 12.04. </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Dim cur As VCursor</DIV>
<DIV>If mData.OpenDatabase Then</DIV>
<DIV> </DIV>
<DIV> cur = mData.db.SqlSelect("SELECT * FROM support_payments
WHERE pk = '" & Me.Key & "'")</DIV>
<DIV> </DIV>
<DIV> Try</DIV>
<DIV> </DIV>
<DIV>
cur.Field("payment_amount").Value = Me.PaymentAmount</DIV>
<DIV> cur.UpdateRecord()</DIV>
<DIV> mData.CloseDatabase()</DIV>
<DIV> cur = Nothing</DIV>
<DIV> </DIV>
<DIV> Catch ex As VException</DIV>
<DIV> </DIV>
<DIV> If ex.ErrorCode > 0
Then</DIV>
<DIV>
MsgBox(ex.ErrorCode)</DIV>
<DIV>
MsgBox(ex.Message)</DIV>
<DIV> End If</DIV>
<DIV> </DIV>
<DIV> _err_msg = ex.Message</DIV>
<DIV> </DIV>
<DIV> End Try</DIV>
<DIV>Else</DIV>
<DIV> </DIV>
<DIV> _err_msg = "Connection Error: " &
mData.ErrorMessage</DIV>
<DIV> </DIV>
<DIV>End If</DIV>
<DIV> </DIV>
<DIV>If _err_msg = “” then</DIV>
<DIV> return true</DIV>
<DIV>Else</DIV>
<DIV> return false</DIV>
<DIV>End If</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 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> Sunday, March 30, 2014 8:17 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 4: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>It appears that I can update a record as long as I don’t try to update
the is_void (BOOLEAN) field.</DIV>
<DIV> </DIV>
<DIV>If I remove that field from my sql query, I can update the record all I
want. As soon I add it back to the query string... I get the error.</DIV>
<DIV> </DIV></DIV></DIV></DIV></BLOCKQUOTE>
<DIV> </DIV>Could you be more specific and show me the code - how do you do
this in particular?</DIV>
<DIV><BR>
<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>I also tried updating the record using the cursor.UpdateRecord method but
get the error code 353536. The error message associated</DIV>
<DIV>with the error code is blank, so I’m not sure what the error code
means.</DIV>
<DIV> </DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV>
<DIV apple-content-edited="true"> </DIV>
<DIV apple-content-edited="true">It is 0x56500 </DIV>
<DIV apple-content-edited="true"> </DIV>
<DIV apple-content-edited="true">
<DIV
style="FONT-SIZE: 11px; FONT-FAMILY: menlo; COLOR: rgb(0,132,0); MARGIN: 0px">//Cursor
"%S" is read only.</DIV>
<DIV style="FONT-SIZE: 11px; FONT-FAMILY: menlo; MARGIN: 0px"><SPAN
style="COLOR: #78492a">DECLARE_ERROR</SPAN>(
ERR_CURSOR_READONLY
, <SPAN style="COLOR: #272ad8">0x56500</SPAN>);</DIV>
<DIV> </DIV>
<DIV>Description absence is fixed for windows recently - do you run latest
vKernel version?</DIV>
<DIV> </DIV>
<DIV> </DIV></DIV>
<DIV><SPAN class=Apple-style-span
style="BORDER-COLLAPSE: separate; BORDER-SPACING: 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><BR>
<P>
<HR>
_______________________________________________<BR>Valentina mailing
list<BR>Valentina@lists.macserve.net<BR>http://lists.macserve.net/mailman/listinfo/valentina<BR></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>
<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>