Re: Stored procedures

From: HardNose <mailwillbounce_at_bouncer.com>
Date: 1998/01/03
Message-ID: <01bd187c$f22a1f20$2f6a5ed1_at_chetanmach4>#1/1


Jüri Loosme <loosme_at_iks.se> wrote in article <01bd055b$726ab300$56b6f482_at_win95.swipnet.se>...
> Hello
>
> In the documentation of CRecordset it says that I could use a string like
> "{call sp_my_stored_procedure}" in the Open-function. This works fine
when

For calls to procedures, don't bother with Recordset at all, Just use ExecuteSQL function
in CDatabase Class.
In case of Functions, you need to use following syntax { ? = Call SomeFunction(?, ?, ?) }

Where ? stands for parameters, You use ODBC functions to bind this parameters to actual
values. Refer to ODBC function SQLBindParameter for further help Received on Sat Jan 03 1998 - 00:00:00 CET

Original text of this message