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 read the above code and question the value received verses the diskspace consumed as well as the bandwidth required to pull the index in for use. This is purely a Rushmore optimization issue as I see it. The index is brought down first to determine what parts of the table it needs or so that is what people have stated here right? If that is true why would you oversaturate that precious file with all of these String Combinations and fail to contain a key that would be used in a relationship or a join? Or am I looking at 3rd normal data and postc1 is a key to the towns table? I doubt it because you wouldn't need a Upper() involved. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
