Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xcollate()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XCOLLATE()
Specifies user-define collating sequence

Syntax
N_XCOLLATE([<cCollatingSequence>])

Argument
<cCollatingSequence> is a 265 byte string defining an "alternate collating 
sequence" (ACS) to translate lower case letters to upper case letters.  The 
string can have one of two formats shown below.  Any deviation will have 
unpredictable results.

1.   CHR(172)+'UPPER'+SPACE(3), followed by 256 bytes containing the 
     uppercase replacement for each of the ASCII values 0 through 255.

2.   CHR(173) followed by two-byte Country ID followed by two-byte Code Page 
     ID followed by SPACE(260).  Only Btrieve 6.x allows this format.

Returns
Current ACS as a 265-byte string.

Remarks
The default collating sequence is the standard English translation of 'a-z' 
to 'A-Z'.  It is not necessary to use this function unless you need to 
change it.

This function affects only Btrieve files created by RaSQL/B.  It has no 
effect on already existing files.
See COLLATE.CH for several alternative definitions.

Example
prior = N_XCOLLATE(ACS_GERMAN)
N_XAMAKETBL(...)   // create new table


See Also: N_XAMAKETBL() N_XMAKETBL()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson