SQL:找不到列“发货日期”,该如何解决
SQL:找不到列“发货日期”
case chk5=1
textnr5=thisform.txt5.value
textnr6=thisform.txt6.value
tx5=len(alltrim(dtoc(textnr5,1)))
tx6=len(alltrim(dtoc(textnr6,1)))
if tx5=0.or.tx6=0.or.textnr5>textnr6
=messagebox("请输入正确的发货日期的下限和上限!",0,"系统提示")
return
thisform.txt5.setfocus
endif
sele * from fahuobiao where fahuobiao.发货日期>=textnr5 .and. 发货日期<=textnr6 into table &lsfile
endcase
set safe on
do form fahuocxjg
------解决方案--------------------
case chk5=1
textnr5=thisform.txt5.value
textnr6=thisform.txt6.value
tx5=len(alltrim(dtoc(textnr5,1)))
tx6=len(alltrim(dtoc(textnr6,1)))
if tx5=0.or.tx6=0.or.textnr5>textnr6
=messagebox("请输入正确的发货日期的下限和上限!",0,"系统提示")
return
thisform.txt5.setfocus
endif
sele * from fahuobiao where fahuobiao.发货日期>=textnr5 .and. 发货日期<=textnr6 into table &lsfile
endcase
set safe on
do form fahuocxjg
------解决方案--------------------