PLEASE HELP (2) 1

[Kolelol]

Hi again !!!
Here is the second problem. (I am using Delphi 3.0 Client/Server Suite.)
I have a table from a database with a field called Position.
When I write SQL for a Query component which is (not complete) : SELECT Position ....
I get the message : Inapropriate use of a keyword (or something similar). Is Position a SQL keyword? I don't want to change the name of the field because my program is already big and I have to change a lot of code. What can I do ???
Please help.

 

[svanels]

Which database you use, I know that position is a reserved word in Interbase, it is used in triggers and generators S. van Els
SAvanEls@cq-link.sr

 

[StevenK]

If you have any field name that is a reserved word in the database being used then it can be worked round by bounding the column name (sometimes by single quotes, double quotes or [] characters according to the database - attempt these variations until you find the correct usage). This can then get round the issue of the reserved words being prevented from used in the SQL syntax.
Hope that this helps.
Steve

 

[Kolelol]

I am using Paradox 7 table. To access a table's field which is a reserved word you have to include the tables name plus the field in double quotes (e.g. table Member field Position ---> Member."Position&quot
Thank you for your help.