Hi,
how can you tell how many records a ADODB connection has returned you can not use recordcount as you need to go through the list a least once for this to work. With other connections i use nomatch!
Thanks
Joolz:rolleyes:
Printable View
Hi,
how can you tell how many records a ADODB connection has returned you can not use recordcount as you need to go through the list a least once for this to work. With other connections i use nomatch!
Thanks
Joolz:rolleyes:
This is the resolution suggested by Microsoft for this issue that is a know situation with ADO:
[q]Use either adOpenKeyset or adOpenStatic as the CursorType for server side cursors or use a client side cursor. Client side cursors use only adOpenStatic for CursorTypes regardless of which CursorType you select. [/q]
The entire KB article is available via this link:
KB 194973