🚀 go-pugleaf

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'.

cheers

--
M
"Marshall" <adworx@ihug.co.nz.spammenot> wrote in message
news:3c32b114_2@dnews...
> When assigning values to parameters in ADOQuery I use
>
> ADOQuery3->Parameters->ParamByName("ACode")->Value = editACode->Text;
> or
> ADOQuery3->Parameters->ParamByName("ACode")->Value =
> editACode->Text.c_str();
>
> both of whihc give me a error of being unable to define the param.
> the only way I've found to get around this is to copy the edit boxes value
> into a char array and then set the param to that.
> any work arounds or is this just me?
>
> ta
>
> --
> M
>
>