内存变量应用错误
VFP+SQL:


m.dengluname="005"

TEXT TO m.HX_SQLCmd10 NOSHOW TEXTMERGE
select CAST(0 AS BIT),A.*,
P.user_name as 制单人姓名
FROM CheDuiFeiYong A
LEFT JOIN user_password P ON A.zhidanid=P.user_id
where (old_to_new = 1 and rukuid is null and A.zhidanid = m.dengluname)
ENDTEXT
?SQLEXEC(nhandle,m.HX_SQLCmd10,"CheDuiFeiYongDele_temp")

现象:如果去掉上述红色部分,值=1
如果不去掉上述红色部分,值=-1

why?




[解决办法]
假设为字符型
m.dengluname="005"

TEXT TO m.HX_SQLCmd10 NOSHOW TEXTMERGE
select CAST(0 AS BIT),A.*,
P.user_name as 制单人姓名
FROM CheDuiFeiYong A
LEFT JOIN user_password P ON A.zhidanid=P.user_id
where (old_to_new = 1 and rukuid is null and A.zhidanid ='<<m.dengluname>>')
ENDTEXT
? m.HX_SQLCmd10