Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiuser DBF Record Insertion and Display
Message
De
11/09/2003 19:01:44
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Multiuser DBF Record Insertion and Display
Divers
Thread ID:
00828357
Message ID:
00828357
Vues:
34
Form with a Private Datasession using a grid driven by a cursor created by SQL-Select.  When User A adds a record to this table, user B will not see the new record, even if form is closed and reopened, unless application is closed and reopened.  Also happens with two copies of the application on the same machine.

However, if another form is opened which has a grid driven by a local view, it shows the new record(s) and henceforth the original form will show the new record(s).

Tried SET REFRESH -- didn't work.  Tried REQUERY() and REFRESH() even though they didn't seem likely to work -- they did not work.

Added SELECT * FROM <table> to LOAD() resulting in BROWSE window which included new records and fixed the problem, but SELECT ... INTO CURSOR didn't fix the problem, even when followed by a BROWSE.

Subquestion that may help -- how is SELECT ... INTO CURSOR \ BROWSE different from SELECT without "INTO" phrase (resulting in BROWSE of the cursor)?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform