Главная страница | назад

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

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?

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