>>I'm not sure if I understand your problem, but I use views in forms' DEs all the time without adding the underlying tables, or opening them in the default session.
>
>That will not be necessary if you have all the tables in the DBC. In my case, only the view is in the DBC and the tables are free tables.

Michel,

For these cases, I define the view in code and add it to the DBC. I store the path to the free tables in the registry, and have the user define it in his preferences. When leaving the preferences form, I rewrite the view according to the new path. So no need to open the tables before running the view.

Something in these lines:



lcTiers = ALLTRIM(GoApp.GetSetting(COMPTADIR_KEY, APPCLASS))+"tiers"
lcComptes = ALLTRIM(GoApp.GetSetting(COMPTADIR_KEY, APPCLASS))+"Comptes"

***************** View setup for LV_CLIENTS ***************

CREATE SQL VIEW "LV_CLIENTS" ;
AS SELECT Tiers.comp AS ccompte, ;
Tiers.inti AS cintitule, ;
Comptes.lett AS nlettrable, ;
Comptes.bloq AS nutilisable, ;
Comptes.saie AS nsaisieecheance, ;
Comptes.saip AS nsaisiepointage, ;
Comptes.saiq AS nsaisiequantite, ;
Tiers.nom AS cnomtiers, ;
Tiers.ad1 AS cadresse1, ;
Tiers.ad2 AS cadresse2, ;
Tiers.ad3 AS cadresse3, ;
Tiers.cp AS cpostal, ;
Tiers.vill AS clocalite, ;
Tiers.tele AS ctel, ;
Tiers.fax AS cfax, ;
Tiers.modr AS creglement, ;
Tiers.banq AS cbanque, ;
Tiers.pays AS cpays, ;
Tiers.lang AS clangue, ;
Tiers.tva AS ctva ;
FROM &lctiers INNER JOIN &lccomptes ;
ON Tiers.comp = Comptes.comp ;
WHERE Tiers.comp = "400" ;
AND Tiers.comp <> "400000" ;
AND UPPER(Tiers.comp) = UPPER(?vp_cCompte) ;
AND Tiers.cp = ?vp_cPostal ;
AND Tiers.tva = ?vp_cTva ;
AND UPPER(Tiers.inti) = UPPER(?vp_cIntitule) ;
ORDER BY Tiers.comp



José