adoquery关于sql的读取问题
sqlstr1:='select SourceLoginName,SourceLoginPassword,SourcePath,SourceFileName,'
+'DestLoginName,DestLoginPassword,DestPath,DestFileName,DiskIcon,TimeIntervalCopy'
+' ,[Is/NotCover] FROM CopyInfo where TimeDotCopy='
+ #39 + FormatDateTime('hh:mm',now) + #39
+'or TimeIntervalCopy=('
+ #39 + FormatDateTime('c',now)+ #39+'-'+#39+ SystemCopyTime +#39?????SystemCopyTime 是表CopyInfo的字段,无法识别,该怎么改?
+')';
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add(sqlstr1);
Open;
end;
[解决办法]
加引号用QuotedStr
[解决办法]
intToStr(SystemCopyTime)转换一下吧,好像是类型不同。