I am querying a SQL Server joining two tables using ADO to return a client side updatable recordset. I have used two different methods to retrieve the recordset, by using a Comand Object to execute a SP to get the rows and by using the recordset Open method passing the SQL string. The recordset Open method returns an updatable recordset as expected but the Command Object executing the SP returns a non-updatable records set. For testing I am executing the same basic code, just substituting the necessary code to vary the two methods. In both cases, the recordset is declared adClientSide, a cursortype of adOpenStatic and a locktype of adLockBatchOptimistic before the rows are retrieved. The SQL is identical in both cases, basically a cut/paste from the SP. However when using the Command Object/SP method, the recordset is coerced to adReadOnly on the client side. What am I missing that would cause this to happen?
Thanks,
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.