Field name with # causes TDataSet Filter error

[trollacious]

Just learning about database programming, and I ran across something I haven't been able to find anything that addresses this situation here or on Google. Several of the field names of existing databases (using BDE and Paradox drivers) have a pound sign # as a character.

When I try to set the TDataSet Filter property with a string containing the #, I get an error message. With a field named REC#, the error message is "Field REC cannot be found". If the Filter property strips off the #, how do I escape that character or otherwise overcome this?

Lee

 

[trollacious]

I found the answer at

http://www.prestwood.com/aspsuite/kb/document_view.asp?qid=100236#Reader_Blog

This says that any fields with strange characters in them need to be surrounded by square brackets: '[REC#]'.

Lee