🚀 go-pugleaf

Sorry, I corrected some mistakes.

I have 3 ADO components on my form.
1/ ADOConnection
2/ ADOQuery
3/ ADOStoredProc

My program worked well with ADOQuery, but ADOStoredProc didn't work.

My store procedure have 1 input paramater @file_number.
and this is my source code:

ADOStoredProc->ProcedureName = "sp_data_integrity;1";
ADOStoredProc->Parameters->Clear();
ADOStoredProc->Parameters->CreateParameter("@File_Number", ftString,
pdInput, 30, NULL);
ADOStoredProc->Parameters->ParamByName("@File_Number")->Value = sFileNumber;
if(!ADOStoredProc->Prepared)
    ADOStoredProc->Prepared = true;
ADOStoredProc->Open();

I got a error message: Time Out

If I replace ADOStoredProc by ADOCommand it worked well.

What is happenning?

Thanks in advance.




Hien Tran <hien@camgsm.com.kh> wrote in message news:3b243874_1@dnews...
> I have 3 ADO components on my form.
> 1/ ADOConnection
> 2/ ADOQuery
> 3/ ADOStoredProc
>
> I program worked well with ADOQuery, but ADOStoredProc didn't work.
>
> My store procedure have 1 input paramater @file_number.
> and this is my source code:
>
> ADOStoredProc->ProcedureName = "sp_data_integrity;1";
> ADOStoredProc->Parameters->Clear();
> ADOStoredProc->Parameters->CreateParameter("@File_Number", ftString,
> pdInput, 30, NULL);
> ADOStoredProc->Parameters->ParamByName("@File_Number")->Value =
sFileNumber;
> if(!ADOStoredProc->Prepared)
>     ADOStoredProc->Prepared = true;
> ADOCommand->Open();
>
> I got a error message: Time Out
>
> If I replace ADOStoredProc by ADOCommand it worked well.
>
> What is happenning?
>
> Thanks in advance.
>
>
>
>