Delphi:Paradox DB字段名称问题(字段名称中有空格) [英] Delphi: Paradox DB Field Name Issue (Spaces in field name)

问题描述

我有一个来自旧系统的悖论表，我需要对其进行单个查询.字段名称中包含空格-即街道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 ...

这篇关于Delphi:Paradox DB字段名称问题(字段名称中有空格)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！