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.)