SQL SUBSTR ERROR...

Scriptcase 8 Bugs
#1

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

SQL-SUBSTR-ERR.jpg

#2

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?

#3

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