Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser DBF Record Insertion and Display
Message
From
11/09/2003 19:01:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Multiuser DBF Record Insertion and Display
Miscellaneous
Thread ID:
00828357
Message ID:
00828357
Views:
33
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)?
Next
Reply
Map
View

Click here to load this message in the networking platform