请教高手关于查询条件的问题
我写的个表单中有个按时间区间查询的功能。
TEXT1中是开始时间,TEXT2是终止时间,如果只在其中一个中填写时间,则相应查询大于开始时间或者小于终止时间的。现在的问题是,当TEXT1为空,TEXT2填入时间后查询小于TEXT2的时间的记录能得到正确结果,但当TEXT2为空,查询大于TEXT1的时间的记录时,就一条记录都不显示了!
程序段如下:
do case
case
thisform.check1.value=1.and.thisform.check2.value=1.and.thisform.text1.value<>" ".and.thisform.text2.value<>" "
set filt to cbsj>=ctod('&data1').and.cbsj=<ctod('&data2').and.like("*&nid*",newsid)
case thisform.check1.value=1.and.thisform.check2.value=1.and.thisform.text1.value<>" ".and.thisform.text2.value=" "
set filt to cbsj>=ctod('&data1').and.like("*&nid*",newsid)
case thisform.check1.value=1.and.thisform.check2.value=1.and.thisform.text1.value=" ".and.thisform.text2.value<>" "
set filt to cbsj=<ctod('&data2').and.like("*&nid*",newsid)
case thisform.check1.value=1.and.thisform.check2.value=0.and.thisform.text1.value<>" ".and.thisform.text2.value<>" "
set filt to cbsj>=ctod('&data1').and.cbsj=<ctod('&data2')
case thisform.check1.value=1.and.thisform.check2.value=0.and.thisform.text1.value<>" ".and.thisform.text2.value=" "
set filt to cbsj>=ctod('&data1')
case thisform.check1.value=1.and.thisform.check2.value=0.and.thisform.text1.value=" ".and.thisform.text2.value<>" "
set filt to cbsj=<ctod('&data2')
case thisform.check1.value=0.and.thisform.check2.value=1
set filt to like("*&nid*",newsid)
case thisform.check1.value=0.and.thisform.check2.value=0
set filt to
endcase