Fieldnames with minus sign in SQl statement

[BasSchouten]

I have a table with field names containing minus-signs like

art-fabr

if i try to use these fieldnames in a SQL-statement of a TAdsQuery object it sees the minus sign as a minus sign and tell me it can't find the field "art"

does anybody know a way to avoid this??
(by the way: renaming the fields is not an option) Bas Schouten
System Development & Webdesign
CBIS BV Holland

http://www.cbis.nl

 

[goodmanrAy]

Try putting square brackets around the field names i.e. [art-fabr]

 

[BasSchouten]

well, I thought I had tried any logical characters like single quote, double quote, back quote, brackets, parentheses and any combination of them ... but it didnt work.

Then suddenly the double quotes seeemed to work!!!

So I guess I have doen something wrong, but the solution is using double quotes:

table."field-name"

Bas Schouten
System Development & Webdesign
CBIS BV Holland

http://www.cbis.nl

 

[LucieLastic]

Did you try it with like this

[table.fieldname]

GoodmanrAys friend

 

[StevenK]

I use

.[fieldname] and this works ...
Steve

 

[LucieLastic]

Steven, you're right. It's too early for me...