Article #15103: Using Date as a Field Name

 Question and Answer Database
FAQ103C.txt Using Date as a Field Name
Category :Database Issues
Platform :All
Product :C++Builder 1.x
Question:
I have a field called DATE and when I do a Query on the
table with the SQL Statement SELECT DATE FROM "tablename.db"
I get an error "Invalid use of Keyword. Token: DATA line 1"
What is the problem?
Answer:
Never name a Field "Date". Date is a Keyword in SQL and therefore
SQL statements that use the word in the wrong way will throw
this error.
7/2/98 10:32:32 AM

Last Modified: 01-SEP-99