Jeff Johnson wrote on 2011-09-06: > Tracy: I use .idx files for this kind of stuff. Have you considered those? > > Jeff > > --------------- > > Jeff Johnson
Jeff, I considered them at the beginning of that project. I discovered some bits require multi-fields and most times I'll be creating more than one index. Since it is not always guaranteed to be a temporary cursor, letting VFP handle the cleanup is also removed as an option. This particular process is a lookup grid. Multiple columns can be sorted and allow an incremental search to take place. An example of a complex index used (actually frequently) PADR(ALLTRIM(LASTNAME)+SPACE(1)+ALLTRIM(FIRSTNAME),60). When the user clicks on the First Name column header, a new index is added to the CDX. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: ProFox@leafe.com 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/000901cc6cba$002121f0$006365d0$@powerchurch.com ** 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.
