TSQLStoredProc - DBExpress issue
Posted on 2004-11-16
I am migrating from BDE to DBExpress. I want to use my current stored procedures in the BeforeUpdateRecords call, and placed a TSQLStoredProc on the datamodule. First, when I click the dropdown to view available stored procedures, none show (I am using MS SQL 2000). Second, when I type it in and add my parameters manually, and run the app, when it calls the stored procedure, I get the following error message "List index out of bounds(0)". I've double-checked my list of parameters and they match my stored procedure
(included @RETURN_VALUE at 0). What am I overlooking on two counts - finding list of available stored procedures and the error message.