ADO _RecordsetPtr Update after requery () ()-CodePudding

In the use of adUseClient _RecordsetPtr adOpenStatic open, after the update, why still need to Requery, can see the changes in the _RecordsetPtr,

CodePudding user response:

Baidu search relevant keywords,

CodePudding user response:

Const adOpenStatic=3 'static cursor, just a snapshot of the data, the user said to record the changes made, add or delete records will not be reflected in the recordset, support to move forward or backward

CodePudding user response:

Using a cursor on the server adUseServer, and use dynamic cursors

CodePudding user response:

refer to the second floor oyljerry response:

Const adOpenStatic=3 'static cursor, just a snapshot of the data, the user said to record the changes made, add or delete records will not be reflected in the recordset, support to move forward or backward

I look all that is to say, the changes to other users, add or delete records not reflected in the recordset, changes that the current record set, should be visible

CodePudding user response:

reference worldy reply: 3/f

use server-side cursor, adUseServer, and using dynamic cursor

If use adUseServer, browsing is rising slowly

CodePudding user response:

reference 5 floor woshi_hujunjun reply:

Quote: refer to the third floor worldy response:

Using a cursor on the server adUseServer and use dynamic cursors

If use adUseServer, browsing is rising slowly

Yes, still use adUseClient, need to check the update to reload the recordset

CodePudding user response:

reference 4 floor woshi_hujunjun response:

Quote: refer to the second floor oyljerry response:

Const adOpenStatic=3 'static cursor, just a snapshot of the data, the user said to record the changes made, add or delete records will not be reflected in the recordset, support to move forward or backward

I look all that is to say, the changes to other users, add or delete records, reflected in the records of the current record set changes, should be visible.

CodePudding user response:

refer to 7th floor woshi_hujunjun response:

Quote: refer to 4th floor woshi_hujunjun response:

Quote: refer to the second floor oyljerry response:

Const adOpenStatic=3 'static cursor, just a snapshot of the data, the user said to record the changes made, add or delete records will not be reflected in the recordset, support to move forward or backward

I look all that is to say, the changes to other users, add or delete records, reflected in the records of the current record set changes, should be visible.

With same adOpenKeySet, after the update to requery to see their own modifications, putcollent, don't modify the local records set first