Visual Basic Syntax - counting fields in a recrdset

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

counting fields in a recrdset

dshemesh

2005-08-21, 7:56 am

Hello,
Does anyone know the syntax for getting the number of fields in a given
recordset (I mean a variable of type ADODB.recordset)?

thank you
--
dshemesh

David Youngblood

2005-08-21, 7:56 am

"dshemesh" <dshemesh@discussions.microsoft.com> wrote..
> Does anyone know the syntax for getting the number of fields in a given
> recordset (I mean a variable of type ADODB.recordset)?

The Count property of the Fields collection.

Debug.Print rstAssets.Fields.Count

David

dshemesh

2005-08-21, 7:56 am

thank you very much
--
dshemesh

"David Youngblood" wrote:

> "dshemesh" <dshemesh@discussions.microsoft.com> wrote..
>
> The Count property of the Fields collection.
>
> Debug.Print rstAssets.Fields.Count
>
> David
>
>
>

Sponsored Links