That is the cursor location not the type. You have to set the cursor type to static or keyset cursor to get the recordcount.
-----Original Message----- From: MaxDB - Mailing List [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 2:47 PM To: [EMAIL PROTECTED] Subject: ADODB recordcount Does anyone know how to retrieve the record count from a stored procedure that returns a cursor? I do not want to use the Count() function as that will result in 2 queries. I have set the cursortype to adUseClient but I always get -1 for rsRecordSet.RecordCount. Any ideas? Thanks in advance. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
