How do I return a recordset from a function in VB 5.0
Printable View
How do I return a recordset from a function in VB 5.0
It´s not usual to do this, and i never tried but i ever work with Sub and Global variables, and it work pretty well as a function.
I use to declare in a module the databases variables and recordsets
In the begining of the program i use to set the recordsets (as snapshot or dynaset)
and when i have to delete, for example, i call a sub that have the commands and i set the recordset again
in any Sub or Function i can get the recordset data and use it or update.
so when i exit the program i close the recordset and databases.
I hope to help you, and ask me more!
Leandro de Avelar
System Engineer
National Institut of Telecommunications