Delphi TmysqlQuery

[DeddyH]

You have to fill the parameters with values before you execute your statement. Didn' t you do this?

[baumina]

Please check while debugging Tmysqlquery.Text. This is the SQL statement passed to MySQL.

[question]

Hi,
i have debug the application and i have found that, the system date format is: 2013-09-04(yy-mm-dd) but the database query dateformat shows the: 04-09-2013(dd-mm-yy)
how to make it similar formate?

[DeddyH]

You can try using FormatDateTime.

[question]

i have tried the follwoing ,but still have the same problem

Code:

QueryAdd1.ParamByName('DateNew').AsString:= FormatDateTim('yyyy-mm-dd', DateNew);

[mkinzler]

Why not

Delphi-Quellcode:

QueryAdd1.ParamByName('DateNew').Value := DateNew;

or

Delphi-Quellcode:

QueryAdd1.ParamByName('DateNew').AsDate := DateNew;

What type has the field in the DB?

[question]

in DB it is DateTime field

[mkinzler]

Then use .Value

[question]

i have used .value but its the same :(

[baumina]

Is your error still ? :

Zitat:

Zitat von question (Beitrag 1227068)

"you have an error in your sql syntax near 'OC2000000A000000201' EmySqldatabase error"

The string 'OC2000000A000000201' dont looks like a dateformat-problem.