Re: Stored procedures
From: HardNose <mailwillbounce_at_bouncer.com>
Date: 1998/01/03
Message-ID: <01bd187c$f22a1f20$2f6a5ed1_at_chetanmach4>#1/1
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