Dynamic Column Count?

[Bo Raposh]

Hi,
How can I get a dynamic column count in ADO using VB and/or SQL? I know RDO uses the rdoresultset.columns.count but ADO doesn't seem to have anything like that?
Thanks...
Bo

[Johnny101]

Use the .fields.count property of the recordset to get this value.

hope this helps,

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org