Naming conventions
When naming Lookups, do not rely on subtle differences in the naming to dictate the sort order of the Lookups. Differences in the sorting schemes employed by the database and the .Net framework can result in non-desirable functionality in Optiva.
As a theoretical example, this should be avoided:
'FORMULALOOK1$'
versus
'FORMULALOOK1A'
. In this example, the sort is relying on
subtle interpretations of how to sort
'$'
and
'A'
. It is better to use
'FORMULALOOK01'
and
'FORMULALOOK02'
.