先看看代码
if trim(edit2.Text)='' then
begin
ShowMessage('请输入日期');
edit2.SetFocus;
Exit;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= #'+date1.Format(date)+''+time1.Format(time)+'''# and time2 <= #'+date2.Format(date)+''+ +''+time2.Format(time)+''#');
Open;
end;
不知道为什么老是提示出错
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Operator not applicable to this operand type
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(73): ')' expected but identifier 'Open' found
那为大侠能帮帮我啊,我想了一天了,实在想不同,真着急啊!!!!
if trim(edit2.Text)='' then
begin
ShowMessage('请输入日期');
edit2.SetFocus;
Exit;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= #'+date1.Format(date)+''+time1.Format(time)+'''# and time2 <= #'+date2.Format(date)+''+ +''+time2.Format(time)+''#');
Open;
end;
不知道为什么老是提示出错
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Operator not applicable to this operand type
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(73): ')' expected but identifier 'Open' found
那为大侠能帮帮我啊,我想了一天了,实在想不同,真着急啊!!!!
解决方案 »
- 大家觉得d7和d2007哪个好用?
- 200rmb请人写一个简单图形验证识别 并下载网页源代码的程序
- ¥875,321.56,转换为数值怎么转换?急,在线等待!
- 帮帮忙,udp广播后,udpserver怎么读不出数据呢?
- 这句select 怎么写?急!!
- 知道用UDP,在局域网内怎样向局域网外发信息吗/???共讨论!
- sql 表中默认的空值是<null> select * frome table where note=null 不行,该怎么办呢〉?
- 如何将程序放在内存中运行?
- 如何创建一个BMP文件并向里面输入文字呢??
- 两个关于QReport的问题
- dll的麻烦,不知哪位能帮忙,谢了,急!!!!!!!!!
- 我不想见到它。。。
Error] Unit1.pas(72): Missing operator or semicolon 这个错误,一般都是后面少个分号
比如
begin
somecode1// 这句后面少了一个;
somecode2
end;
编译就会出现Error] Unit1.pas(72): Missing operator or semicolon
他也有错误,
提示是[Error] Unit1.pas(72): Undeclared identifier: 'FormatDateTime'
Error] Unit1.pas(72): Missing operator or semicolon 这个错误,一般都是后面少个分号
比如
begin
somecode1// 这句后面少了一个;
somecode2
end;
编译就会出现Error] Unit1.pas(72): Missing operator or semicolon
后面也有分号,那是整条语句.
SQL.Add('Select * from uselog where time1 >= #'+date1.Format(date)+''+time1.Format(time)+'''# and time2 <= #'+date2.Format(date)+''+ +''+time2.Format(time)+''#');那为大侠能帮帮小弟啊????着急啊1!!!!!!!!!!!
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= #'+date1.Format(date)+''+time1.Format(time)+'''# and time2 <= #'+date2.Format(date)+''+ +''+time2.Format(time)+''#');
Open;
end;
不知道为什么老是提示出错
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(72): Operator not applicable to this operand type
[Error] Unit1.pas(72): Missing operator or semicolon
[Error] Unit1.pas(73): ')' expected but identifier 'Open' found
那为大侠能帮帮我啊,我想了一天了,实在想不同,真着急啊!!!!实际上就这几句,上面那行都不同去看他,多写的!!!!主要查询那4个控件里面的时间!!!
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= :param1 and time2 <= :param2');
Parameters.ParamByName('param1').Value := FormatDateTime('yyyy-mm-dd', date1.datetime);
Parameters.ParamByName('param2').Value := FormatDateTime('yyyy-mm-dd', date1.datetime);
Open;
end;
以上tim1,tim2为字符型,当为日期型时:
Parameters.ParamByName('param1').Value := StrToDate(FormatDateTime('yyyy-mm-dd', date1.datetime));
Parameters.ParamByName('param2').Value := StrToDate(FormatDateTime('yyyy-mm-dd', date2.datetime));
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= :param1 and time2 <= :param2');
Parameters.ParamByName('param1').Value := StrtoDate(trim(edit2.Text));
Parameters.ParamByName('param2').Value := StrtoDate(trim(edit2.Text));
Open;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select * from uselog where time1 >= :param1 and time2 <= :param2');
Parameters.ParamByName('param1').Value := FormatDateTime('yyyy-mm-dd', date1.datetime);
Parameters.ParamByName('param2').Value := FormatDateTime('yyyy-mm-dd', date1.datetime);
Open;
end;
以上tim1,tim2为字符型,当为日期型时:
Parameters.ParamByName('param1').Value := StrToDate(FormatDateTime('yyyy-mm-dd', date1.datetime));
Parameters.ParamByName('param2').Value := StrToDate(FormatDateTime('yyyy-mm-dd', date2.datetime));
access里还要写#,写参数格式也好,读起来要方便些,要不,引号比较麻烦