>CREATE SQL VIEW "LV_STUDENT" ; > AS SELECT Student.CID,; >.... > > ORDER BY Student.CLASTNAME, Student.CFIRSTNAME >
(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')