Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Refreshing Parameterized View
Hi All,
I have a tabbed form with a company page and a contacts page, what I want to be able to do is when I click on the contacts page it shows all the contacts at the company. I can do this easily using a grid with the contacts table as the recordsource which relates to the companyid in the company table. I want to modify the code to use a local parameterized view for the contacts page. I've created the view and added it to the forms dataenvironment, but when I click on the contacts page the contacts grid is empty
My view was created using the following code:
CREATE SQL VIEW contacts_view AS SELECT * FROM contacts ;
WHERE companyid = ?companies.companyid
I haven't used Views much and I was kind of hoping that the view would refresh when COMPANIES.COMPANYID changed, is this wishful thinking? Is there a way to do a ReQuery on the grid so that the parameterized view is refreshed with the contacts from the chosen company? Can someone please point me in the right direction?
Thanks,
Gavin...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement