G gaohua21 Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-28 #1 在运行时用Table控件的Filter属性过滤日期字段数据应怎样写? 过滤数字型(整型)字段应怎样定?
L lb_icesea79 Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-28 #2 Table1.DatabaseName:='DBDEMOS'; Table1.TableName:='events.db'; procedure TForm1.Button1Click(Sender: TObject); begin Table1.Filtered:=False; Table1.Filter:='Event_Date >= '+DateToStr(DateTimePicker1.Date); Table1.Filtered:=True; end;
Table1.DatabaseName:='DBDEMOS'; Table1.TableName:='events.db'; procedure TForm1.Button1Click(Sender: TObject); begin Table1.Filtered:=False; Table1.Filter:='Event_Date >= '+DateToStr(DateTimePicker1.Date); Table1.Filtered:=True; end;
W wbo Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-28 #3 Table1.Filter:='Event_Date >= '+FloatToStr(DateTimePicker1.Date);
D dlnew Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-28 #4 Table1.Filter:='Event_Date >= '+formatdatetime('yyyy-mm-dd',DateTimePicker1.Date);
L lovedp Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-28 #5 Table1.Filter:='Event_Date >= '''+DateToStr(DateTimePicker1.Date)+'''';