Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Walker, LA
    Posts
    7

    Unanswered: Dbase IV index help needed

    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...

  2. #2
    Join Date
    Jan 2003
    Location
    Walker, LA
    Posts
    7
    Anybody???

  3. #3
    Join Date
    Jan 2003
    Posts
    1
    Try putting desc at the end of the fields.

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

  4. #4
    Join Date
    Jan 2003
    Location
    Walker, LA
    Posts
    7
    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.
    Last edited by daveimme; 01-06-03 at 19:30.

  5. #5
    Join Date
    Jan 2005
    Posts
    2

    Index

    Try this:

    INDEX ON FIELD+FIELD TAG NAME OF DATABASE DESC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •