Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Elijah ICS
  Where is Elijah ICS?
 Mombasa
 Kenya
 Elijah ICS
 Tags
Subject: RE: filtering using dble filters..
Thread ID: 104465 Message ID: 104466 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Wednesday, August 16, 2006 8:35:43 PM         
   


> goingtothetop
>
> I have a table, master, from which i need to extract , table index
>
> Master
>
> Abbre Lotno Grdstatus wname
>
> abbre1 lotno1 main wnameI
> abbre1 lotnox main wnameII
> abbre1 lotnoy sec wnameIII
> abbre2 lotnoz main wnameX
> abbre2 lotnoa sec wnameIX
>
> index table required
>
> abbre min-max lotno(main) min-max lotno(sec) Wname(s)
>
> abbre1 lotno1-lotnox lotnoy - lotnoy wnameI, wnameII, wnameIII
> abbre2 lotnoz - lotnoz lotnoa - lotnoa wnameX, wname IX
>
> Kindly help to work it out. Its been a lovely headache.


I am not sure what you want here. Can you explain with a bit more english? It sounds as if you want to have an index that uses a filter. I don't normally recommend filtering indexes. Rushmore cannot use filtered indexes.

Ken

You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

filtering using dble filters.. Posted by Elijah Kihuga @ 8/16/2006 8:22:30 PM
RE: filtering using dble filters.. Posted by Ken Murphy @ 8/16/2006 8:35:43 PM
RE: filtering using dble filters.. Posted by Elijah Kihuga @ 8/17/2006 8:20:17 PM
RE: filtering using dble filters.. Posted by Ken Murphy @ 8/18/2006 1:43:18 PM