Board index » delphi » BDE paradox table date Query?

BDE paradox table date Query?

Hi !

I Just testing BDE Paradox table in C++ Builder

----Examples------
String Tmp;

Tmp = "select * from table1 where Orderdate ='" +
StrToDate(FormatDateTime("mm/dd/yyyy",Query1->Fields->Fields[1]->AsString))+
"'";

but this Project compile finished and excute program
the MessageBox return to me

***'10-12-1999' is not a valid date***

HELP Me

 

Re:BDE paradox table date Query?


Quote
On Tue, 12 Oct 1999 18:06:33 +0900, "aa" <ljs8...@orgio.net> wrote:
>I Just testing BDE Paradox table in C++ Builder

[...]

Quote
>***'10-12-1999' is not a valid date***

What is the BDE system parameters MODE and SEPARATOR set to? Use the BDE
Administrator to see this parameter and its setting. From the Configuration
tab:

  Configuration
    System
      Formats
        Date

==========================================================================
Steve Koterski                  "Computers are useless. They can only give
Technical Publications          you answers."
Borland                                       -- Pablo Picasso (1881-1973)
http://www.borland.com/techpubs/delphi

Other Threads