Delphi: Paradox Db Field Name Issue (spaces In Field Name)

I have a paradox table from a legacy system I need to run a single query on. The field names have spaces in them - i.e. 'Street 1'. When I try and formulate a query in delphi for

Solution 1:

You need to prefix the string with the table name in the query.

For example: field name is 'Street 1', table is called customers the select is:

SELECT customers."Street 1" FROM customers WHERE ...

Solution 2:

You normally need to quote the field name in this case. For example:

select * from t1 where "street 1" = 'test';

I tried this on a paradox 7 table and it worked. If that doesn't help, can you post the query you are trying to use? It would be easier to help with that info.

Solution 3:

I think you must use [ and ] instead of ":

SELECT customers.[Street 1] FROM customers WHERE ...