ADO recordset returns -1
Philip wrote ...
the default CursorLocation is server-side (adUseServer) with forward only
cursors.
Yes, but you can specify something other than the default!
To navigate ADO recorsets, and get information like "Recordset.Count" or
"Recordset.AbsolutePosition" you need to explicitly set it to adUseClient
Incorrect. Availability of such properties is determined by cursor
type, not location. Any cursor type other than 'forward only' will
support the RecordCount property.
get information like "Recordset.Count"
The Recordset object does not have a Count property.
Jamie.
--
|