Kbase 16570: Temporary tables and Index sort orientation ASC DESC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Temporary tables and Index sort orientation ASC DESC
Defining Temporary tables and index sort orientation
----------------------------------------------------
Once you explicitly specify the sort
orientation of a field component (via DESC or ASC), all
following components for that index will be of the same sort
orientation unless (and until) a subsequent field component
specifies a different sort orientation (via DESC or
ASC).
For example, the following descriptions could be read as
though the code in square brackets were specified:
define temp-table foo field a as char
field b as char
field c as char
index x a desc b [desc] c [desc].
define temp-table foo field a as char
field b as char
field c as char
index x a desc b asc c [asc].
define temp-table foo field a as char
field b as char
field c as char
index x a [asc] b desc c [desc].
define temp-table foo field a as char
field b as char
field c as char
index x a desc b asc c [asc].
In other words, for any given temp-table index specification,
if a field component doesn't have a sort orientation specified
explicitly, it uses the sort orientation of the previous field
component. If none is ever specified, it defaults to ASCENDING.
NOTE: remember that this is only for Temporary tables
Progress Software Technical Support Note # 16570