SQL SUSBTR ERROR (ORDER BY)…
ATTACH IMAGE [ATTACH=CONFIG]n64010[/ATTACH]
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