Most recent edit on 2007-07-06 22:22:19 by NorbertGutscher [changes of a troll killed]
Additions:
on the data file using Ctrl+G in the Tables Repository.
In the new program's Task Properties dialog (Ctrl+P), change
In the program's DB Tables Repository (Ctrl+D), change
Deletions:
on the data file using Ctrl G in the Tables Repository.
In the new program's Task Properties dialog (Ctrl P), change
In the program's DB Tables Repository (Ctrl D), change
Edited on 2007-07-05 13:27:46 by XjwUnx
Additions:
on the data file using Ctrl G in the Tables Repository.
In the new program's Task Properties dialog (Ctrl P), change
In the program's DB Tables Repository (Ctrl D), change
Deletions:
on the data file using Ctrl+G in the Tables Repository.
In the new program's Task Properties dialog (Ctrl+P), change
In the program's DB Tables Repository (Ctrl+D), change
Edited on 2006-06-21 21:41:08 by GroupsMBM
Additions:
The problem is that mggenw is (inadvertently) using ACS in the "snapshot" file that is part of the MVCS process. The really frustrating thing is that everything will work for a period of time, and then all of the sudden magic will start doing the "hard crash" routine.
Additional info on Magic ACS
Magic will only include the ACS definition within a PVSW file if there is at least one key segment which is type Alpha. Also note that ONLY those Alpha fields which are used as key segments will have the ACS assigned.
If you need other Alpha fields (which are not used in any key) to be defined as using the ACS, you can make these changes in the PVSW Control Center.
Now this ACS is "active" and Magic will automatically create any new
Deletions:
The problem is that mggenw is (inadvertently) using ACS in the "snapshot" file that is part of the MVCS process.
Now this ACS is "active" and Magic will automatically create any new
Edited on 2006-04-19 05:23:30 by GroupsMBM [Added warning re; ACS & MVCS]
Additions:
Special Note! ANOTHER WORD OF WARNING!
As of 4/18/2006, ACS and MVCS are not compatable in eDeveloper 9.4.
The problem is that mggenw is (inadvertently) using ACS in the "snapshot" file that is part of the MVCS process.
Make sure that none of the lines wrap -- your file needs to contain exactly seventeen lines as shown above. Save this file with the name NO_CASE.ACS and place it in your Magic installation directory's SUPPORT folder.
Deletions:
Make sure that none of the lines wrap -- your file needs to contain
exactly seventeen lines as shown above. Save this file with the name
NO_CASE.ACS and place it in your Magic installation directory's SUPPORT folder.
Edited on 2006-03-07 14:13:56 by GroupsMBM ["code-formated" the acs table]
Additions:
Edited on 2006-03-06 17:52:30 by BlanStev
Additions:
Alternate Collating Sequence (ACS) File
Deletions:
Alternate Collating Sequence (ACS) File
Edited on 2006-03-06 17:52:06 by BlanStev
Additions:
A word of warning - not only does this cause upper and lower case letters to be sorted alike, but also causes them to be treated as the same letter for purposes of uniqueness in an index. For example, "BOB", "Bob" and "bob" are normally different strings but, when using the referenced ACS, are considered the same string in an index. This change is not user-selectable; i.e., to revert to the normal collating sequence, all the files must be rebuilt again without the ACS file reference in Settings, Environment.
Deletions:
A word of warning - not only does this cause upper and lower case letters to be sorted alike, but also causes them to be treated as the same letter for purposes of uniqueness in an index. For example, "BOB", "Bob" and "bob" are normally different strings but, when using the referenced ACS, are considered the same string in an index. This change is not user-selectable; i.e., to revert to the normal collating sequence, all the files must be rebuilt.
Please edit this page...
Edited on 2006-03-06 16:54:50 by ArchLineberger
Additions:
CategoryHowTo
Make Pervasive Case-insensitive
A word of warning - not only does this cause upper and lower case letters to be sorted alike, but also causes them to be treated as the same letter for purposes of uniqueness in an index. For example, "BOB", "Bob" and "bob" are normally different strings but, when using the referenced ACS, are considered the same string in an index. This change is not user-selectable; i.e., to revert to the normal collating sequence, all the files must be rebuilt.
NOTE: This WIKI was compiled from Steve Blank's excellent User Group responses.
Index
Construct a new ACS file
Change Magic's Defeault
Update Existing Files
Please edit this page...
Alternate Collating Sequence (ACS) File
NO_CASE.ACS and place it in your Magic installation directory's SUPPORT folder.
Change Magic's ACS File
Update Existing Files
on the data file using Ctrl+G in the Tables Repository.
In the new program's Task Properties dialog (Ctrl+P), change
- Task Type: Batch
- End Task Condition: Yes
- Evaluate Condition: Before
In the program's DB Tables Repository (Ctrl+D), change
- Share: None
- Open: Reindex
Deletions:
A word of warning - not only does this cause upper and lower case letters to be sorted alike, but also causes them to be treated as the same letter for purposes of uniqueness in an index. For example, "BOB", "Bob" and "bob" are normally different strings but, when using the referenced ACS, are considered the same string in an index.
NO_CASE.ACS and place this file in your Magic folder's SUPPORT folder.
on the data file using Ctrl+G in the Tables Repository. In the new
program's Task Properties dialog (Ctrl+P), change Task Type: Batch,
End Task Condition: Yes, Evaluate Condition: Before. In the program's
DB Tables Repository (Ctrl+D), change Share: None and Open: Reindex.
Oldest known version of this page was edited on 2006-03-06 16:21:17 by ArchLineberger []
Page view:
A word of warning - not only does this cause upper and lower case letters to be sorted alike, but also causes them to be treated as the same letter for purposes of uniqueness in an index. For example, "BOB", "Bob" and "bob" are normally different strings but, when using the referenced ACS, are considered the same string in an index.
First, copy and paste the following seventeen (17) lines into a new,
simple text file:
NO_CASE
0x00,0x01,0x02,0x03,0x04,0x05,0x06,0x07,0x08,0x09,0x0A,0x0B,0x0C,0x0D,0x0E,0x0F
0x10,0x11,0x12,0x13,0x14,0x15,0x16,0x17,0x18,0x19,0x1A,0x1B,0x1C,0x1D,0x1E,0x1F
0x20,0x21,0x22,0x23,0x24,0x25,0x26,0x27,0x28,0x29,0x2A,0x2B,0x2C,0x2D,0x2E,0x2F
0x30,0x31,0x32,0x33,0x34,0x35,0x36,0x37,0x38,0x39,0x3A,0x3B,0x3C,0x3D,0x3E,0x3F
0x40,0x41,0x42,0x43,0x44,0x45,0x46,0x47,0x48,0x49,0x4A,0x4B,0x4C,0x4D,0x4E,0x4F
0x50,0x51,0x52,0x53,0x54,0x55,0x56,0x57,0x58,0x59,0x5A,0x5B,0x5C,0x5D,0x5E,0x5F
0x60,0x41,0x42,0x43,0x44,0x45,0x46,0x47,0x48,0x49,0x4A,0x4B,0x4C,0x4D,0x4E,0x4F
0x50,0x51,0x52,0x53,0x54,0x55,0x56,0x57,0x58,0x59,0x5A,0x7B,0x7C,0x7D,0x7E,0x7F
0x80,0x81,0x82,0x83,0x84,0x85,0x86,0x87,0x88,0x89,0x8A,0x8B,0x8C,0x8D,0x8E,0x8F
0x90,0x91,0x92,0x93,0x94,0x95,0x96,0x97,0x98,0x99,0x9A,0x9B,0x9C,0x9D,0x9E,0x9F
0xA0,0xA1,0xA2,0xA3,0xA4,0xA5,0xA6,0xA7,0xA8,0xA9,0xAA,0xAB,0xAC,0xAD,0xAE,0xAF
0xB0,0xB1,0xB2,0xB3,0xB4,0xB5,0xB6,0xB7,0xB8,0xB9,0xBA,0xBB,0xBC,0xBD,0xBE,0xBF
0xC0,0xC1,0xC2,0xC3,0xC4,0xC5,0xC6,0xC7,0xC8,0xC9,0xCA,0xCB,0xCC,0xCD,0xCE,0xCF
0xD0,0xD1,0xD2,0xD3,0xD4,0xD5,0xD6,0xD7,0xD8,0xD9,0xDA,0xDB,0xDC,0xDD,0xDE,0xDF
0xE0,0xE1,0xE2,0xE3,0xE4,0xE5,0xE6,0xE7,0xE8,0xE9,0xEA,0xEB,0xEC,0xED,0xEE,0xEF
0xF0,0xF1,0xF2,0xF3,0xF4,0xF5,0xF6,0xF7,0xF8,0xF9,0xFA,0xFB,0xFC,0xFD,0xFE,0xFF
Make sure that none of the lines wrap -- your file needs to contain
exactly seventeen lines as shown above. Save this file with the name
NO_CASE.ACS and place this file in your Magic folder's SUPPORT folder.
Next, in Magic, Settings, Environment on the External tab, enter the
following on line 14, Alternate collating seq file:
SUPPORT\NO_CASE.ACS
Restart Magic.
Now this ACS is "active" and Magic will automatically create any new
data files using this ACS. However, you must perform an additional
step in order to add this ACS to any existing data files.
To add this ACS to an existing data file, generate a "Browse" program
on the data file using Ctrl+G in the Tables Repository. In the new
program's Task Properties dialog (Ctrl+P), change Task Type: Batch,
End Task Condition: Yes, Evaluate Condition: Before. In the program's
DB Tables Repository (Ctrl+D), change Share: None and Open: Reindex.
Save the changes to the program and then execute the program once.
Be aware that, if the data file is very large, the reindex process may
take a long time. BE PATIENT! DO NOT INTERRUPT THIS PROCESS.
You only need to perform this last step for an existing data file if
that file contains at least one index segment on an Alpha field.
