🚀 go-pugleaf

Fret,

I'm not familiar with Paradox-databases but I got the same behaviour in MS
Access databases. The problem has nothing to do with the Locale Settings of
Windows, the SQL-query simply always needs an English dateformat.

I use something like this:

AnsiString VarToQueryString(Variant VValue)
{
    AnsiString AReturn;
    switch (VValue.Type())
    {
        ...
        case varDate:
            // conversion to English Locale!
            AReturn = "#"+FormatDateTime("mm-dd-yyyy",VValue)+"#";
            break;
        ...
    }
...
}

Maybe this helps.

HTH
Ronald

"FretBuzzz" <gulanala@yahoo.com> schreef in bericht news:3c2b8b64_2@dnews...
> Hi,
>
> My app uses a Paradox table. One of the fields in the table is of type
> "Date".
> In the app I manipulate the database using SQL and a TQuery component.
> My problem is that the system's short date format has to be "MM/dd/yyyy"
> before any queries that use the date field will work. When the system's
> short date
> format is "dd/MM/yyyy", my queries simply don't work - I keep getting an
> error message: "Type mismatch in expression" - even when I double check
that
> the format of the date description in the sql statement is the same as
that
> of the system.
>
> Can anyone tell me what I am doing wrong?
> Fret
>
>