🚀 go-pugleaf

"Dave" <dave@nospam.com> wrote in message news:3c7d6f10$1_1@dnews...
> When placing the stored proc control on a form and using the following
code
> it doesnt work.
>
> spData->ConnectionString = p_DBConn;
> spData->ProcedureName = "ap_tblForm_INS;1";
> spData->Parameters->ParamByName("@ins_company_id")->Value = p_coyid;
> spData->Parameters->ParamByName("@ins_data")->Value = p_data;
> spData->Parameters->ParamByName("@ins_formType_id")->Value = 1;
> spData->ExecProc();
>
> However if I fill in the connection string and procedure name at design
time
> it works fine...
>
> TIA
>
>
use ADOCommand component,the ADOCommand ingores the parameters.like this:
> ADOCommand1->ConnectionString = p_DBConn;
> ADOCommand1->ProcedureName = "ap_tblForm_INS";//not  ap_tblForm_INS;1
ADOCommand1->Parameters->Refresh();
> ADOCommand1->Parameters->ParamByName("@ins_company_id")->Value = p_coyid;
> ADOCommand1->Parameters->ParamByName("@ins_data")->Value = p_data;
> ADOCommand1->Parameters->ParamByName("@ins_formType_id")->Value = 1;
> ADOCommand1->ExecProc();
may you success!