Dbase IV index help needed [Archive]

View Full Version : Dbase IV index help needed

daveimme

01-03-03, 16:22

Hey....I'm an old school programmer...programming with dbase IV 2.0 dosbased and on our system (which is on its way out - Oracle coming in). I need a little help.

I need to index a file on three fields (which I do all the time), but I need to index them in descending order. I've never fooled with MDX files, just dbf's and Ndx's........can someone give me a syntax line that will put this in descending order? Here is an example of what I did.....someone can add to it so it can be in descending order

Use <file>
Index on <nbr1>+<nbr2>+<nbr3> to <indexfile>
use <file> index <indexfile>

This will put it in ascending order.....how do I make it descending??

I'm kinda in a hurry, too....

Thanks...

daveimme

01-06-03, 10:45

Anybody???

ajit

01-06-03, 17:49

Try putting desc at the end of the fields.

index on field1 desc to index1 or
index on field1 to index1 desc

daveimme

01-06-03, 18:05

Nope....I tried that and it does not work.

I scraped up a dbase 4 language reference book a few mins ago and so tomorrow will take a look at that and see.

I think if I create an MDX file, I can do this.....however, I have never created or worked with an .mdx file, so I'm not sure what I have to do.

Dan Jesty

01-23-05, 11:22

Try this:

INDEX ON FIELD+FIELD TAG NAME OF DATABASE DESC