I executed the following statement against a table (.DBF), which was contained in database (.DBC). It did not appear to complete, and I had to kill VFP8 via Task Manager (WIN NT). When I got back into VFP 8, the table did not appear in database container, and the table, and index files were gone from my hard-disk. What happened? Can I recover the .DBF, .FPT, and .CDX files somehow?
Below is statement executed (stats below the SQL stmt):
INSERT INTO dd_lar (lr_accept,lr_assign,lr_wc,lr_cplx,;
lr_number,lr_entby,lr_status,lr_orig,;
lr_reason,lr_comm,lr_reascomm,lr_fy,lr_avoid,;
lr_bosresp,lr_nshpchk,lr_conddif,lr_drft,lr_guidchg,lr_intf,;
lr_lfcomm,lr_matlerr,lr_matlsub,lr_newwork,lr_repwork,;
lr_reqinfo,lr_shipchk,lr_tech,lr_irdate,lr_entdate,;
lr_moddate,lr_recdate,lr_appdate,lr_rplbydt,lr_ecd);
SELECT accept,assigned,code,cplx,larno,entby,stat,orig,reason,comments,;
rsn_cmts,fy,avoidable,boss_resp,cant_sc,cond_diff,drafting,;
guid_chg,interfer,l_f_comm,matl_error,matl_sub,new_work,;
repair_wrk,req_info,shipcheck,technical,ird,lardte,entdte,;
rcvdte,appdte,duedte,ecd ;
FROM LAR_SUM
LAR_SUM: 7,000+ records
DD_LAR: Starts w. 0 records.
DD_LAR has several indexes, one of which is Integer(Auto) field.
Fred Z - Boston MA
Don