Re: how to pass recordset object to procedures/functions?
From: Alex Dybenko (alex_at_PLEASE.cemi.NO.rssi.SPAM.ru)
Date: Fri, 9 Jul 2021 18:01:40 +0400
well, adodb -is just a library name of ADO, so if you use ADO - then
recorset "prefix" will be adodb.
-- Alex Dybenko (MVP) http://Alex.Dybenko.com http://www.PointLtd.com "JingleBEV" <n_quan@NOSPAMyahoo.com> wrote in message news:gqwHc.48053$JG5.firstname.lastname@example.org... > I am a real newbie here. can you tell me what's the difference between ADO > and ADODB? In my project I only use ADO. When do I have to use ADODB? > > Thanks. > "Alex Dybenko" <alex@PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message > news:OTN6j7LZEHA.996@TK2MSFTNGP12.phx.gbl... > > 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.email@example.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. > > > > > > > > > > > > > > > > > >