Don (or is it Fred),
First, I guess this might constitute an example of why VFP8 is NOT supported on NT. We may never learn the cause of this problem.
If I understand coreectly it was the .DBC containing dd_lar that disappeared, along with the table itself and its supporting files and the input remained intact. Correct?
Is there something that might be preventing an error message from being displayed (maybe there's a problem with the SELECT statement but that fact is being hidden for some reason)?
I've periodically read that ensuring that there is a blank separating continuation semi-colons from code can 'fix' an 'erroneous' SQL statement. Worth a shot.
Finally, it might be worth trying to put in some WHERE clause in the SELECT.
That the .dbc and its tables/files disappears surely is mysterious and worrisome but as I say, it may have something to do with NT rather than VFP. Who knows.
good luck
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only