Re: ** Standard Engine disaster, please help !! **

In article <19961204232400.SAA11546@ladder01.news.aol.com>, mychmose@aol.com wrote: >SE v2.03 > >Hi all, I have a .dat file without a .idx ( it was deleted by accident ). > >I now can no longer select data from the table. Is there any solution to >this problem? > > This should be worth a try. Step 1. Create another table, say junk, within the same database. junk must have an IDENTICAL structure to the table with the deleted idx. You will find a dat and idx file created. Step 2. copy/rename the junk table's idx file to the idx deleted. e.g cp junk___123.idx deleted105.idx (N.B the idx file's prefix will be identical to that of its dat) Step 3. Run a 'bcheck -s' on the original table. e.g bcheck -s deleted105 That's it! ---------------------- Rudy Fernandes GIC, KUWAIT ----------------------