>>in my example I have a dbf fields office,bpac,method & others where as there are 6 or so different values for office repeatedly. After I set the filter & index and browse, NO RECORDs show! As below
>>
>>mbpac='691999'
>>use e:dbf
>>set filt to 'CR_C' $ method .and. mbpac= allt(bpac)
>>brow fiel method,bpac,office *ok so far
>>inde on office to e:z uniq
>>brow fiel method,bpac,office * no records show!
>>Sounds crazy?
>
>Timothy, save yourself a bunch of confusion and just use SQL to get these records.
>
>SELE dbf
>INDEX ON Office TAG Office
>SELE * FROM dbf ;
>WHERE "CR_C"$method AND mbPac = ALLTRIM(bpac) ;
>GROUP BY Office ;
>INTO CURSOR Whatever
>
>BTW, if DBF is really the name of your table, I highly recommend changing it to something that is not a keyword.
no, dbf is just my example name. Sounds like a lot more statments are needed using sql eh? Also another file needs to be created to get the job done too. I have not used sql cmds up to this point.
-TB
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."