> 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.
It was stupidity on my part. I was doing everything right, but I was
forgetting to surround my strings with single quotes, hence the syntax
error.
Biggest problem was my arogance thinking, "Can't be me... I've written
insert queries for 10 years... must be a unique syntax to the DB."
Thanks for the assist...
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.
