topic Re: Dynamic SQL with var range in Application Development and Automation Discussions

Dynamic SQL with var range

Former Member — Fri, 22 Feb 2008 13:15:20 GMT

I have dynamic sql:

CONCATENATE 'datum <= ''' datumOP '''' INTO whereLine.

APPEND whereLine TO iwhereSQL.

select * from table WHERE (iwhereSQL)

but when I change it to:

CONCATENATE 'datum IN ''' datumRG '''' INTO whereLine.

APPEND whereLine TO iwhereSQL.

then this don't work, it isn't correct.

How to define dynamic SQL with range field?

Former Member — Fri, 22 Feb 2008 13:20:46 GMT

Hi Kosmo,

use following code.

select-options: datumRG for sy-datum.

CONCATENATE 'datum IN ' 'datumRG ' INTO whereLine separated by space.

Regards,

Yellappa.

Edited by: yellappa m on Feb 22, 2008 6:56 PM

Former Member — Fri, 22 Feb 2008 13:30:57 GMT

It isn't too simple

Your code give effect "datum IN ' IEQ2008022200000000 '"

It's not work

Former Member — Fri, 22 Feb 2008 14:03:44 GMT

Then you have to deal with every cases included within the select-option : EQ, but also BT, NE, GT, etc.

Loop at your select option and do some transalation with a Case/When.

N.H.