🚀 go-pugleaf

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

My guess is that this has to do with the parameters. When you configure the stored
proc at design time, the parameters are filled in for you. The stored proc component
has to hit the database to read the parameters in. 

However, if you configure the stored proc in code, the parameters may not retrieved
for you. I don't know if this is true, but it is something you might want to check.

Harold Howe [TeamB]
http://www.bcbdev.com