RE: Insert into a pervasive db

> Yes - I work with Pervasive quite a bit. One thing you have to watch when > doing INSERTs is using ";" to terminate your statement. For example: > > INSERT INTO MyTable(MyColumn) > VALUES('MyData'); > > won't work. Are you actually using the brackets around your list > of columns? > Otherwise, I

Re: Insert into a pervasive db

columns? Otherwise, I've haven't found any other problems. Regards, Chris - Original Message - From: "Marcus" <[EMAIL PROTECTED]> To: "Cf-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 03, 2000 10:59 AM Subject: Insert into a pervasive db >

Insert into a pervasive db

Has anyone ever worked with a pervasive db? I linked to it ok, and now I want to do an insert. My normal insert would use the syntax.. Insert INTO tablename [(columns, ...)] VALUES(values, ...) However... that just gives me a syntax error... any help? Marcus --