Recordset

[Kim W. Pedersen]

How do I return a recordset from a function in VB 5.0

[Leandro Avelar]

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