SET EXACT ON
create cursor T1 (NO C (20))
SELE T1
APPE BLANK
REPLACE NO WITH "123"
APPE BLANK
REPLACE NO WITH "1234"
APPE BLANK
REPLACE NO WITH "1235"
APPE BLANK
REPLACE NO WITH "1236"
SELECT * FROM T1 WHERE ALLT(NO)='123' INTO CURSOR T2
可以看到T2中有四条记录,我设置了SET EXACT ON,应该只有一条啊?
------解决方案--------------------------------------------------------
VFP Help: Unlike SET ANSI, SET EXACT does not apply to Visual FoxPro SQL commands.
SET EXACT 对VFP的SQL命令无效。
------解决方案--------------------------------------------------------
sql 语句的比较规则与 set ansi 设置有关,应该先 set ansi on