Re: SQL: Inconsistent "order by"

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

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
>