Marcus,
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'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
> 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
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
