VFP连续打印问题 20
A1=VAL(thisform.text4.value)A2=VAL(thisform.text5.value)SELETAOLSETORDERTODHCHAA_=VAL...
A1=VAL(thisform.text4.value)
A2=VAL(thisform.text5.value)
SELE TAOL
SET ORDER TO DHCH
AA_=VAL(单号)
sele * from taol WHERE A1<=AA_ AND AA_<=A2 INTO CURSOR KK1
sele KK1
repo form RPT\taol prev
为什么运行 提示 sele * from taol WHERE A1<=AA_ AND AA_<=A2 INTO CURSOR KK1
这个 数据类型 错误啊`~
单号是 表 TAOL 里面的字段~为字符型的~~ 展开
A2=VAL(thisform.text5.value)
SELE TAOL
SET ORDER TO DHCH
AA_=VAL(单号)
sele * from taol WHERE A1<=AA_ AND AA_<=A2 INTO CURSOR KK1
sele KK1
repo form RPT\taol prev
为什么运行 提示 sele * from taol WHERE A1<=AA_ AND AA_<=A2 INTO CURSOR KK1
这个 数据类型 错误啊`~
单号是 表 TAOL 里面的字段~为字符型的~~ 展开
1个回答
展开全部
A1=VAL(ALLTRIM(thisform.text4.value))
A2=VAL(ALLTRIM(thisform.text5.value))
SELE TAOL
sele * from taol WHERE VAL(ALLTRIM(单号))>=A1.and.VAL(ALLTRIM(单号))<=A2 order by 单号 into CURSOR KK1
SELECT kk1
REPORT FORM rpt/taol prev
注意:报表数据环境不要添加表
另外报表域控件表达式
如果是单号字段,那么双击它表达式改成单号不要带表名。
A2=VAL(ALLTRIM(thisform.text5.value))
SELE TAOL
sele * from taol WHERE VAL(ALLTRIM(单号))>=A1.and.VAL(ALLTRIM(单号))<=A2 order by 单号 into CURSOR KK1
SELECT kk1
REPORT FORM rpt/taol prev
注意:报表数据环境不要添加表
另外报表域控件表达式
如果是单号字段,那么双击它表达式改成单号不要带表名。
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询