I need a little clarification on the difference between
a 'static' cursor type and a 'dynamic' cursor type on a connection.
Consider if I were stepping through a recordset with a dynamic cursor type using the objRecordSet.MoveNext command. If I had stepped through the first two records using objRecordSet.MoveNext and another seperate session updated a value in one of the fields in the third record; would I see the effect of that update if I performed my objRecordSet.MoveNext just after the seperate session had updated the record?
I think a static cursor type would retain the values from before the seperate session had updated the third record.
Am I correct about these assumptions?
many Thanks.
a 'static' cursor type and a 'dynamic' cursor type on a connection.
Consider if I were stepping through a recordset with a dynamic cursor type using the objRecordSet.MoveNext command. If I had stepped through the first two records using objRecordSet.MoveNext and another seperate session updated a value in one of the fields in the third record; would I see the effect of that update if I performed my objRecordSet.MoveNext just after the seperate session had updated the record?
I think a static cursor type would retain the values from before the seperate session had updated the third record.
Am I correct about these assumptions?
many Thanks.