Please explain the use of rec.CursorLocation = adUseClient

Many times I would open a recordset to place in a datagrid in vb6 with

rec.Open (esql), conn, adOpenDynamic, adLockOptimistic

Open in new window


However, in one instance I needed to use the following:

rec.CursorLocation = adUseClient
                rec.Open (esql), conn, adOpenDynamic, adLockOptimistic

Open in new window


Can someone explain to me what the purpose is of the first line in this code.
al4629740Asked:
Who is Participating?
 
Chris WatsonConnect With a Mentor Software DeveloperCommented:
One practical example of using a client side cursor is obtaining a record count.

rec.RecordCount

Open in new window


Combined with a SELECT query, a server side cursor this would return -1 for this property. With a client side cursor you would obtain the number of records returned by the query.
0
 
Luis PérezConnect With a Mentor Software Architect in .NetCommented:
0
All Courses

From novice to tech pro — start learning today.