CREATE TABLE (Too many actual parameters)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
SanyaXYZ
Posts: 11
Joined: Wed 20 Oct 2010 17:22

CREATE TABLE (Too many actual parameters)

Post by SanyaXYZ » Sun 19 Jun 2011 09:53

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

SanyaXYZ
Posts: 11
Joined: Wed 20 Oct 2010 17:22

Re: CREATE TABLE (Too many actual parameters)

Post by SanyaXYZ » Sun 19 Jun 2011 14:01

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 :oops:
MyQuery1.SQL.text:='CREATE TABLE `Products` (prod_id CHAR (10) NOT NULL)';
MyQuery1.ExecSQL;

AndreyZ

Post by AndreyZ » Mon 20 Jun 2011 08:25

Hello,

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

Post Reply