改一下: query1.sql.add('select * from userwork where userid=''1111'''); query1.SQL.add(' and (startdate between ''2001/1/1'' and ''2001/10/10'')'); 这里加空格 ^ ^
query1.sql.add('select * from userwork where userid=''1111'''); query1.SQL.add(' and (startdate between :Date1 and :Date2)'); query1.ParamByName( 'Date1' ).AsDate := DateTimePicker1.date; query1.ParamByName( 'Date2' ).AsDate := DateTimePicker2.date; 这样就不用管日期格式了(论坛里好多这个问题 ^_^)
不要用Between..and了,试一下startdate>='2001/01/01' and startdate<='2001/10/10' 这应可以.
query1.SQL.add('and (startdate between #2001/1/1# and #2001/10/10#)');
query1.sql.add('select * from userwork where userid=''1111''');
query1.SQL.add(' and (startdate between ''2001/1/1'' and ''2001/10/10'')');
这里加空格 ^ ^
query1.SQL.add(' and (startdate between :Date1 and :Date2)');
query1.ParamByName( 'Date1' ).AsDate := DateTimePicker1.date;
query1.ParamByName( 'Date2' ).AsDate := DateTimePicker2.date;
这样就不用管日期格式了(论坛里好多这个问题 ^_^)
这应可以.