🚀 go-pugleaf

yup i think you both gave me the right answer. should've tried that before
posting *slaps head*.

cheers

--
M
"David Barnes" <david@kalos-inc.com> wrote in message
news:3C3328DC.5030202@kalos-inc.com...
> 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'.
>