Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data inserted in one session cannot be found in another
Message
From
18/02/2004 09:16:47
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Data inserted in one session cannot be found in another
Miscellaneous
Thread ID:
00878266
Message ID:
00878266
Views:
48
Hi all,
I open a modeless form twice. Both using private data sessions accessing doing the same transaction entry. When form A saved a new record, form b can't locate the new record inserted by form A. I'm using transactions and tableupdates and local views for data entry.
However, if I exit form B and restart the form again, the record can be found.
Set refresh is set to 1,1 and I'm not using browse, just textboxes and grid for the form to display the one to many child records.
Also in the saving method, after the end transaction command, I actually do a locate and go bott to move the record pointer.
In the search button, I'll select the parent table, do a locate and go bottom to move the record pointer before searching for the record.
Anything I missed out?
Using VFP6SP5 on WinXP,2k environment.
Yau
Next
Reply
Map
View

Click here to load this message in the networking platform