Local SQL - problem with query using a DATE

Marius

Delphi Developer

Wed, 06 Oct 1999 03:00:00 GMT

Local SQL - problem with query using a DATE

Hi,

I have this stupid problem that I don't know how to fix:

I am querying a Local Paradox table using the following SQL statement:

"select * from mytable where TransDate > '01-APR-1997'"

This statement works fine, but I want to change the '01-APR-1997' to
something like '1997/04/01'. I get a type mismatch error when trying to do
this.

Is there a something I can do (BDE configuration perhaps?) to change the
format of a date in a Local SQL statmement?

Regards,
Marius Booysen.
Email: booys...@qttsud2301.telkom.co.za

Johan L. Both

Delphi Developer

Sun, 10 Oct 1999 03:00:00 GMT

Re:Local SQL - problem with query using a DATE

You could use the TDateTime value directly in your query, which avoids a
lot of problems.

i.e. Sql.Add('where thedate = '+IntToStr(Trunc(Date)));

Marius <booys...@qttsud2301.telkom.co.za> wrote in article
<01bc4ca4$455cfa00$eaee8...@home-msb.telkom.co.za>...

Quote

> Hi,

> I have this stupid problem that I don't know how to fix:

> I am querying a Local Paradox table using the following SQL statement:

> "select * from mytable where TransDate > '01-APR-1997'"

> This statement works fine, but I want to change the '01-APR-1997' to
> something like '1997/04/01'. I get a type mismatch error when trying to
do
> this.

> Is there a something I can do (BDE configuration perhaps?) to change the
> format of a date in a Local SQL statmement?

> Regards,
> Marius Booysen.
> Email: booys...@qttsud2301.telkom.co.za

Other Threads

1. Local sql, query on query problem

2. Query on Date field in local SQL

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

4. Using the dot(.) with dates in Local SQl

5. Query problem with local SQL

6. Local SQL query problems

7. SQL Querying Dates using D/M/Y Format

8. Query of a query (with Local SQL)...?

9. Using LOCAL-SQL or Transact-SQL with SQL-server and BDE

10. Local SQL, works in MS SQL, not in local SQL