Delphi TmysqlQuery

[question]

Hi,
I am using Tmysqlquery and TmySqlUpdateSQL to update(insert/delete/modify) the database concring user input, but i get the error "you have an error in your sql syntax near 'OC2000000A000000201' EmySqldatabase error"

i have checked several times the query and database connection, everything is fine but i dont have any idea why i get this error
do you have any idea?

[mkinzler]

Without the complete Query it's very hard to impossible to help you.

[DonManfred]

Zitat:

Zitat von question (Beitrag 1227068)

Hi,
I am using Tmysqlquery and TmySqlUpdateSQL to update(insert/delete/modify) the database concring user input, but i get the error "you have an error in your sql syntax near 'OC2000000A000000201' EmySqldatabase error"

The problem is not the databaseconnection. The problem is the SQL-Query you are using.

LOG it for debugging purposes. Or maybe post the query here...

[question]

as i have used tmysqlquery instead TQuery ,therefore I have one idea, it can happend becasue of tmysqlquery component?

here is the code for insert (it is from dfm)

Code:

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

modify

Code:

update TableAdd
set
  Name= :Name,
  Address= :Address,
  Phone= :Phone,
  Emial= :Emial,
  Date= :Date
where
  ID = :OLD_ID

delete

Code:

delete from TableAdd
where
  ID = :ID

[DeddyH]

What happens when you quote the fieldnames?

Code:

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

At least "Date" is quite surely a reserved word because there is a corresponding data type.

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

Delphi-Quellcode:

  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);