Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Param views not updating properly in 2 separate exes
Message
From
22/07/1999 16:07:28
 
 
To
22/07/1999 12:15:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00244820
Message ID:
00244962
Views:
13
>Two separate machines bring up the same form using a parameterized date-range view. After one user on Machine A adds a record and saves it. Machine B then closes the form and reopens the form, but the added record doesn't show.
>
>Has anyone seen this kind of behavior before?
>
>I'm implementing an odd work around. When the form first opens I force a change by replacing one of the views fields with itself and then tableupdate the view. After this I call the requery. For some reason I can now see the other record.
>

I take it you have "Changed fields only" as the update type in your view definition? If you change this to "key fields" you won't need to do that silly replace before you do a TABLEUPDATE().

Are you surethat Machine A is doing a TABLEUPDATE()? Are you sure the TABLEUPDATE is successful?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform