August 30th, 2002, 04:17 PM
Syntax Error thrown on basic SQL Statement
Would someone PLEASE explain to me why this throws a syntax error when executed on an Access database?
(->) just indicates continued from last line.
INSERT INTO c_summs_index(TABLE, CYCLE, KEYWORD)
-> Values('tablename', 30922, 'Buick')
I swear I'm losing it here... I can't figure out what's wrong with this SQL...
August 30th, 2002, 04:46 PM
Don't have Access available right now, but 'TABLE' should be a reserved word in Access... Can you escape it with backticks or similar? Or just chose another column name?
UN*X is sexy!
who | grep -i blonde | date; cd ~; unzip; touch; strip; finger; mount; gasp; yes; uptime; umount; sleep
August 30th, 2002, 04:54 PM
Ah... it would seem that gratuitous slapping of the forehead is in order.....
Thanks for pointing out my er... "problem", even if it wasn't EXACTLY in the SQL...