>SELECT *; > FROM ; > solidwaste!fac_mas; > ORDER BY Fac_mas.operator > >DBSetProp(ThisView,"View","SendUpdates",.T.) >DBSetProp(ThisView,"View","BatchUpdateCount",1) >DBSetProp(ThisView,"View","CompareMemo",.T.) >DBSetProp(ThisView,"View","FetchAsNeeded",.F.) >DBSetProp(ThisView,"View","FetchMemo",.T.) >DBSetProp(ThisView,"View","FetchSize",100) >DBSetProp(ThisView,"View","MaxRecords",-1) >DBSetProp(ThisView,"View","Prepared",.F.) >DBSetProp(ThisView,"View","UpdateType",1) >DBSetProp(ThisView,"View","UseMemoSize",255) >DBSetProp(ThisView,"View","Tables","solidwaste!fac_mas") >DBSetProp(ThisView,"View","WhereType",2) > >DBSetProp(ThisView+".denrid_no","Field","DataType","C(10)") >DBSetProp(ThisView+".denrid_no","Field","UpdateName","solidwaste!fac_mas.denrid_no") >DBSetProp(ThisView+".denrid_no","Field","KeyField",.T.) >DBSetProp(ThisView+".denrid_no","Field","Updatable",.T.) > >DBSetProp(ThisView+".sw_id","Field","DataType","C(6)") >DBSetProp(ThisView+".sw_id","Field","UpdateName","solidwaste!fac_mas.sw_id") >DBSetProp(ThisView+".sw_id","Field","KeyField",.F.) >DBSetProp(ThisView+".sw_id","Field","Updatable",.T.) > >DBSetProp(ThisView+".type","Field","DataType","C(5)") >DBSetProp(ThisView+".type","Field","UpdateName","solidwaste!fac_mas.type") >DBSetProp(ThisView+".type","Field","KeyField",.F.) >DBSetProp(ThisView+".type","Field","Updatable",.T.) > >DBSetProp(ThisView+".category","Field","DataType","C(15)") >DBSetProp(ThisView+".category","Field","UpdateName","solidwaste!fac_mas.category") >DBSetProp(ThisView+".category","Field","KeyField",.F.) >DBSetProp(ThisView+".category","Field","Updatable",.T.) > >DBSetProp(ThisView+".operator","Field","DataType","C(30)") >DBSetProp(ThisView+".operator","Field","UpdateName","solidwaste!fac_mas.operator") >DBSetProp(ThisView+".operator","Field","KeyField",.F.) >DBSetProp(ThisView+".operator","Field","Updatable",.T.) > >DBSetProp(ThisView+".poc_first","Field","DataType","C(20)") >DBSetProp(ThisView+".poc_first","Field","UpdateName","solidwaste!fac_mas.poc_first") >DBSetProp(ThisView+".poc_first","Field","KeyField",.F.) >DBSetProp(ThisView+".poc_first","Field","Updatable",.T.) > >DBSetProp(ThisView+".poc_last","Field","DataType","C(20)") >DBSetProp(ThisView+".poc_last","Field","UpdateName","solidwaste!fac_mas.poc_last") >DBSetProp(ThisView+".poc_last","Field","KeyField",.F.) >DBSetProp(ThisView+".poc_last","Field","Updatable",.T.) > >DBSetProp(ThisView+".poc_title","Field","DataType","C(50)") >DBSetProp(ThisView+".poc_title","Field","UpdateName","solidwaste!fac_mas.poc_title") >DBSetProp(ThisView+".poc_title","Field","KeyField",.F.) >DBSetProp(ThisView+".poc_title","Field","Updatable",.T.) > >DBSetProp(ThisView+".xnd_poc","Field","DataType","C(50)") >DBSetProp(ThisView+".xnd_poc","Field","UpdateName","solidwaste!fac_mas.xnd_poc") >DBSetProp(ThisView+".xnd_poc","Field","KeyField",.F.) >DBSetProp(ThisView+".xnd_poc","Field","Updatable",.T.) > >DBSetProp(ThisView+".address","Field","DataType","C(32)") >DBSetProp(ThisView+".address","Field","UpdateName","solidwaste!fac_mas.address") >DBSetProp(ThisView+".address","Field","KeyField",.F.) >DBSetProp(ThisView+".address","Field","Updatable",.T.) > >DBSetProp(ThisView+".city","Field","DataType","C(20)") >DBSetProp(ThisView+".city","Field","UpdateName","solidwaste!fac_mas.city") >DBSetProp(ThisView+".city","Field","KeyField",.F.) >DBSetProp(ThisView+".city","Field","Updatable",.T.) > >DBSetProp(ThisView+".state","Field","DataType","C(2)") >DBSetProp(ThisView+".state","Field","UpdateName","solidwaste!fac_mas.state") >DBSetProp(ThisView+".state","Field","KeyField",.F.) >DBSetProp(ThisView+".state","Field","Updatable",.T.) > >DBSetProp(ThisView+".zip","Field","DataType","C(10)") >DBSetProp(ThisView+".zip","Field","UpdateName","solidwaste!fac_mas.zip") >DBSetProp(ThisView+".zip","Field","KeyField",.F.) >DBSetProp(ThisView+".zip","Field","Updatable",.T.) > >DBSetProp(ThisView+".phone","Field","DataType","C(33)") >DBSetProp(ThisView+".phone","Field","UpdateName","solidwaste!fac_mas.phone") >DBSetProp(ThisView+".phone","Field","KeyField",.F.) >DBSetProp(ThisView+".phone","Field","Updatable",.T.) > >DBSetProp(ThisView+".phone2","Field","DataType","C(50)") >DBSetProp(ThisView+".phone2","Field","UpdateName","solidwaste!fac_mas.phone2") >DBSetProp(ThisView+".phone2","Field","KeyField",.F.) >DBSetProp(ThisView+".phone2","Field","Updatable",.T.) > >DBSetProp(ThisView+".fax","Field","DataType","C(15)") >DBSetProp(ThisView+".fax","Field","UpdateName","solidwaste!fac_mas.fax") >DBSetProp(ThisView+".fax","Field","KeyField",.F.) >DBSetProp(ThisView+".fax","Field","Updatable",.T.) > >DBSetProp(ThisView+".landowner","Field","DataType","C(30)") >DBSetProp(ThisView+".landowner","Field","UpdateName","solidwaste!fac_mas.landowner") >DBSetProp(ThisView+".landowner","Field","KeyField",.F.) >DBSetProp(ThisView+".landowner","Field","Updatable",.T.) > >DBSetProp(ThisView+".ap_date","Field","DataType","D") >DBSetProp(ThisView+".ap_date","Field","UpdateName","solidwaste!fac_mas.ap_date") >DBSetProp(ThisView+".ap_date","Field","KeyField",.F.) >DBSetProp(ThisView+".ap_date","Field","Updatable",.T.) > >DBSetProp(ThisView+".rmd_sent","Field","DataType","L") >DBSetProp(ThisView+".rmd_sent","Field","UpdateName","solidwaste!fac_mas.rmd_sent") >DBSetProp(ThisView+".rmd_sent","Field","KeyField",.F.) >DBSetProp(ThisView+".rmd_sent","Field","Updatable",.T.) > >DBSetProp(ThisView+".location","Field","DataType","C(49)") >DBSetProp(ThisView+".location","Field","UpdateName","solidwaste!fac_mas.location") >DBSetProp(ThisView+".location","Field","KeyField",.F.) >DBSetProp(ThisView+".location","Field","Updatable",.T.) > >DBSetProp(ThisView+".legal_des","Field","DataType","C(61)") >DBSetProp(ThisView+".legal_des","Field","UpdateName","solidwaste!fac_mas.legal_des") >DBSetProp(ThisView+".legal_des","Field","KeyField",.F.) >DBSetProp(ThisView+".legal_des","Field","Updatable",.T.) > >DBSetProp(ThisView+".county","Field","DataType","C(12)") >DBSetProp(ThisView+".county","Field","UpdateName","solidwaste!fac_mas.county") >DBSetProp(ThisView+".county","Field","KeyField",.F.) >DBSetProp(ThisView+".county","Field","Updatable",.T.) > >DBSetProp(ThisView+".close_year","Field","DataType","N(4)") >DBSetProp(ThisView+".close_year","Field","UpdateName","solidwaste!fac_mas.close_year") >DBSetProp(ThisView+".close_year","Field","KeyField",.F.) >DBSetProp(ThisView+".close_year","Field","Updatable",.T.) > >DBSetProp(ThisView+".pmt_tons","Field","DataType","C(15)") >DBSetProp(ThisView+".pmt_tons","Field","UpdateName","solidwaste!fac_mas.pmt_tons") >DBSetProp(ThisView+".pmt_tons","Field","KeyField",.F.) >DBSetProp(ThisView+".pmt_tons","Field","Updatable",.T.) > >DBSetProp(ThisView+".actual_ton","Field","DataType","C(15)") >DBSetProp(ThisView+".actual_ton","Field","UpdateName","solidwaste!fac_mas.actual_ton") >DBSetProp(ThisView+".actual_ton","Field","KeyField",.F.) >DBSetProp(ThisView+".actual_ton","Field","Updatable",.T.) > >DBSetProp(ThisView+".acres","Field","DataType","N(6,2)") >DBSetProp(ThisView+".acres","Field","UpdateName","solidwaste!fac_mas.acres") >DBSetProp(ThisView+".acres","Field","KeyField",.F.) >DBSetProp(ThisView+".acres","Field","Updatable",.T.) > >DBSetProp(ThisView+".permit","Field","DataType","C(36)") >DBSetProp(ThisView+".permit","Field","UpdateName","solidwaste!fac_mas.permit") >DBSetProp(ThisView+".permit","Field","KeyField",.F.) >DBSetProp(ThisView+".permit","Field","Updatable",.T.) > >DBSetProp(ThisView+".issued","Field","DataType","D") >DBSetProp(ThisView+".issued","Field","UpdateName","solidwaste!fac_mas.issued") >DBSetProp(ThisView+".issued","Field","KeyField",.F.) >DBSetProp(ThisView+".issued","Field","Updatable",.T.) > >DBSetProp(ThisView+".expires","Field","DataType","D") >DBSetProp(ThisView+".expires","Field","UpdateName","solidwaste!fac_mas.expires") >DBSetProp(ThisView+".expires","Field","KeyField",.F.) >DBSetProp(ThisView+".expires","Field","Updatable",.T.) > >DBSetProp(ThisView+".status","Field","DataType","C(15)") >DBSetProp(ThisView+".status","Field","UpdateName","solidwaste!fac_mas.status") >DBSetProp(ThisView+".status","Field","KeyField",.F.) >DBSetProp(ThisView+".status","Field","Updatable",.T.) > >DBSetProp(ThisView+".gi","Field","DataType","C(2)") >DBSetProp(ThisView+".gi","Field","UpdateName","solidwaste!fac_mas.gi") >DBSetProp(ThisView+".gi","Field","KeyField",.F.) >DBSetProp(ThisView+".gi","Field","Updatable",.T.) > >DBSetProp(ThisView+".years","Field","DataType","N(2)") >DBSetProp(ThisView+".years","Field","UpdateName","solidwaste!fac_mas.years") >DBSetProp(ThisView+".years","Field","KeyField",.F.) >DBSetProp(ThisView+".years","Field","Updatable",.T.) > >DBSetProp(ThisView+".closure","Field","DataType","D") >DBSetProp(ThisView+".closure","Field","UpdateName","solidwaste!fac_mas.closure") >DBSetProp(ThisView+".closure","Field","KeyField",.F.) >DBSetProp(ThisView+".closure","Field","Updatable",.T.) > >DBSetProp(ThisView+".certif","Field","DataType","L") >DBSetProp(ThisView+".certif","Field","UpdateName","solidwaste!fac_mas.certif") >DBSetProp(ThisView+".certif","Field","KeyField",.F.) >DBSetProp(ThisView+".certif","Field","Updatable",.T.) > >DBSetProp(ThisView+".comp","Field","DataType","L") >DBSetProp(ThisView+".comp","Field","UpdateName","solidwaste!fac_mas.comp") >DBSetProp(ThisView+".comp","Field","KeyField",.F.) >DBSetProp(ThisView+".comp","Field","Updatable",.T.) > >DBSetProp(ThisView+".asbestos","Field","DataType","L") >DBSetProp(ThisView+".asbestos","Field","UpdateName","solidwaste!fac_mas.asbestos") >DBSetProp(ThisView+".asbestos","Field","KeyField",.F.) >DBSetProp(ThisView+".asbestos","Field","Updatable",.T.) > >DBSetProp(ThisView+".cd","Field","DataType","L") >DBSetProp(ThisView+".cd","Field","UpdateName","solidwaste!fac_mas.cd") >DBSetProp(ThisView+".cd","Field","KeyField",.F.) >DBSetProp(ThisView+".cd","Field","Updatable",.T.) > >DBSetProp(ThisView+".carcass","Field","DataType","L") >DBSetProp(ThisView+".carcass","Field","UpdateName","solidwaste!fac_mas.carcass") >DBSetProp(ThisView+".carcass","Field","KeyField",.F.) >DBSetProp(ThisView+".carcass","Field","Updatable",.T.) > >DBSetProp(ThisView+".furniture","Field","DataType","L") >DBSetProp(ThisView+".furniture","Field","UpdateName","solidwaste!fac_mas.furniture") >DBSetProp(ThisView+".furniture","Field","KeyField",.F.) >DBSetProp(ThisView+".furniture","Field","Updatable",.T.) > >DBSetProp(ThisView+".white_good","Field","DataType","L") >DBSetProp(ThisView+".white_good","Field","UpdateName","solidwaste!fac_mas.white_good") >DBSetProp(ThisView+".white_good","Field","KeyField",.F.) >DBSetProp(ThisView+".white_good","Field","Updatable",.T.) > >DBSetProp(ThisView+".tires","Field","DataType","L") >DBSetProp(ThisView+".tires","Field","UpdateName","solidwaste!fac_mas.tires") >DBSetProp(ThisView+".tires","Field","KeyField",.F.) >DBSetProp(ThisView+".tires","Field","Updatable",.T.) > >DBSetProp(ThisView+".pcs","Field","DataType","L") >DBSetProp(ThisView+".pcs","Field","UpdateName","solidwaste!fac_mas.pcs") >DBSetProp(ThisView+".pcs","Field","KeyField",.F.) >DBSetProp(ThisView+".pcs","Field","Updatable",.T.) > >DBSetProp(ThisView+".single_app","Field","DataType","L") >DBSetProp(ThisView+".single_app","Field","UpdateName","solidwaste!fac_mas.single_app") >DBSetProp(ThisView+".single_app","Field","KeyField",.F.) >DBSetProp(ThisView+".single_app","Field","Updatable",.T.) > >DBSetProp(ThisView+".assigned","Field","DataType","C(5)") >DBSetProp(ThisView+".assigned","Field","UpdateName","solidwaste!fac_mas.assigned") >DBSetProp(ThisView+".assigned","Field","KeyField",.F.) >DBSetProp(ThisView+".assigned","Field","Updatable",.T.) > >DBSetProp(ThisView+".comments","Field","DataType","M") >DBSetProp(ThisView+".comments","Field","UpdateName","solidwaste!fac_mas.comments") >DBSetProp(ThisView+".comments","Field","KeyField",.F.) >DBSetProp(ThisView+".comments","Field","Updatable",.T.) > >DBSetProp(ThisView+".fa","Field","DataType","L") >DBSetProp(ThisView+".fa","Field","UpdateName","solidwaste!fac_mas.fa") >DBSetProp(ThisView+".fa","Field","KeyField",.F.) >DBSetProp(ThisView+".fa","Field","Updatable",.T.) > >DBSetProp(ThisView+".fa_comment","Field","DataType","M") >DBSetProp(ThisView+".fa_comment","Field","UpdateName","solidwaste!fac_mas.fa_comment") >DBSetProp(ThisView+".fa_comment","Field","KeyField",.F.) >DBSetProp(ThisView+".fa_comment","Field","Updatable",.T.) > >DBSetProp(ThisView+".inspection","Field","DataType","D") >DBSetProp(ThisView+".inspection","Field","UpdateName","solidwaste!fac_mas.inspection") >DBSetProp(ThisView+".inspection","Field","KeyField",.F.) >DBSetProp(ThisView+".inspection","Field","Updatable",.T.) > >DBSetProp(ThisView+".annual_rpt","Field","DataType","D") >DBSetProp(ThisView+".annual_rpt","Field","UpdateName","solidwaste!fac_mas.annual_rpt") >DBSetProp(ThisView+".annual_rpt","Field","KeyField",.F.) >DBSetProp(ThisView+".annual_rpt","Field","Updatable",.T.) > >DBSetProp(ThisView+".start_up","Field","DataType","D") >DBSetProp(ThisView+".start_up","Field","UpdateName","solidwaste!fac_mas.start_up") >DBSetProp(ThisView+".start_up","Field","KeyField",.F.) >DBSetProp(ThisView+".start_up","Field","Updatable",.T.) > >DBSetProp(ThisView+".tip_fee","Field","DataType","C(50)") >DBSetProp(ThisView+".tip_fee","Field","UpdateName","solidwaste!fac_mas.tip_fee") >DBSetProp(ThisView+".tip_fee","Field","KeyField",.F.) >DBSetProp(ThisView+".tip_fee","Field","Updatable",.T.) > >DBSetProp(ThisView+".next_insp","Field","DataType","D") >DBSetProp(ThisView+".next_insp","Field","UpdateName","solidwaste!fac_mas.next_insp") >DBSetProp(ThisView+".next_insp","Field","KeyField",.F.) >DBSetProp(ThisView+".next_insp","Field","Updatable",.T.) > >DBSetProp(ThisView+".latitude","Field","DataType","N(10,6)") >DBSetProp(ThisView+".latitude","Field","UpdateName","solidwaste!fac_mas.latitude") >DBSetProp(ThisView+".latitude","Field","KeyField",.F.) >DBSetProp(ThisView+".latitude","Field","Updatable",.T.) > >DBSetProp(ThisView+".longitude","Field","DataType","N(12,6)") >DBSetProp(ThisView+".longitude","Field","UpdateName","solidwaste!fac_mas.longitude") >DBSetProp(ThisView+".longitude","Field","KeyField",.F.) >DBSetProp(ThisView+".longitude","Field","Updatable",.T.) > >DBSetProp(ThisView+".pcs_excap","Field","DataType","L") >DBSetProp(ThisView+".pcs_excap","Field","UpdateName","solidwaste!fac_mas.pcs_excap") >DBSetProp(ThisView+".pcs_excap","Field","KeyField",.F.) >DBSetProp(ThisView+".pcs_excap","Field","Updatable",.T.) > >DBSetProp(ThisView+".pcs_cap","Field","DataType","L") >DBSetProp(ThisView+".pcs_cap","Field","UpdateName","solidwaste!fac_mas.pcs_cap") >DBSetProp(ThisView+".pcs_cap","Field","KeyField",.F.) >DBSetProp(ThisView+".pcs_cap","Field","Updatable",.T.) > >DBSetProp(ThisView+".accuracy","Field","DataType","N(3)") >DBSetProp(ThisView+".accuracy","Field","UpdateName","solidwaste!fac_mas.accuracy") >DBSetProp(ThisView+".accuracy","Field","KeyField",.F.) >DBSetProp(ThisView+".accuracy","Field","Updatable",.T.) > >DBSetProp(ThisView+".geocode","Field","DataType","C(8)") >DBSetProp(ThisView+".geocode","Field","UpdateName","solidwaste!fac_mas.geocode") >DBSetProp(ThisView+".geocode","Field","KeyField",.F.) >DBSetProp(ThisView+".geocode","Field","Updatable",.T.) > >DBSetProp(ThisView+".reference","Field","DataType","C(250)") >DBSetProp(ThisView+".reference","Field","UpdateName","solidwaste!fac_mas.reference") >DBSetProp(ThisView+".reference","Field","KeyField",.F.) >DBSetProp(ThisView+".reference","Field","Updatable",.T.) > >DBSetProp(ThisView+".inspect_comm","Field","DataType","M") >DBSetProp(ThisView+".inspect_comm","Field","UpdateName","solidwaste!fac_mas.inspect_comm") >DBSetProp(ThisView+".inspect_comm","Field","KeyField",.F.) >DBSetProp(ThisView+".inspect_comm","Field","Updatable",.T.) > >DBSetProp(ThisView+".app_comments","Field","DataType","M") >DBSetProp(ThisView+".app_comments","Field","UpdateName","solidwaste!fac_mas.app_comments") >DBSetProp(ThisView+".app_comments","Field","KeyField",.F.) >DBSetProp(ThisView+".app_comments","Field","Updatable",.T.) > >DBSetProp(ThisView+".trees","Field","DataType","L") >DBSetProp(ThisView+".trees","Field","UpdateName","solidwaste!fac_mas.trees") >DBSetProp(ThisView+".trees","Field","KeyField",.F.) >DBSetProp(ThisView+".trees","Field","Updatable",.T.) > >DBSetProp(ThisView+".date_gps","Field","DataType","D") >DBSetProp(ThisView+".date_gps","Field","UpdateName","solidwaste!fac_mas.date_gps") >DBSetProp(ThisView+".date_gps","Field","KeyField",.F.) >DBSetProp(ThisView+".date_gps","Field","Updatable",.T.) > >DBSetProp(ThisView+".who_gps","Field","DataType","C(5)") >DBSetProp(ThisView+".who_gps","Field","UpdateName","solidwaste!fac_mas.who_gps") >DBSetProp(ThisView+".who_gps","Field","KeyField",.F.) >DBSetProp(ThisView+".who_gps","Field","Updatable",.T.) > >DBSetProp(ThisView+".renewal_notice","Field","DataType","D") >DBSetProp(ThisView+".renewal_notice","Field","UpdateName","solidwaste!fac_mas.renewal_notice") >DBSetProp(ThisView+".renewal_notice","Field","KeyField",.F.) >DBSetProp(ThisView+".renewal_notice","Field","Updatable",.T.) > >DBSetProp(ThisView+".pcswcap","Field","DataType","L") >DBSetProp(ThisView+".pcswcap","Field","UpdateName","solidwaste!fac_mas.pcswcap") >DBSetProp(ThisView+".pcswcap","Field","KeyField",.F.) >DBSetProp(ThisView+".pcswcap","Field","Updatable",.T.) > >DBSetProp(ThisView+".microinfo","Field","DataType","M") >DBSetProp(ThisView+".microinfo","Field","UpdateName","solidwaste!fac_mas.microinfo") >DBSetProp(ThisView+".microinfo","Field","KeyField",.F.) >DBSetProp(ThisView+".microinfo","Field","Updatable",.T.) > >