Delphi, ADO, MySQL und ein ganz böser Parameterfehler...

[Guido R.]

Z.B. so :

SQL-Code:

insert into products_description(
   products_id, 
   language_id, 
   products_name, 
   products_description, 
   products_viewed
   ) values (
   :products_id, 
   :language_id, 
   :products_name, 
   :products_description, 
   :products_viewed)
ON DUPLICATE KEY UPDATE
   products_name=:name1, 
   products_description=:description1

Parameterübergabe mit :

Delphi-Quellcode:

{...}
ADOCmd.Parameters.ParamByName('products_id').Value                   := ID;
{...}