Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to requery() a grid
Message
 
À
13/04/2000 13:42:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00359397
Message ID:
00359695
Vues:
11
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform