Subject | Change ORDER changer to desc in OnPrepareSQL |
---|---|
Author | G. Nau |
Post date | 2005-02-10T00:00:31Z |
I use OnPrepareSQL to modify the sqlwhereitems as descibed in the
Online help. That's working good.
But how do I invert the given order on the defined oderitems, which
contains concatenated fields (for example custumername+PK)?
example:defined in OrderItems "customername=name,ref"
normal ascending mode is resulting in : ... ORDER by name,ref
wanted additional descending mode: ... ORDER by name desc, ref
desc
An idea is of course to add additional oderitems, but maybe there is
another way to do so?
Regards
Gunther
Online help. That's working good.
But how do I invert the given order on the defined oderitems, which
contains concatenated fields (for example custumername+PK)?
example:defined in OrderItems "customername=name,ref"
normal ascending mode is resulting in : ... ORDER by name,ref
wanted additional descending mode: ... ORDER by name desc, ref
desc
An idea is of course to add additional oderitems, but maybe there is
another way to do so?
Regards
Gunther