<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>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>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>Best Regards,</DIV>
<DIV>Johnny Harris</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=johnny@southshore.com
href="mailto:johnny@southshore.com">Johnny Harris</A> </DIV>
<DIV><B>Sent:</B> Sunday, March 30, 2014 6:53 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>Hello Ivan,</DIV>
<DIV> </DIV>
<DIV>Yes, the pk field is causing the error I believe. It is the primary key
field for the table.</DIV>
<DIV>I never try to change it. I only reference it for updates, deletions and
lookups. I’m assuming this</DIV>
<DIV>is the field that is causing the error, but I’m not sure. Sometimes I can
update a record with no </DIV>
<DIV>problem. Other times trying to update a record throws the exception, but
I’ve not found a definite</DIV>
<DIV>reason why. I’m looking through my code some more this morning. I will
reply back if I find something</DIV>
<DIV>in my code causing the issue.</DIV>
<DIV> </DIV>
<DIV>I was just curious about the BOOLEAN type. It’s fine indexed if there’s no
cost. Not a problem.</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> Sunday, March 30, 2014 3:49 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:29 AM, Johnny Harris <<A
href="mailto:johnny@southshore.com">johnny@southshore.com</A>>
wrote:</DIV><BR class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: calibri">
<DIV style="FONT-FAMILY: ; COLOR: ">
<DIV>Greeting Everyone,</DIV>
<DIV> </DIV>
<DIV>1. I’m getting an error when I try to update a table record using
SQL.</DIV>
<DIV> </DIV>
<DIV>Error: Primary key constraint violation occurred, table name =
“support_payments”, constraint name = “PK_support_payments_pk”.</DIV>
<DIV> </DIV>
<DIV>I don’t get this error every time I try to update a record. Just
occasionally. I’m not trying to update the primary key field, so I’m not
really</DIV>
<DIV>sure why I’m receiving this error.</DIV>
<DIV> </DIV>
<DIV> </DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE>
<DIV> </DIV>I will check this once more. But we are speaking about this
field <SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: calibri">pk SERIAL64 PRIMARY
KEY ?</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: calibri"><BR></SPAN></DIV>
<DIV><BR>
<BLOCKQUOTE type="cite">
<DIV dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: calibri">
<DIV style="FONT-FAMILY: ; COLOR: ">
<DIV> </DIV>
<DIV>2. When I create a table in code, the fields I define as BOOLEAN are
Indexed by default. I don’t need the fields indexed.</DIV>
<DIV> </DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>Actually, "automatic" indexed flag for boolean field costs
nothing to you due to the specific implementation.
<DIV>Why do you need to have it not-indexed?</DIV>
<DIV><SPAN style="ORPHANS: 2; WIDOWS: 2"><BR></SPAN></DIV>
<DIV><SPAN style="ORPHANS: 2; WIDOWS: 2">-- </SPAN><BR>
<DIV>
<DIV apple-content-edited="true"><SPAN class=Apple-style-span
style="BORDER-COLLAPSE: separate; BORDER-SPACING: 0px">
<DIV>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></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>