🚀 go-pugleaf

 I tried to put a TADOStoredProc and do next:
 proc->ProcedureName = "PROC_TEST";
 proc->Parameters->Items[0]->Value = "A";
 .
 .
 .
 .
But when second statement is executed an error "index out of bounds" raises.
In design time I created all parameters and set field type and size. No idea
what's wrong.

"Julian Lliteras" <yartax@hotmail.com> escribi� en el mensaje
news:41cbf30f$1@newsgroups.borland.com...
> Hi,
>
> I get a TADOConnection and TADOQuery to execute an stored procedure and
> retrieve result. I do something like:
>
> query->SQL->Add("exec PROC_TEST
> 'A',0,0,0264207,'01/01/2005','07/01/2005','DB'");
> query->Open();
>
> This make an timeout error. But if I do query->Prepared = true first, and
> get next sentences within a sql trace:
>
> declare @P1 int
> set @P1=1
> exec sp_prepare @P1 output, NULL, N'exec PROC_TEST
> ''A'',0,0,0264207,''01/01/2005'',''07/01/2005'',''DB''
> ', 1
> select @P1
>
> This raise next error:
> Servidor: mensaje 8179, nivel 16, estado 2, procedimiento sp_prepare,
l�nea
> 3
>
> If I execute the proc_test with exact values in the ms sql editor it runs
> ok!
> What's the problem?
>
> Thanks.
> Julian
>
>