Can you please help me to see how the same program fails on some machines

腥红华尔兹

OperatorDate between '"+ DateTimePicker1-> Date +"' and '"+ (DateTimePicker2-> Date + 1) +"' "

This is part of the SQL statement. How can it be used on some machines and some can be used. There is no error in the compilation environment. What is the problem?

腥红华尔兹

The error is Error converting from string to datetime

腥红华尔兹

No one is there

delraich

Is there a format error?
Use FormatDateTime to convert it. . .

腥红华尔兹

It should be, but some machines can, some can't.

csb1024

SQL syntax error? It depends on what database
Incorrect query results? DateTimePicker1-> Date This one is not a date. Use FormatDateTime to convert it.

光明之行者

Similar problems have occurred before, generally the system date and time format. Try the following method

In SQL, look at the format of the OperatorDate field record. Use FormatDateTime() in BCB to format it into the date and time format in SQL.

There is your DateTimePicker1->Date is best to make AnsiString first