From the quick glance it seems to be OK, but it's better to only select fields that you really need and specify them explicitly in your statement.

>For the record, I'm getting the error when running the database and using Select 1, Select 2 procedures. I have only checked one field as a key (since you need to select one as a key to select the others).
>
>
>

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