Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Forms based on views not updating.
Message
From
21/07/1999 22:57:02
 
 
To
21/07/1999 22:52:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00244441
Message ID:
00244534
Views:
14
>Are you using record or table buffering?
>
>Do you pass the name of the view to the Requery() method? (Requery("MyView")) If not, are you sure you are in the right area before issuing the Requery()?
>
>Does Requery() return 1 for success?
>
>>VMP has a ShellAdditionalInit, which is the last thing prior to showing and activating the form. In this method we are doing the requery. At first we thought that, as you had said, maybe in VMP, ( for performance reasons ) the form is just hidden and then shown when re-opened.
>>
>>But, we placed a wait window to verify that the ShellAdditionalInit method was called.

Table buffering. Yes, I am passing the name to the requery method.

I've never checked for successful requery. Excellent suggestion. I've set up a kludge which when the form opens up, in the ShellAdditionalInit, I force a change by replacing one of the view fields by itself and then I call the forms save action. Finally, I do the requery.

Amazingly this works, though I couldn't tell you why.

Dan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform