Very Computer

I'm using Paradox for DOS 4.5 and running on Netware 4.1.
Sometimes during data-entry operation (Coedit mode) in a multi-user
environment, this message "Table index is based on different index order"
appear in one particular station.

When we try it on another system, it works fine. Does anyone encounter
this problem before or know what is the problem, please give some advice.

Thank you in advance.

The "different sort order" message can mean one
of several things:

 a. that workstation really does have a different
    sort order installed

 b. somebody passed the .db from someplace else
    without passing the .px and/or indexes

 c. somebody used Edit Mode and everything got
    farkled

--
Steve Green - Diamond Software Group - Waldorf Maryland USA
CompuServe 71333.2362 - Prodigy TBMG62A -  I am a member of
Borland's TeamB Tech Support staff for PdoxDOS but I do not
represent Borland International in any official capacity.

Start Paradox at one of your known "good" stations.  At the Paradox main menu,
press Alt-F10, select "Value", then type in SORTORDER() and press Enter.
You'll see a message at the bottom-right corner of the screen, indicating the
name of the sort order.  For example, let's say the value shown is INTL.  Now,
go to the "problem" station, and do the same thing.  It should also show INTL - if not,
then the station is using a different sort order definition file (paradox.sor).

If the names are different, (let's say this station shows "ASCII") check the path
of the station that's having the problem, and look for the file paradox.sor
in any of the directories in the path.  If you find the file, use the dos command
TYPE PARADOX.SOR, and you'll see a message like:
Paradox XXXXXX Sort definition, version y.z

XXXXX is the name of the sort definition.  Most likely, it will match the name
shown at the problem station (ASCII in this example).  If it does, rename the
file to something else, then try Paradox again.

If the problem only occurs when a particular user is using that station, check
that person's private directories for paradox.sor as well.

Hope this helps!

Jim