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:39:17
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
18/02/2004 09:16:47
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00878266
Message ID:
00878282
Views:
16
>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

You'd need to requery the views to see the changes. The view is holding, well, a view - a snapshot of the data as they were at the moment it was opened or requeried. If the underlying data change meanwhile, the view isn't given any notice of that. You may requery the view when the form activates, or at any other moment you may find convenient, if you want your form to show the latest and greatest data.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform