Solved: SELECT COUNT( ) gives warning in ECC6.0.

Former Member · ‎2007 Jul 27

Hi,

The following query is giving syntax error in ECC6.0, where as it worked absolutely fine in 3.1i server.

SELECT COUNT( OBOX_CNTNO ) FROM ZT2OB

INTO W_COUNT

WHERE SUPPL_CD = W_SUPPL_CD

AND INVC_NO = W_INVC_NO

AND INVC_LN_NO = T_SCR_ITEMS-INVC_LN_NO.

Error: "COUNT( OBOX_CNTNO )" is only valid in the extended form "COUNT( DIS

OBOX_CNTNO )" . . .

The query seems obsolete in ECC6.0. Can anybody help me to give valid query for this in ECC6.0?

Former Member · ‎2007 Jul 27

Hi,

Count functionality is to be used along with Distinct functionality.

COUNT( DISTINCT col )

Reward points if this helps,

Kiran

Former Member · ‎2007 Jul 27

The eroor is : "COUNT( OBOX_CNTNO )" is only valid in the extended form "COUNT( DISTINCT OBOX_CNTNO )" . . .

Former Member · ‎2007 Jul 27

Hi,

Count functionality is to be used along with Distinct functionality.

COUNT( DISTINCT col )

Reward points if this helps,

Kiran

SELECT COUNT( ) gives warning in ECC6.0.