TSQLStoredProc - DBExpress issue

Posted on 2004-11-16
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

    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

    Question answered by asker or dialog valuable.
    Closed, 500 points refunded.
    ee_ai_construct (replacement part #xm34)
    Community Support Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now