Re: SQL Variable Declare Statement

[THarteau@xxxxxxxxxxxxxxxxxx]

Hi,

>C+ order by Case When :$Sort = '1' then fld1, fld2, fld3
>C+               When :$Sort = '2'  then fld2, fld3, fld1
>C+               When :$Sort = '3'  then fld3, fld1, fld2

That looks like it might work, but mine is more complicated.  I have 3 sort
fields, each of which can be one of 5 options. I went with the prepare
statement because the when was getting complicated. $SORT had to be
compared against 5 values, and the same for $SORT2 & $SORT3.  I will file
this away for future reference, though. I can see it coming in handy.
Thanks for the help. BTW, my program compiled, but I just got headings. I
have to go in and see what happened.

<===================================================>

Terri Harteau
Felker Brothers Corporation
****************
Paperwork is like kudzu. Both need to be pruned regularly. Usually, a
flamethrower is overkill.      Usually.
****************