[Last Call] Learn how to a build a cloud-first strategyRegister Now


TSQLStoredProc - DBExpress issue

Posted on 2004-11-16
Medium Priority
Last Modified: 2010-04-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.
Question by:DARRAH

Author Comment

ID: 12599492
There is a SchemaName property on the TStoredProc component that must be set to the schema name of the user that created/or has rights to the storedproc
that exists on the server.

For example if the stored proc was created on MSSQL as the admin 'sa' login... then the schema name would be 'dbo'. You can use the Enterprise Manager to discover what the schema name is for that particular object. Also using the Enterprise Manager you can grant permission for other users to access the server object.

Accepted Solution

ee_ai_construct earned 0 total points
ID: 12600095
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question