Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to requery() a grid
Message
 
To
13/04/2000 13:42:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00359397
Message ID:
00359695
Views:
10
Erik

Thanks for your reply.

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.
Can you live without the earth?
Please remind that :
"Yung Hung" is my first name;
"Yeung" is my last/family name.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform