Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing Parameterized View
Message
 
To
06/09/2000 03:06:19
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00412800
Message ID:
00412803
Views:
18
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform