Local View Trouble - Level Extreme

Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local View Trouble
Message
From
11/12/2008 12:54:47
Ron Duvall
Pierre, South Dakota, United States
11/12/2008 12:45:07
Naomi Nosonovsky
Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: Local View Trouble
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01366468
Message ID:
01366676
Views:
Where can you see update criteria path? I have the sql coding. I can't tell where the issue is here either though. microinfo (last field listed) is the one giving me the problem.
SELECT *;
 FROM ;
     solidwaste!fac_mas;
 ORDER BY Fac_mas.operator

DBSetProp(ThisView,"View","SendUpdates",.F.)
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","WhereType",1)

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",.F.)
DBSetProp(ThisView+".denrid_no","Field","Updatable",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)

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",.F.)
Map
View
Click here to load this message in the networking platform