Field Name with Question Mark (?)

[rainzw]

我用CBuilder 5.0,通过BDE microsoft access ODBC driver 取MS ACCESS里面的数据，有一个表里面的一个field name是comopleted?，　带问号，在我程序里面的ＳＱＬ就写不出来，加引号，［］都不管用。

请问，这种特殊符号应该怎么写ＳＱＬ

 

[胖蹄阿克]

???是非英语字符吧

 

[rainzw]

最初由 胖蹄阿克 发布
???是非英语字符吧

yes, but it is allowed in MS Access. In TQuery, I can write [Completed?] = 'TRUE' in filter property, but just can't write it in SQL statement.

 

[shusheng]

How about backslash? like

Completed\?

 

[canicula]

我不知道？是否允许
不过你也许可以试试把encode language改成某个欧洲语言试试
俄语什么的

 

[http_www]

1. jbuilder or cbuilder?
2. i can read data (select), but never try write(insert). (in java)

 

[rainzw]

最初由 shusheng 发布
How about backslash? like

Completed\?

doesn't work.

 

[rainzw]

最初由 http_www 发布
1. jbuilder or cbuilder?
2. i can read data (select), but never try write(insert). (in java)

Borland C++Builder5
SQL:

SELECT Workorders.Completed?
FROM "Workorders"

doesn't work.

 

[http_www]

最初由 rainzw 发布


Borland C++Builder5
SQL:

SELECT Workorders.Completed?
FROM "Workorders"

doesn't work.

what is the err message?

try select * from table
then get the Completed? field data

 

[Emperor]

use chr(63) instead of ?. Chr(63) is under VB.