Delphi TmysqlQuery

[question]

I have tried as you suggested even i have also tried by changing the name of the date field

Code:

insert into TableAdd
  (`Name`, `Address`, `Phone`, `Emial`, `Date`)
values
  (:Name, :Address, :Phone, :Emial, :Date)

but still have the same error, by the way,how can i check System.DateTime value and MySql.Data.Types.MySqlDate, maybe the datetime of the system and the mysqlDate is not matching, its just my idea,what do you think?

[DeddyH]

SQL-Parameters are usually parsed automatically. Maybe your field is a timestamp instead of a Date/DateTime? It is hard to find a solution when you don' t know either the table structure nor the Delphi-code used to execute your queries.

[question]

the field 'Date' is a DateTime field,

[Lemmy]

Hi,

please try this one:

  xxx.ParamByName('Date').AsString := FormatDateTim('yyyy-mm-dd', YourDateValue);
cu

[question]

the querystring is done by using dfm with field and parameter
how can i use

Code:

xxx.ParamByName('Date').AsString := FormatDateTim('yyyy-mm-dd', YourDateValue);

[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.