Logic

[mikedoyle]

I have a dbase IV database with 15,000 records. Each record has a character field NEWNO. For various reasons the NEWNO entries have skipped certain entries to the NEWNO.
I am indexing on NEWNO.

I want to print those over 6000 and less than 14400, plus
those greater than 13999. I get mixed up with the logic and the .and. etc and the ( ).

Help will be appreciated.

Aloha, Mike Doyle

 

[ramani]

Hi
1. BROWSE FOR BETWEEN(NEWNO,6000,14400)
2. wHEN YOU SAY 6000 AND LESS THAN 14400.. IT INCLUDED SOME GREATER THAN 13999.. WHEN YOU AGAIN SAY ALL ABOVE 13999 .. IT MEANS.... NEWNO > 5999 .. YOU HAVE REPORTED SOMETHING WRONG HERE.

THE LOGIC IS..
BETWEEN(NEWNO,BEGINNO,ENDNO) .OR. NEWNO < SOMENUMBER OR NEWNO > SOMEOTHERNUMBER
HOPE YOU GET THIS
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[mikedoyle]

ramani, thanks:

I want to list all NEWNO over 6000, with the exception of 13400 to 13999.

I have tried: index on NEWNO order newno for NEWNO >6000.and.NEWNO<13400.and.NEWNO>13999. This is in Dbase 4

Any thoughts?

Aloha, Mike Doyle

 

[EzLogic]

list all for (newno > 6000 .and. newno < 13399) .and. newno > 14000


This should work (I am not sure abou the syntax of the list command, but the logic for the comparison I think is correct)


TeknoSDS

 

[mikedoyle]

Thanks for the logic help. I now have it working OK

Aloha, Mike Doyle

Happy Holidays