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





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