This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 我用CBuilder 5.0,通过BDE microsoft access ODBC driver 取MS ACCESS里面的数据，有一个表里面的一个field name是comopleted?， 带问号，在我程序里面的ＳＱＬ就写不出来，加引号，［］都不管用。我用CBuilder 5.0,通过BDE microsoft access ODBC driver 取MS ACCESS里面的数据，有一个表里面的一个field name是comopleted?， 带问号，在我程序里面的ＳＱＬ就写不出来，加引号，［］都不管用。
请问，这种特殊符号应该怎么写ＳＱＬ
-rainzw(rainzw);
2005-2-17
{222}
(#2130407@0)
-
how about: select `completed?` from tablename
-canadiantire(轮胎-正点下班);
2005-2-17
(#2130440@0)
-
Invalid Use of ',','!',"()' in query expression --- General SQL error
-rainzw(rainzw);
2005-2-17
(#2130528@0)
-
I think something wrong with BDE or ODBC, it thinks the "?' is a sign for parameter. However, the query select [selected?] from table works well in ADO, just tried, d5/ado
-jchonc(James);
2005-2-17
(#2130607@0)
-
I can type [Completed?] in TQuery Filter Property, but just can't use it in SQL.
-rainzw(rainzw);
2005-2-17
(#2130660@0)
-
Haven't used CBuilder for years, but can you try "completed\? " ?
-sammy(733 days);
2005-2-17
(#2130853@0)
-
doesn't work. SQL: SELECT Workorders.Completed? FROM "Workorders"
-rainzw(rainzw);
2005-2-18
(#2132113@0)
-
Filter is local, has nothing to do with odbc.
-jchonc(James);
2005-2-17
(#2131163@0)