> I think I have now discovered the error in updating the data on the postgres > database. The sqlquery is passing a bad string to the postgres database > engine. In my case the the following is passed: > Update arcust set custno = 'BRS', company = 'Blue Ribbon Stairs' where > (custno=BRS) > > Notice that the BRS lacks single quotes. It should be (custno='BRS').
Can you add a bug-report for this here http://www.freepascal.org/bugs/add.php3 Else I might forget to fix it. > The append works - the insert statement was perfect. In the mean time, define a numerical field as the primary key. It's quite uncommon to use a string-field as the primary key. Joost _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives