Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00246889
Message ID:
00247469
Views:
25
Douglas,
You were using a view for data entry? I missed that in your first message :-( One other thing to check if you are using private datasessions is do you have the table open in your default datasession. This is done in Visual Maxframe, for example, to speed up opening tables. However, VFP will often USE AGAIN the table in the default DS. We had this problem and even closing the table didn't always work. We first had to stop VMF from loading the table in the default DS.

Barbara

>Ed,
>
>Thanks for the reply. I think that you hit the proverbial nail. As a quick work-around, I modified my code last night to force the table close and then re-open it prior to the SQL command. Now, my modified data is appearing in the Array and list box. The thing that has me mystified is why this does not occur with a newly added item, only with a record that has been modified. I would think that any problem would have to affect each of these situations the same way. If the reason for the lack of fresh data is that the View is also buffered then why would the buffered view get a new record when the TableUpdate() is issued but will not get an edited/modified record?
>
>I will work with this some more to determine any other reasons.
>..douglas
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform