RE: [DUG]: Using Dates in ClientDataset Filters

2001-07-04 Thread Stephen Bertram
35 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: Using Dates in ClientDataset Filters That depends on your database. Using Interbase I would not use the filter option. I would use a TQuery as the Client dataset and use a parameter. e.g. Query1.SQL.Add('SELECT * FROM

RE: [DUG]: Using Dates in ClientDataset Filters

2001-07-04 Thread Steve Aish
That depends on your database. Using Interbase I would not use the filter option. I would use a TQuery as the Client dataset and use a parameter. e.g. Query1.SQL.Add('SELECT * FROM TABLENAME WHERE TARGETDATE = :TARGETDATE'); Query1.Params[0].asDateTime := TargetDateVariable; Where TargetDate