Delphi:Paradox DB字段名称问题(字段名称中有空格)
问题描述：
我有一个来自旧系统的悖论表，我需要对其进行单个查询.字段名称中包含空格-即街道1".当我尝试在delphi中仅对街道1"字段制定查询时，出现错误-关键字使用无效.令牌:1，行号:1
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-对象Pascal，标准Tquery对象名称query1.
Delphi V7 - object pascal, standard Tquery object name query1.
答
您需要在查询中为字符串加上表名作为前缀.
You need to prefix the string with the table name in the query.
例如:字段名称为"Street 1"，表称为客户，选择为:
For example: field name is 'Street 1', table is called customers the select is:
SELECT customers."Street 1" FROM customers WHERE ...