Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding Custom View Parameter?
Message
De
10/09/2008 02:21:51
 
 
À
09/09/2008 10:10:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01345719
Message ID:
01346254
Vues:
21
>One odd side affect of this, my view comes up in a browse window before allowing me to view the results in my grid. I have to Esc out of the browse window before I can see the results.
>My view is still defined the same way:
>
>CREATE SQL VIEW "LV_STUDENT" ;
>   AS SELECT Student.CID,;
>....
>
>   ORDER BY Student.CLASTNAME, Student.CFIRSTNAME
>

Amanda,

If you are not happy with the '&?param' construct then consider another option which is less flexible
(1) Add a city parameter to the view's sql statement
create sql view  TheView as
select ...
 from ...
where (city.cid like ?CitySelection)
(2) 
use TheView  in 0 nodata
(3)
private CitySelection

if( !Betty )
   CitySelection= '%'
else
   CitySelection = '13'
endif

=Requery('TheView')
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform