RE: [sqlite] Duplicate Row check

If you can, define one of the data entries in your table (Schema defination) as "unique" when you create the table. The engine will then set an error condition (call the callback function) and this should prevent you from entering duplicate data and hence duplicate rows. Michael -Original

[sqlite] Ascii data in string treated as a num

',\'%s\',\'%s\');", evalue, pt[0], pt[1], pt[2], pt[3], pt[4]); Example: INSERT INTO P VALUES( 21,'0E00','','7E00','1234','NOVALUE'); Returned: 21, '0','0','7','1234','NOVALUE' Michael Flum Software Engineer Haas Automation, Inc.