TRY USE myTable EXCLUSIVE NOUPDATE SCAN SCATTER MEMO MEMVAR ENDSCAN CATCH TO loError IF loError.ErrorNo=41 * handle error here ENDIF ENDTRY USE IN myTable>> The error occurs only if the table is opened exclusive.
Source : UPDATE bizsystem!tb_fields SET ikey_fld=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_fld,ikey_vws=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_vws,ikey_tlb=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_tlb,cfield=xmltable_7eb45317_86a2_4a47_8984_638282469348_.cfield,chelptitle=xmltable_7eb45317_86a2_4a47_8984_638282469348_.chelptitle,cupdatename=xmltable_7eb45317_86a2_4a47_8984_638282469348_.cupdatename,ctype=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ctype,iwidth=xmltable_7eb45317_86a2_4a47_8984_638282469348_.iwidth,idecimals=xmltable_7eb45317_86a2_4a47_8984_638282469348_.idecimals,ibordercolor=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ibordercolor,linputrequired=xmltable_7eb45317_86a2_4a47_8984_638282469348_.linputrequired,lallownulls=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lallownulls,lkeyfield=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lkeyfield,lupdatable=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lupdatable,mdefaultvalue=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mdefaultvalue,mcaption=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mcaption,mvalidate_onclient=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidate_onclient,mvalidate_onserver=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidate_onserver,mvalidatetext=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidatetext,mhelpcontent=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mhelpcontent,mcomment=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mcomment WHERE ikey_fld=OLDVAL('ikey_fld','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ikey_vws=OLDVAL('ikey_vws','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ikey_tlb=OLDVAL('ikey_tlb','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND cfield=OLDVAL('cfield','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND chelptitle=OLDVAL('chelptitle','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND cupdatename=OLDVAL('cupdatename','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ctype=OLDVAL('ctype','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND iwidth=OLDVAL('iwidth','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND idecimals=OLDVAL('idecimals','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ibordercolor=OLDVAL('ibordercolor','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND linputrequired=OLDVAL('linputrequired','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lallownulls=OLDVAL('lallownulls','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lkeyfield=OLDVAL('lkeyfield','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lupdatable=OLDVAL('lupdatable','xmltable_7eb45317_86a2_4a47_8984_638282469348_') Cause : Memo file c:\program files\microsoft visual foxpro 9\projects\appserver\data\tb_views.FPT is missing or is invalid.