Re: how to pass recordset object to procedures/functions?

From: Alex Dybenko (alex_at_PLEASE.cemi.NO.rssi.SPAM.ru)
Date: 07/08/04


Date: Thu, 8 Jul 2021 11:13:37 +0400

Probably you have both ADO and DAO references? try to declare recordsets
explicity as:
set rst=DAO.recordset
 or
set rst=ADODB.recordset

-- 
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
"JingleBEV" <n_quan@NOSPAMyahoo.com> wrote in message
news:lz2Hc.31305$WM5.1418788@news20.bellglobal.com...
> Hi all,
>  I am trying not to use global variable to maintain data consistency. Some
>  procedures and functions will require to pass the recordset object for
>  processing and functions may also return the recordset object to the
> calling
>  functions/procedures. I already tried this but keep getting error 13
(type
>  mismatch).
>  how can I achieve it?
>
>  Your help is appreciated.
>
>  Jing.
>
>
>
>