🚀 go-pugleaf

 From what I see of this code, I would remove the single quotes from your
Select statement. Ex.
 >   ADOQuery3->SQL->Add(":ACode AS expr1,");

I believe you only need these when you have text in your SQL. Ex.
 >   ADOQuery3->SQL->Add("where Author_Name = 'TOLKIEN' ");

and then as a qualifier, not as a field name.

Do you not know what field names you will be using when running your query?

Maybe what you are looking for would be more like this:

ADOQuery3->SQL->Add( "INSERT INTO Author ( Author_Code, Author_Name, 
Author_Address ) " );
ADOQuery3->SQL->Add( "SELECT NewCode, NewName, NewAddress FROM NewTable 
where NewName = :AName " );

ADOQuery3->Query3->Parameters->ParamByName( "AName" )->Value = "TOLKIEN";
etc...

Hope this is more helpful then confusing.

David Barnes

Marshall wrote:

> Just to clarify a  bit:
> 
>   ADOQuery3->SQL->Add("INSERT INTO Author(Author_Code, Author_Name,
> Author_Address) SELECT ");
>   ADOQuery3->SQL->Add("' :ACode ' AS expr1,");
>   ADOQuery3->SQL->Add("' :AName ' AS expr2,");
>   ADOQuery3->SQL->Add("' :AAddress ' AS expr3;");
> 
>   ADOQuery3->Parameters->ParamByName("ACode")->Value = ACode;
>   ADOQuery3->Parameters->ParamByName("AName")->Value = AName;
>   ADOQuery3->Parameters->ParamByName("AAddress")->Value = AAddr;
> 
> is the code im using and the error i get is:
> 
> <Project Name.exe> raised exception class EDatabaseError with message
> 'Parameter 'ACode' not found'.