Hi there,

I am attempting to add an index on a rather large table. Normally, this wouldn't be an issue, but my customer is in Japan. Here's the history:

1) Same database structure is at other customer sites including many in the U.S., 2 in France, 1 in the U.K., a couple in Canada and 1 in Japan.
2) All databases container files (ipc.dbc, ipc.dct and ipc.dcx) are interchangeable. The tables withing the container are not.
3) Each location has the FoxPro version 7.0 database running on an NT server, with client machines running VFP 7.0 applications.
4) Maintenace on the Japanese database has always (to the best of my knowledge) been done from an English PC.

Now I need to add an index to a HUGE table. Running the indexing command from my VFP developement environment across the network to their database is not an option. But when I have someone on site run a compiled executable with the following lines in one of the programs:

USE results
INDEX ON attr TAG attr ASCENDING
USE IN results

The table is then unreadable because of some collating issue. Something to do with running the indexing from a non-western language PC (which would be english, french, german, etc.) The indexing works differently from a Japanese PC.

Since the rest of the database maintenance has always been done from an English PC, how can I get around this issue? The following suggestions have been made:

RESOURCE = OFF
Codepage=932 in config.fpw.

What else do I need to do? This is all new territory for me and any help would be greatly appreciated.

Thank you,

Joe