Re: SQL: Inconsistent "order by"

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Then why doesn't it tell us that via SQLSTT?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Carel Teijgeler" <coteijgeler@chello.nl>
Sent by: midrange-l-admin@midrange.com
11/01/2002 02:18 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: SQL:  Inconsistent "order by"


Rob,

I do not think you can use parameter markers on the ORDER BY clause. You
can only use it in the WHERE clause.

Try something like:

  SqlStmt='Select ccust, cnme, cad1, cad2, cste, czip ' +
               'From rcm ' +
               'Order by' + %char(Parm1);

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 1-11-02 at 13:33 rob@dekko.com wrote:

>When I do an "order by" I do not get consistent results with imbedded SQL
>(CRTRPGSQLI).  Yet it works with STRSQL
>
>For example when I do the following with STRSQL it sorts by the specified
>column number:
>SELECT CMID, CCUST, CNME
>FROM DHTDIVF/RCM
>ORDER BY 3
>



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.