Re: re-creating .idx file

On 27 Dec 96 at 16:06, Kevin P. wrote: > oops! i hammered an .idx file while trying to "fix" an indexing > problem with one of the tables in my system. yes, i know that it > says practically everywhere in the manuals not to do this, but i > figured if it was hosed already, what could it hurt. so, while i sit > here listening to my multiple tape backup set whir, i figured i'd > also ask the experts. The experts are all on leave, so you'll have to make do with me... Right: 1. Create a table (newtable)which is an exact duplicate of your damaged table (badtable), including all indexes. 2. Copy the newtable_xxx.idx to badtable_xxx.idx. 3. bcheck -y badtable*.dat Voila. Quicker than restoring a backup. (If it works). :-) HTH. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...