Devart Forums

Hi,
I have Delphi 2010, MySQL 5.5, MyDAC trial
I use this code:

MyQuery1.ExecSQL('CREATE TABLE `Products` (`prod_id` CHAR (10) NOT NULL)');

ERROR "[DCC Error] Unit1.pas(42): E2034 Too many actual parameters"

Prompt syntax please

SanyaXYZ wrote:Hi,
I have Delphi 2010, MySQL 5.5, MyDAC trial
I use this code:

MyQuery1.ExecSQL('CREATE TABLE `Products` (`prod_id` CHAR (10) NOT NULL)');

ERROR "[DCC Error] Unit1.pas(42): E2034 Too many actual parameters"

Prompt syntax please

MyQuery1.SQL.text:='CREATE TABLE `Products` (prod_id CHAR (10) NOT NULL)';
MyQuery1.ExecSQL;

Hello,

It's good to see that you've found a solution. If any other questions come up, please contact us.