建议代码改成:sql.add(StringReplace('select * from test where datediff("d",time,Now())=0 ','"',#27(*''''*), [rfReplaceAll]) ) ;
另外一种写法是: sql.add('select * from test where datediff('#27'd'#27',time,Now())=0 ' ) ; 或sql.add('select * from test where datediff(' + #27 + 'd' + #27 + ',time,Now())=0 ' ) ;
sql.add('select * from test where datediff('#27'd'#27',time,Now())=0 ' ) ;
或sql.add('select * from test where datediff(' + #27 + 'd' + #27 + ',time,Now())=0 ' ) ;