why does dynamic cursor change to readonly during runtime??

Question

using VB & ADODB recordset in sql

Answer 1

I guess you're asking why you declare a cursor as dynamic, but still get static recordset?
Well, depends mostly on the SQL you're executing. If you are querying an SQL Server View or stored procedure results, its always yielding static recordsets. Any joins in SQL Server query may result in same.