topic Re: Possible to do dynamic SQL statement? in Application Development and Automation Discussions

Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 00:30:26 GMT

Hi,

I have a dialog screen with an inputfield. The developer will key in SQL statement into this inputfield and the SQL statement will store in the database. When the developer click on execute button. The program will retrieve the SQL statement from the database and perform the SQL statement and retrieve the data.

Is it possible to do that? What are the things that i need to look into?

Regards,

Rayden

Re: Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 00:33:59 GMT

Hi Rayden,

I don't think it is possible. You may need to look at some other alternative.

Regards,

Atish

Re: Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 01:11:51 GMT

Hi,

Yes it is posible.

I made one program like you want. But it need very long code.

Here I explain the idea:


1. Create Screen with input TEXT EDIT CONTROL.
    This is for input SQL Statement.
2. Get SQL Statement from Text Edit Control using method <b>get_text_as_r3table</b>.
3. Now we need to separate SQL Statement into different table. 
    We Separate SELECT, FROM, WHERE, GROUP, HAVING, ORDER, etc.
4. We need dynamic internal table to store the data.
5. Select the data according SQL statement.
      SELECT (IT_SELECT)
        into corresponding fields of table  <dyn_table>
      FROM (IT_FROM)
      WHERE (IT_WHERE)
      GROUP BY (IT_GROUP)
      HAVING (IT_HAVING)
      ORDER BY (IT_ORDER).
6. Display our data using ALV GRID

Hopefully it will help you.

Regards,

Re: Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 02:23:52 GMT

Hi Jatra,

That was great. Do you have any sample code to share?

Regards,

Rayden

Re: Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 02:38:46 GMT

Hi,

I am preparing my code. When it ready i will upload it.

Regards,

Re: Possible to do dynamic SQL statement?

Former Member — Wed, 17 Oct 2007 02:47:31 GMT

Hi Jatra,

Great. Looking forward for the sample.

Thanks

Regards,

Rayden