sql - Delphi: Paradox DB Field Name Issue (Spaces in field name)

Question

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 only the "Street 1" field, I get an error - Invalid use of keyword. Token: 1, Line Number: 1

Delphi V7 - object pascal, standard Tquery object name query1.

Answer 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 ...