Adodb

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