Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing Parameterized View
Message
From
06/09/2000 09:05:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00412800
Message ID:
00412872
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()
>

Grids don't have a Requery Method.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform