By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,569 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,569 IT Pros & Developers. It's quick & easy.

how to pass recordset object to procedures/functions?

P: n/a
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.
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
We need to see the *exact* code you're trying to use and getting the error
with.

--

Randy Birch
MVP Visual Basic
http://vbnet.mvps.org/
Please respond only to the newsgroups so all can benefit.
"JingleBEV" <n_****@NOSPAMyahoo.com> wrote in message
news:jw*********************@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.
:
:

Jul 17 '05 #2

P: n/a

Function Process(rs as ADODB.Recordset)
'....
'works for me..
'
End Function

"JingleBEV" <n_****@NOSPAMyahoo.com> wrote in message
news:jw*********************@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.

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.