解决方案 »
- 熟悉PB的delphi开发者朋友请进....
- 帮忙:怎么把varbinary字段中的文件取出来并保存成文件?
- if Assigned(FShowDateHint) then FShowDateHint(self) 什么意思
- up有分,delphi+oracle,bde中的Blob size如何设置,才能存更大的数据?
- 除了用ADOX组件之外还有什么方法可以动态建立Access数据库?
- 解除 占用
- 出错啊
- 请问:在treeview中点击+号的事件是什么?我刚才的问题怎么没有了?
- ADOQuery1为什么出差
- 菜鸟提问:delphi编译的程序需要什么环境?
- 想在圆的中央位置显示数字,求算法
- directorylistbox控件操作
formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59';
DateTimePicker1.Date:= StrToDateTime('2013-07-31');继续改
var
TmpDate2,TmpDate1,str:string;
begin
DateTimePicker2.Date:='2013-07-31';//这两句应该编译不过吧,不能将字符串赋值给DateTimePicker的Date
DateTimePicker1.Date:='2013-07-31';//
TmpDate2:= formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59';
t := VarToDateTime(TmpDate2);//t:=strtodatetime(TmpDate2);应该是这里报错吧,改为用VarToDateTime函数
TmpDate1:= (formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00-00-00');
With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where ?售?? between ''+ TmpDate1 +'' and ''+ TmpDate2 +''');
open;
end;
end;
2:其实DateTimePicker2.Date:=date;为了大家看直接写了‘2013-07-31’
请帮忙看看下面的语句出错在哪里 提示‘字符窜转化为datetime出错 Var
TmpDate2,TmpDate1,str:string;
beginDateTimePicker2.Date:=date;
DateTimePicker1.Date:=date';
TmpDate2:= (formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');TmpDate1:= (formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00-00-00');
With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between ''+ TmpDate1 +'' and ''+ TmpDate2 +''');
open;
end;
俺测试编译通过没有报‘字符窜转化为datetime出错’,你报错程序断在哪一行啊
TmpDate2,TmpDate1:TDateTime;
beginDateTimePicker2.Date:=date;
DateTimePicker1.Date:=date';
TmpDate2:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');TmpDate1:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00-00-00');
With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between :TmpDate1 and :TmpDate2');
Parameters.ParamByName('TmpDate1').Value := TmpDate1;
Parameters.ParamByName('TmpDate2').Value := TmpDate2;
open;
end
改成:
Sql.Add('Select * From zh_vxsdmx where 销售时间 between '''+ TmpDate1 +''' and '''+ TmpDate2 +'''');
编译不过
编译不过注意我红色字体的地方var
TmpDate2,TmpDate1:TDateTime;
begin
DateTimePicker2.Date:=date;
DateTimePicker1.Date:=date;
TmpDate2:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');
TmpDate1:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00:00:00'); With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between :TmpDate1 and :TmpDate2');
Parameters.ParamByName('TmpDate1').Value := TmpDate1;
Parameters.ParamByName('TmpDate2').Value := TmpDate2;
open;
end;
end;
改成:
TmpDate1:= (formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00:00:00');
编译不过注意我红色字体的地方var
TmpDate2,TmpDate1:TDateTime;
begin
DateTimePicker2.Date:=date;
DateTimePicker1.Date:=date;
TmpDate2:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');
TmpDate1:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00:00:00'); With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between :TmpDate1 and :TmpDate2');
Parameters.ParamByName('TmpDate1').Value := TmpDate1;
Parameters.ParamByName('TmpDate2').Value := TmpDate2;
open;
end;
end;TmpDate2:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');TmpDate1:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00-00-00');
编译不过注意我红色字体的地方var
TmpDate2,TmpDate1:TDateTime;
begin
DateTimePicker2.Date:=date;
DateTimePicker1.Date:=date;
TmpDate2:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59');
TmpDate1:= VarToDateTime(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00:00:00'); With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between :TmpDate1 and :TmpDate2');
Parameters.ParamByName('TmpDate1').Value := TmpDate1;
Parameters.ParamByName('TmpDate2').Value := TmpDate2;
open;
end;
end;为正解 谢谢大家的帮助 结贴
TmpDate2,TmpDate1,str:string;
beginDateTimePicker2.Date:='2013-07-31';
DateTimePicker1.Date:='2013-07-31';
TmpDate2:= formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' '+'23:59:59';
//t:=strtodatetime(TmpDate2);
TmpDate1:= (formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' '+'00:00:00');
With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between '''+ TmpDate1 +''' and '''+ TmpDate2 +'''');
open;
end;
//这个代码可通过。
TmpDate2,TmpDate1,str:string;
beginDateTimePicker2.Date:='2013-07-31';
DateTimePicker1.Date:='2013-07-31';
TmpDate1:= Quotedstr(formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+' 00:00:00'));
TmpDate2:= Quotedstr(formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+' 23:59:59');
With ADOQuery2 Do
Begin
CLose;
Sql.Clear;
Sql.Add('Select * From zh_vxsdmx where 销售时间 between '+ TmpDate1 +' and '+ TmpDate2);
open;
end;
//这样更直观