Hi,
I'm doubting to create a general recordset class which automatically sets some properties (so that I don't have to set the active connection, cursor type, etc.).
Now I'm wondering... what's the most efficient way according to speed and memory:
use the ADODB.Recordset and forget the class (hehe that's the easiest :-)
or, create a property which wants a fieldname as argument, and get that field from the recordset and return it as Variant,
or, return a Recordset so I can use it in the program like ClassName.PropertyName!MyField
I'm especially intrested in the last 2 options :-)
Which one is the cheapest according to memory (less memory usuage) and is the fastest? Looking up the field (PropName = rst.Fields(psFieldName) ) or returning the recordset?
Tnx! :-)


Crazy D @ Work :-)