<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<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>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>The code I’m using to create the table:</DIV>
<DIV> </DIV>
<DIV>sql = "CREATE TABLE IF NOT EXISTS support_payments (pk SERIAL64 PRIMARY
KEY, " & _</DIV>
<DIV> "account_key LLONG INDEXED DEFAULT '0', " & _</DIV>
<DIV> "support_year LONG DEFAULT '0', " & _</DIV>
<DIV> "payment_amount DECIMAL(10, 2) DEFAULT '0.00', " &
_</DIV>
<DIV> "received_date DATE DEFAULT '01/01/1900', " &
_</DIV>
<DIV> "sent_date DATE DEFAULT '01/01/1900', " & _</DIV>
<DIV> "post_marked_date DATE DEFAULT '01/01/1900', " &
_</DIV>
<DIV> "payment_ref VARCHAR(30), " & _</DIV>
<DIV> "payment_memo VARCHAR(250), " & _</DIV>
<DIV> "is_void BOOLEAN DEFAULT '0', " & _</DIV>
<DIV> "record_ts DATETIME NOT NULL)"</DIV>
<DIV> </DIV>
<DIV>If anyone might have some pointers on either of these, it would be much
appreciated.</DIV>
<DIV>I’m going to keep scanning the documentation to see what I can figure out.
I’m very</DIV>
<DIV>new with Valentina so no telling what all I’ve missed.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Johnny Harris</DIV></DIV>
<DIV></DIV></DIV></DIV></BODY></HTML>