Execute a SQL string

[Former Member]

Define lv_sql as stext. Say lv_sql = 'select * from table1 into lt_tab where ...'

how to execute lv_sql?

[Former Member]

Define lv_sql as stext. Say lv_sql = 'select * from table1 into lt_tab where ...'

how to execute lv_sql?

[Former Member]

Sounds like dynamic programming. Check the help on GENERATE SUBROUTINE POOL.

Rob

[Former Member]

jacky,

break it down.. 2 3 strings..

'select' is not needed to be in the string...

direct write :

select (string1) into (string2) where (string 3)...

this line itself is executable...and how to make this!! searhc DYNAMIC SQL in SDN... you will find many wikis on this.

[Former Member]

This is exactly what i was looking for. Thank you guys so much!