Z
zhch1100
Unregistered / Unconfirmed
GUEST, unregistred user!
在每次运行的时候,出现“参数datetimepicker1.date没有默认值”从而使查询失败。其中startdate
是ACCESS数据库中的一个短日期字段。datetimepicker1、datetimepicker2的checked属性为true,dataformat属性为dfshort
enabled 的属性为true,kind的属性为dtkdate。究竟是datetimepicker的属性有错误还是其他错误,请大侠指点
部分原程序如下:
begin
with dm.datasql do
begin
close;
with sql do
begin
clear;
add('select* from sheet1');
add('where 1=1');
add(' and startdate>=datetimepicker1.date');
add(' and startdate<=datetimepicker2.date');
if edit1.text<>'' then add(' and dwcode like '''+edit1.text+'%''');
if edit2.text<>'' then add(' and jfname like '''+edit2.text+'%''');
if edit3.text<>'' then add(' and yfname like '''+edit3.text+'%''');
end;
open;
end;
end;
是ACCESS数据库中的一个短日期字段。datetimepicker1、datetimepicker2的checked属性为true,dataformat属性为dfshort
enabled 的属性为true,kind的属性为dtkdate。究竟是datetimepicker的属性有错误还是其他错误,请大侠指点
部分原程序如下:
begin
with dm.datasql do
begin
close;
with sql do
begin
clear;
add('select* from sheet1');
add('where 1=1');
add(' and startdate>=datetimepicker1.date');
add(' and startdate<=datetimepicker2.date');
if edit1.text<>'' then add(' and dwcode like '''+edit1.text+'%''');
if edit2.text<>'' then add(' and jfname like '''+edit2.text+'%''');
if edit3.text<>'' then add(' and yfname like '''+edit3.text+'%''');
end;
open;
end;
end;