Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to requery() a grid
Message
From
14/04/2000 08:10:55
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00359397
Message ID:
00359726
Views:
12
Are you sure? Did you substitute the name of your view for "MyView"? You should at least get another error message...

>I have only one view in my form. I tried REQUERY("MYVIEW") but got same error message. The grid, command button and dataenvironment are stored in MYFORM.
>Do you have any idea?
>
>Sunny
>
>>>Hello everyone,
>>>
>>>Haven't see you for a long long time.
>>>
>>>I have a grid in a form normally. The recordsource is a local view. When I update the form, I want the view update, too. But, when I fire 'requery()' from one of the button in the form. A error message came out that 'This command is not allowed in local table.'(i forgot the exact message, something like that). How?????
>>>Requery() is a very common command to update the view. Why it can't run in my case? Do I have another choice?
>>>
>>>ps.i miss vfp very much.
>>>
>>>Sunny
>>
>>Hello, Sunny.
>>
>>REQUERY() can only be used on views. It looks like when you issue REQUERY() the current alias is not the view like you think. For this reason, it's a good idea to get into the habit of specifying the alias of the view want to requery in the REQUERY command:
>>
>>=REQUERY("MyView")
>>
>>This way, you won't ever be surprised by the current alias.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform