B bilyx Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-03 #1 语句 select * from xxx where NO='aaa' 报错 如把NO名称改为NO1然后select * from xxx where NO1='aaa' 则正常 如何解决
L lml Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-04 #2 No是SQL保留字,见Local SQL Help中Reversed Key
L lml Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-04 #3 敲错了,应当是Local SQL Help中Reserved words主题
B bilyx Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-05 #4 ->lml 我知道这是保留字 但如何写查询语句 前提是不能改字段名
L lml Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-05 #5 让你看帮助吗,你不看 将no用引号引起来,然后在前面加上表名,比如Table.dbf.'No' = 'aaa'