How to run stored procedure 1

[ryupb]

ok, here is another dumb question.... how can I execute a SQL stored procedure with a parameter??

the stored procedure is in the SQL server database and not the ones in the .DBC

 

[rgbean]

It depends on how you are connected - ODBC or ADO. The SQLEXEC( ) Function Help File extry shows these examples:

* Call a stored procedure with no parameters.
   SQLEXEC(m.lnConn, 'sp_who', 'activeusers')
   BROWSE 

   * Execute stored procedure with an INPUT parameter.
   SQLEXEC(m.lnConn, 'exec byroyalty ?lnPercent','HalfOffAuthors')

Rick

 

[ryupb]

Hi Rick,

with regards to the connection, does it differ if i were to use ADO or ODBC connection??

with regards to the parameters that you have stated above, the 'activeusers' - is this the name of the table where the records are supposed to be extracted from??

 

[rgbean]

Yes, SQLEXEC() is strictly for ODBC - almost everything is different in ADO. :-(

No, in that example, it's assumed that the stored procedure sp_who, will return a cursor, and it's name will be 'activeusers'.

The stored procedure always knows what table(s) it'll be using - unless the table name(s) are passed in as a parameter.

Rick

 

[ryupb]

hey Rick, thanks for the clarification..... fortunately I now remember how to invoke it, just needed some refresher...

a star for your time and effort...