SQL Update/Insert Reserved Words

[trims30]

Having a problem with UPDATE and INSERT command.

Have database with fields named ID, Serial, By, Date

SQL Update Command:
UPDATE Transactions SET Serial="1234",By="Lee",Date="11/01/2009" WHERE ID=2101

Command fails due to improper syntax.

Traced it to fields "BY" and "DATE"
If I modify Database field Names to "sBY" and "sDATE" and change SQL accordingly it works fine.

Is there a way to use BY and DATE as field names?

Any help would be appreciated.

Lee

 

[r937]

yes, there is a way to use BY and DATE as field column names

since you posted in the ANSI SQL forum, here's the ANSI SQL answer --

"BY" and "DATE"

this may or may not work in your particular database system

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[trims30]

Using MS Access database - tried "BY" - no luck - [BY] and [DATE] will work.

Thanks for pointing me in right direction.

Lee