SQL SUBSTR ERROR...

SQL SUSBTR ERROR (ORDER BY)…
ATTACH IMAGE [ATTACH=CONFIG]n64010[/ATTACH]

SQL-SUBSTR-ERR.jpg

Hello,

What is the database you are using?
Could you inform the SQL used in grid application?
expr13 is an alias created by you or generated automatically by the database?

Database using = ODBC

Inform SQL = (??)

when:

[ATTACH=CONFIG]temp_2442_1450711782116_843[/ATTACH]

/----------------------/
SCRIPTCASE GENERA BAD CODE.

SELECT
PROY_DEALER,
PROY_VARIEDAD,
PROY_COSECHA,
PROY_DESCRI,
PROY_DIA_KGS_ACOPIO,
PROY_DIA_KGS_RECLA,
PROY_DIA_KGS_PROCESO,
PROY_ACUM_KGS_PROYECTADO,
PROY_ACUM_KGS_ACOPIO,
PROY_ACUM_KGS_PROCESADO,
PROY_COMPRO_KGS_SOLICITADO,
PROY_COMPRO_KGS_CTJ_PROCES,
PROY_GRADO_INT,
SUBSTR(PROY_DESCRI,1,3) as expr13
from
PUBLIC.PVTA05
order by SUBSTR(PROY_DESCRI,1,3) asc

//------------------------------------------//
ORIGINAL SQL

SELECT
PROY_COSECHA,
PROY_DEALER,
PROY_VARIEDAD,
PROY_GRADO_INT,
PROY_DESCRI,
PROY_DIA_KGS_ACOPIO,
PROY_DIA_KGS_RECLA,
PROY_DIA_KGS_PROCESO,
PROY_ACUM_KGS_PROYECTADO,
PROY_ACUM_KGS_ACOPIO,
PROY_ACUM_KGS_PROCESADO,
PROY_COMPRO_KGS_SOLICITADO,
PROY_COMPRO_KGS_CTJ_PROCES,
SUBSTR(PROY_DESCRI,1,3) AS EXPR13
FROM
PUBLIC.PVTA05

Atte.
Jose