On 2/9/10 6:09 AM, Stephen Russell wrote: > On Mon, Feb 8, 2010 at 9:07 PM, Sytze de Boer<[email protected]> wrote: >> Can anyone suggest how this could end up in error 8, No table is open in the >> current work area >> >> IF FILE("POSTCODE.DBF") >> WAIT WINDOW NOWAIT 'Reindexing postal codes' >> Select 0 >> Use postcode Exclusive >> IF FILE('POSTCODE.CDX') >> Delete Tag All Of postcode >> endif >> Index On Upper(town) Tag postc1 >> Index On Upper(street) +Upper(town) Tag postc2 For !Empty(street) >> Index On Upper(town) +ruraldel Tag postc3 For !Empty(ruraldel) >> Index On Upper(town) +Str(pobox1)+Str(pobox2) Tag postc4 For >> !Empty(boxdisp) >> Index On Code Tag postc5 >> Use >> ENDIF > ----------------------- > > Are there any stats that give you info on the USAGE of your indexes? > I would consider them reset at a reindex process.
I disagree. I think that excessive trips to Burger King and McDonalds contribute greatly to global warming. ;) Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
