Problem Compile code - Field not Find

[eduardo_dimperio]

Hi !

Im trying compile this code but i dont no why i get a error message.

ANALISE_FINAL:

LOAD

*

WHERE

    (ConsumoReal_0>0.005 OR ConsumoReal_1 >0.005 OR ConsumoReal_2>0.005)

AND (HORA0=2 AND HORA0=5);

LOAD

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    ADDRESS_BLOCK_UC,

    EXCLUDE_OID_METER,

    Sum(CONSUMODIA0)AS ConsumoReal_0,

    Sum(CONSUMODIA1)AS ConsumoReal_1,

    Sum(CONSUMODIA2)AS ConsumoReal_2,

    If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) AS CONSUMO_Noturno_DIA0,

    If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) as CONSUMO_Noturno_DIA1,

    If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0))as CONSUMO_Noturno_DIA2

RESIDENT ANALISE WHERE OID_METER <> EXCLUDE_OID_METER

GROUP BY

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    EXCLUDE_OID_METER,

    ADDRESS_BLOCK_UC,

ORDER BY OID_METER, HORA0 DESC;

I receive that error:

Ocorreram os seguintes erros:

Field not found - <ORDER>

O erro ocorreu aqui:

LOAD HORA0, ID_LEITURA, NAME_SYSTEM, NAME_GROUP, NEIGHB_SYSTEM, CITY_SYSTEM, OID_METER, NAME_TYPE_METER, NAME_UC, ADDRESS_BLOCK_UC, EXCLUDE_OID_METER, Sum(CONSUMODIA0)AS ConsumoReal_0, Sum(CONSUMODIA1)AS ConsumoReal_1, Sum(CONSUMODIA2)AS ConsumoReal_2, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) AS CONSUMO_Noturno_DIA0, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) as CONSUMO_Noturno_DIA1, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0))as CONSUMO_Noturno_DIA2 RESIDENT ANALISE WHERE OID_METER <> EXCLUDE_OID_METER GROUP BY HORA0, ID_LEITURA, NAME_SYSTEM, NAME_GROUP, NEIGHB_SYSTEM, CITY_SYSTEM, OID_METER, NAME_TYPE_METER, NAME_UC, EXCLUDE_OID_METER, ADDRESS_BLOCK_UC, ORDER BY OID_METER, HORA0 DESC

any idea why?

[MK9885 · Accepted solution]

Maybe

ADDRESS_BLOCK_UC ,

ORDER BY OID_METER, HORA0 DESC;

After ADDRESS_BLOCK_UC not use ,

Just try this...

ADDRESS_BLOCK_UC

ORDER BY OID_METER, HORA0 DESC;

[eduardo_dimperio]

Yeap, sorry for not pay atencion to this and thank you for the help