I am using Delphi 7 Enterprise, MS-SQLServer 2000 sp 3, dbExpress with
driver dbexpmss.dll (updated!).
I am trying to execute a stored procedure with params using TSQLDataSet. I
have some problems:
1 - I have selected these properties:
SQLConnection := SQLConnection1
CommandType := ctStoredProcedure
But when I try navigate to CommandText property, it does not show my stored
procedures.
2 - If I try fill CommandText with my StoredProcedure name, it doesn't fetch
parameters.
3 - If I fill parameters manually and try execute TSQLDataSet, I receive
this message "List index out of bounds (0)".
4 - If I try compile and execute running aplication, the same error occurs.
4 - The same problems occurs when I try these operations using TStoredProc.
What's wrong?
Thank you in advance.
Nelson
nel...@datagricolae.com.br
T.Ramesh.
"Nelson Nepomuceno" <nel...@datagricolae.com.br> wrote in message
news:3ea8...@newsgroups.borland.com...
Nelson :)
----- Original Message -----
From: "Ramesh Theivendran" <rtheiv...@borland.com>
Newsgroups: borland.public.delphi.database.dbexpress
Sent: Friday, April 25, 2003 12:53 AM
Subject: Re: Delphi 7 En + dbExpress + SQLServer 2000 + StoredProc = List
index out of bounds (0)
> Check if the SchemaName property is set to the Owner of the SP.
>
> T.Ramesh.
"Ramesh Theivendran" <rtheiv...@borland.com> escreveu na mensagem
news:3ea8b0b4$1...@newsgroups.borland.com...