Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Collating Sequence turn off |
Author |
Message |
|
Posted : 2007-08-02 08:52:31 |
Hi,
How to turn off the collating sequence in dataflex file. The below is the content from collate.cfg
// // Standard DataFlex Collate Table //
// Control Characters RANGE 0 31
// Special Characters RANGE 32 47 RANGE 58 63 RANGE 91 96 RANGE 123 255
// Number RANGE 48 57
// Alpha Characters TEXT "@AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz"
// Finished.
Thanks / jambai
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-02 09:11:28 |
Sorry the collating sequence is used by the embedded DataFlex DBMS to sort the sequence in the native indexes. Switching it off would be a disaster. If you want a different sort sequence you should modify Collate.cfg itself and reindex the tables. |
|
|
|
|
Posted : 2007-08-02 09:32:06 |
Can you tell me how to modify sort sequence for a table.
Assuming that the records in my table are in the order of 1,2,3,4,5,6..9,10. I am deleting 2,3 records, when I am inserting new records my record number goes to 2,3 only. I want my recordnumber to be as 11,12..like that.
Let me know how to acheive this by doing changes in the collate.cfg.
jambai
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-02 11:30:08 |
This has nothing to do with the Collate sequence. For the table concerned, you need to switch off (uncheck) the "Reuse Deleted Records" option using DFFile or Database Builder depending on the version of DataFlex you have.
|
|
|
|
|