Board index » delphi » Help with Date Query String

Mike Ver Hagen

Delphi Developer
Fri, 10 Aug 2001 03:00:00 GMT

Help with Date Query String

Brian:

Yes, the date must appear in the WHERE clause as a literal.

To test the validity of SQL, I usually use Database Desktop and try the
SQL there first.... then I build the string in code in my apps.

mIKE

 
Brian Aitk

Delphi Developer
Sat, 11 Aug 2001 03:00:00 GMT

Re:Help with Date Query String


Hi

Tearing my hair out on this one...

What I want to do is send a sql string to a TQuery that
will allow me to return records based on a comparison
of the current system date (Date) with a Date/Time field
in an Access Database.( Using DAO).

ie 'select * from stuff where mdb_date < date'

The sql string (being a string) will not accept the Date
unless I convert it (DateToStr)..........

dunno probably something simple

Any help would be appreciated

Brian Aitken

aitk...@wbinet.com
.

Brian Bushay Tea

Delphi Developer
Sat, 11 Aug 2001 03:00:00 GMT

Re:Help with Date Query String


Quote
>ie 'select * from stuff where mdb_date < date'

>The sql string (being a string) will not accept the Date
>unless I convert it (DateToStr)..........

You can use a parameter

'select * from stuff where mdb_date <: date'
ParambyName(date).asDateTime := sysUtils.date;

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Ray Crame

Delphi Developer
Sat, 11 Aug 2001 03:00:00 GMT

Re:Help with Date Query String


I beleive you need to enclose the date string in hashes like
'#dd/mm/yyyy#'.

HTH

Ray Cramer
R...@Pol.ac.uk

Quote
Brian Aitken wrote:
> Hi

> Tearing my hair out on this one...

> What I want to do is send a sql string to a TQuery that
> will allow me to return records based on a comparison
> of the current system date (Date) with a Date/Time field
> in an Access Database.( Using DAO).

> ie 'select * from stuff where mdb_date < date'

> The sql string (being a string) will not accept the Date
> unless I convert it (DateToStr)..........

> dunno probably something simple

> Any help would be appreciated

> Brian Aitken

> aitk...@wbinet.com
> .

Brian Aitk

Delphi Developer
Sun, 12 Aug 2001 03:00:00 GMT

Re:Help with Date Query String


In article <36e646e9.21473454@floyd>, BBus...@Nmpls.com (Brian Bushay TeamB) wrote:

Quote

>>ie 'select * from stuff where mdb_date < date'

>>The sql string (being a string) will not accept the Date
>>unless I convert it (DateToStr)..........

>You can use a parameter

>'select * from stuff where mdb_date <: date'
>ParambyName(date).asDateTime := sysUtils.date;

Worked like a charm...

Thanks

Brian

Other Threads

1. sql and dates query?delphi dont query dates?

2. please help - need filter string for an empty date

3. Help with Date and String

4. SQL 2000 - converting date/time to date in aggregate query

5. Query for last date/time and date/time in ASC format

6. Returning a string from a query to a string variable

7. Query about manipulating strings in Pascal (HELP!!!)

8. !!! help - date query and empty foreign key insertion

9. Help with how to use Date parameter in D5 MSSQL query

10. Help with long strings as query parameters