topic Execute a SQL string in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008694#M1496313 <HTML><HEAD></HEAD><BODY><P>Define lv_sql as stext. Say lv_sql = 'select * from table1 into lt_tab where ...'</P><P>how to execute lv_sql?</P></BODY></HTML> Tue, 15 Jun 2010 20:47:55 GMT Former Member 2010-06-15T20:47:55Z Execute a SQL string https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008694#M1496313 <HTML><HEAD></HEAD><BODY><P>Define lv_sql as stext. Say lv_sql = 'select * from table1 into lt_tab where ...'</P><P>how to execute lv_sql?</P></BODY></HTML> Tue, 15 Jun 2010 20:47:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008694#M1496313 Former Member 2010-06-15T20:47:55Z Re: Execute a SQL string https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008695#M1496314 <HTML><HEAD></HEAD><BODY><P>Sounds like dynamic programming. Check the help on GENERATE SUBROUTINE POOL.</P><P></P><P>Rob</P></BODY></HTML> Tue, 15 Jun 2010 20:53:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008695#M1496314 Former Member 2010-06-15T20:53:17Z Re: Execute a SQL string https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008696#M1496315 <HTML><HEAD></HEAD><BODY><P>jacky,</P><P>break it down.. 2 3 strings..</P><P>'select' is not needed to be in the string...</P><P></P><P>direct write :</P><P>select (string1) into (string2) where (string 3)...</P><P></P><P>this line itself is executable...and how to make this!! searhc DYNAMIC SQL in SDN... you will find many wikis on this.</P></BODY></HTML> Wed, 16 Jun 2010 01:57:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008696#M1496315 Former Member 2010-06-16T01:57:37Z Re: Execute a SQL string https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008697#M1496316 <HTML><HEAD></HEAD><BODY><P>This is exactly what i was looking for. Thank you guys so much!</P></BODY></HTML> Wed, 30 Jun 2010 14:23:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-a-sql-string/m-p/7008697#M1496316 Former Member 2010-06-30T14:23:37Z