Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refreshing Parameterized View
Message
 
À
06/09/2000 03:06:19
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00412800
Message ID:
00412803
Vues:
17
>My view was created using the following code:
>CREATE SQL VIEW contacts_view AS SELECT * FROM contacts ;
> WHERE companyid = ?companies.companyid


Hello,

Why make it parameterized?
You can simply use
SELECT * FROM contacts ;
    WHERE companyid = companies.companyid;
    INTO CURSOR cContacts
Now you can set your controlsource of the grid to cContacts.
In the activate of the contacts page you can set
Requery('cContacts')
or
YourGridRef.Requery()
Then it should work
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform