Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HELP! Problem with adding an index to a table
Message
From
06/04/2004 11:52:39
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/04/2004 11:40:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00892633
Message ID:
00892640
Views:
12
>Hi there,
>
>I'm working on a VFP 7.0 application that uses the VFP 7.0 database as the back end. The front-end application runs on Win9x operating systems as well as Win2000. Each site has multiple client workstations (5-150) and a server; the latter has the database container and tables on it. I am located in the U.S. along with most of my customer base. But one of my sites is in Japan. This past weekend, I had them run a compiled exe that contained a *.prg which added a few new fields to a couple of the tables and an additional index to another table. This exe was run from one of the Japanese clients that runs Japanese windows.
>
>The problem is with the newly indexed table: the Japanese Win9x clients were unable to access this table, but the Win2000 clients seemed to have no problem with the table.
>
>For production reasons, I had the Japanese plant revert to the older, backed-up copy of the database so they could successfully collect data. Meanwhile, prior to getting the older database in the production environment, about 700 records were saved to the new database, and I need to import these into the current production database. From the VFP 7.0 development environment on my Win2000 laptop, I'm also unable to open the re-indexed table... getting the following error: "Collating sequence 'JAPANESE' is not found." I discovered some information on CODE PAGE and SYS(2300) and SET COLLATE command, but no matter how I have my environment set, I still can't access that re-indexed table.
>
>I have two questions:
>
>1) How can I access the table with the new index, and
>2) How can I successfully index the table in the future in order to avoid repeating this scenario? Do I need to do this from my development environment, or can it be done from a Japanese client?
>
>Any and all suggestions are welcome!
>
>Joe

Joe,
Have you tried with :
Codepage=932
in config.fpw.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform