Invalid UPDATE command

Mr. Vage · April 14th, 2007, 04:39 PM

I have an Access database that I need to modify using SQL commands. I want to update a row in the Settings table, but my SQL command isn't working:

Code:

UPDATE Settings SET Value='test' WHERE Name='LastRetrievalTime';

I can retrieve data just fine using this SELECT command though:

Code:

SELECT Value FROM Settings WHERE Name='LastRetrievalTime';

Can someone tell me what is wrong with my UPDATE command?

Thanks in advance.

Imar · April 14th, 2007, 04:44 PM

Hi there,

Can you define " isn't working"? Do you get an error? If so, which one?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Mr. Vage · April 14th, 2007, 04:47 PM

"Syntax error in UPDATE statement."

Imar · April 14th, 2007, 04:53 PM

Hmmm, maybe one of your columns has a reserved name? Try renaming them, or try this:

UPDATE [Settings] SET [Value]='test' WHERE [Name]='LastRetrievalTime';

Personally, I would stay away from column and table names that look like reserved words. Somehow, Settings, Value and Name all seem to sound like a system reserved word....

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Mr. Vage · April 14th, 2007, 05:59 PM

Thank you, that fixed it.