CL_SQL_STATEMENT - Query problems

Arthur_Silva — Thu, 29 Dec 2011 22:25:50 GMT

Hello all,

I doing some tests on SQL classes and I'm having some problems to select data from countries table. The SQL query is not working and I don't know why, please find the sql query below. I did the same sql query on mySQL and it works.

I'm trying to get the country code with texts even without the entry on T005T.

 
DATA:
result     TYPE REF TO cl_sql_result_set ,
stmt       TYPE REF TO cl_sql_statement .

*   set query
me->set_qury( qury ) .

me->result  = stmt->get_stmt( )->execute_query( me->get_qury( ) ) . 

* content of variable qury

            qury  = `SELECT land1, `  &&
                           `spras, `  &&
                    `(SELECT landx FROM T005T `  &&
                                   `WHERE spras = 'EN' `  &&
                                     `AND land1 = ? ), `  &&
                    `(SELECT natio FROM T005T `   &&
                                   `WHERE spras = 'EN' `  &&
                                     `AND land1 = ? )`  &&
                      `FROM T005 `  &&
                      `WHERE mandt = '` && sy-mandt && `' `  &&
                        `AND land1 = ? `  &&
                      `GROUP BY land1, spras` .

Best regards,

Arthur Silva

Edited by: arthurfuscella on Dec 29, 2011 11:36 PM

Re: CL_SQL_STATEMENT - Query problems

Former Member — Fri, 30 Dec 2011 05:00:07 GMT

This message was moderated.

Re: CL_SQL_STATEMENT - Query problems

Former Member — Mon, 09 Jan 2012 11:18:02 GMT

See my answer in your other thread:

Re: CL_SQL_STATEMENT - Query problems

Former Member — Mon, 09 Jan 2012 15:03:41 GMT

If your question is answered, please mark it as solved.

Rob

topic Re: CL_SQL_STATEMENT - Query problems in Application Development and Automation Discussions

CL_SQL_STATEMENT - Query problems

Re: CL_SQL_STATEMENT - Query problems

Re: CL_SQL_STATEMENT - Query problems

Re: CL_SQL_STATEMENT - Query problems