? Count no.of Fields in a Recordset

[suel]

I am using VB front-end with SQL2000 DB.
I have retrieved a recordset (ADODB), I am stepping thru' each record in the recordset using .movenext, but I need also to move thru' each field in each record.

Is there some way to do a 'fieldcount' to make a loop ??
example
FOR liErr = 1 to Fieldcount

Next

Regards

Suel

 

[sunaj]

Yes:

--------------------------------
dim i as long
for i = 0 to rst.Fields.Count-1
debug.print Rst.fields(i)
next
-------------------------------- Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[suel]

Thanks ...
I think I was trying to make things harder than it actually is !!!!
Thanks again

Suel

 

[SemperFiDownUnda]

You could also do
Dim fld AS ADODB.Field

for each fld in rs.Fields

next

and just refrence the field objects through the fld instance