Main Board > Language

** DISEGARD ** -> Mixed Case in Keys

<< < (2/2)

Jeffrey Ferreira:
Hi Jane,

That is really interesting:

"if a key segment is defined as uppercase, for example, you can use a mixed case key value when reading by key and it will still find it"

Thank you.  I will chat with some folks at our office.

jeff

Mike King:
As a follow up ---  When we store records on a keyed file the system builds a table of keys with pointers to the actual record.  The key table consists of the key field(s) extracted from the record data, so when you declare that a key is Uppercase (or Lowercase / Accented) the actual key value stored in the table is converted but not value in the record itself. 

This holds true for numeric fields where we extract the numeric value from the record and convert it into an internal representation such that the lowest negative numbers occur first followed by zero and then the positive numbers.

Navigation

[0] Message Index

[*] Previous page