Found this out:
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.