About rs.recordcount? 1

[hu68]

Hi,all

I uae the same database connection,same sql,if I use "set rs=conn.execute(sql)" to get recordset,rs.recordcount return value=-1.if I use "rs.Open sql, conn, adOpenStatic " ,rs.recordcount return correct value.Could some know the reason for it?
Thanks

 

[dbrom]

The reason is that these statements use two different types of cursors.

rs=conn.execute(sql) uses adUseServer cursor, and you can't use record count with it.

rs.Open sql, conn, adOpenStatic uses adUseClient cursor, and you get the correct recordcount with it.

Hope this helps... <Dmitriy>
dbrom@crosswinds.net

 

[hu68]

Thank you dbrom
your reply is clear.

 

[dbrom]

Same thing happens if you use a stored procedure, for instance, and an ADO Command object.

When you write:
rs = command.Execute(), it will also use a adUseServer cursor, similarly to conn.Execute() <Dmitriy>
dbrom@crosswinds.net