devxlogo

Field Names Are Invalid

Field Names Are Invalid

Question:
I’m using SQL queries in Delphi 4 to access a database. Some of the field names in the database are either reserved keywords or invalid in some way (for example, “%ON”). How do I get around this problem?

Answer:
Sorry, there is no easy way to fix this. You will need to redesign the schema to eliminate reserved words and special characters from the column names.

devx-admin

Share the Post: