Fetching DAta against Max Date from table

Former Member — Wed, 09 Jul 2008 10:06:11 GMT

Dear All,

I have to fetch data against maximum date from table. i have tried this one but getting error :

EXEC SQL.

*IT_OUT-PR_APPRVD

SELECT single UDATE

INTO MAX_DATE

FROM CDHDR

WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = IT_OUT-PR_NO

AND CHANGENR = IT_OUT-CHANGENR1

AND TCODE LIKE 'ME%'

AND UDATE = (SELECT MAX(UDATE) FROM CDHDR WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = IT_OUT-PR_NO

AND CHANGENR = IT_OUT-CHANGENR1

AND TCODE LIKE 'ME%') .

ENDEXEC.

Plz suggest syntax for that.

Looking forward to your earliest response.

with Regards,

Gulrez Alam

Re: Fetching DAta against Max Date from table

Former Member — Wed, 09 Jul 2008 10:29:02 GMT

write this :

Look at the bold ones ... U need to put : against the field

MAX_DATE ..

EXEC SQL.

SELECT UDATE INTO :MAX_DATE

FROM CDHDR

WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = '0'

AND CHANGENR = '1'

AND TCODE LIKE 'ME%'

AND UDATE = (SELECT MAX(UDATE) FROM CDHDR WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = '1'

AND CHANGENR = '1'

AND TCODE LIKE 'ME%'.) .

ENDEXEC.