Hi!
No. The least actions you can make when use the GenDbc tool. Generate the PRG using that tool. The PRG represents the code to re-create the structure of your database when running. Extract from it all code for indexes creating. Add code to remove indexes from all tables before new indexes take effect. Set the collation sequense, than run the indexing code.
Note that maximum index key value length is different for different collating sequenses. For MACHINE it is 240. For GENERAL it is 200. For RUSSIAN, for example, it is 120 (I assume it is minimum as because double-byte chracters used). So check also if all indexes are possible in another collating sequense.
HTH.
>I have application which indexes created with MACHINE collating sequence. Can I with one single action change collating sequence to GENERAL to all indexes.
>
>Thanks.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
