>CREATE SQL VIEW "LV_PLANSCHOOLS" ; > AS SELECT Planschools.cid, Planschools.cschool,; > Planschools.clogo, Planschools.linsteval, Planschools.cstate,; > Planschools.ltoprated, Planschools.lacceptds, Planschools.csemqtr,; > Planschools.lexpcreditok, Planschools.lnatcredok,; > Planschools.nlltuit, Planschools.nultuit, Planschools.ngltuit,; > Planschools.nclasshrs, Planschools.nmatcost, Planschools.llockout,; > Planschools.cfinaidid, Planschools.lacceptclepgen,; > Planschools.lacceptclepsub, Planschools.lacceptdsst,; > Planschools.lacceptexcl, Planschools.ccollegeid,; > Planschools.mnotes, Planschools.lnatacredited, Planschools.tsaved,; > Planschools.csavedby; > FROM autodp!planschools; > WHERE UPPER(Planschools.cschool) LIKE UPPER(?vp_cschool) AND; > Planschools.cstate = ( ?vp_cstate ) AND &vp_lfilter; > ORDER BY Planschools.cschool > >DBSetProp('LV_PLANSCHOOLS', 'View', 'UpdateType', 1) >DBSetProp('LV_PLANSCHOOLS', 'View', 'WhereType', 3) >DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchMemo', .T.) >DBSetProp('LV_PLANSCHOOLS', 'View', 'SendUpdates', .T.) >DBSetProp('LV_PLANSCHOOLS', 'View', 'UseMemoSize', 255) >DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchSize', 100) >DBSetProp('LV_PLANSCHOOLS', 'View', 'MaxRecords', -1) >DBSetProp('LV_PLANSCHOOLS', 'View', 'Tables', 'autodp!planschools') >DBSetProp('LV_PLANSCHOOLS', 'View', 'Prepared', .F.) >DBSetProp('LV_PLANSCHOOLS', 'View', 'CompareMemo', .T.) >DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchAsNeeded', .F.) >DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchSize', 100) >DBSetProp('LV_PLANSCHOOLS', 'View', 'ParameterList', "vp_cschool,'C';vp_cstate,'C';vp_lfilter,'L'") >DBSetProp('LV_PLANSCHOOLS', 'View', 'Comment', "") >DBSetProp('LV_PLANSCHOOLS', 'View', 'BatchUpdateCount', 1) >DBSetProp('LV_PLANSCHOOLS', 'View', 'ShareConnection', .F.) > >