Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Custom View Parameter?
Message
From
10/09/2008 02:21:51
 
 
To
09/09/2008 10:10:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345719
Message ID:
01346254
Views:
20
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform