topic Dynamic where condition - Problem in Application Development and Automation Discussions

Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 18:56:02 GMT

Hi All,

I have a problem in a select statement where I use a dynamic condition.It gives me a dump

SAPSQL_WHERE_PARENTHESES

CX_SY_DYNAMIC_OSQL_SYNTAX.

Please find the below code which I implemented.

*SELECT * FROM ZXR5*

WHERE (SOURCE).

The value of SOURCE is 'MATNR EQ '000000000000200066'.

When I checked the help, it is advised to use a CATCH exception which I did as below:

TRY.

*SELECT * FROM ZXR5*

WHERE (SOURCE).

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Wrong WHERE condition!` TYPE 'I'.

ENDTRY.

Now, the select statement gives an exception and is not executing to fetch the values.

I need some input on the above issue. Any help on this would be greatly appreciated.

Regards,

Rajmohamed.M

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 18:59:33 GMT

try changing it to MATNR = '000000000000200066'

Thanks,

SKJ

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:05:18 GMT

TRY.

 SELECT * FROM ZXR5
 INTO  table <FS_TAB>
WHERE (SOURCE).
CATCH cx_sy_dynamic_osql_error.
"when there is error then it will give a message 

MESSAGE `Wrong WHERE condition!` TYPE 'I'.

ENDTRY.

if the dynamic select fails then we need to catch the exception otherwise run time error will occur

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:09:08 GMT

Populate source table in this way:

concatenate 'MATNR EQ' ''000000000000200066'' into SOURCE

separated by space in character mode.

Regards,

Joy.

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:10:35 GMT

Hi,

The problem is with the Dynamic Condition and the SOURCE is a table not a structure. So sometimes the values will be like this

source-line[1] : MATNR = '000000000000200066' AND

source-line[2] : OBJKEY = '12345'.

For the above conditions also, it gives me a dump.

Regards,

Raj

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:16:39 GMT

Hi Vijay,

I tried the same and all the time, the select statement gives me an exception and wont proceed.

TRY.

SELECT * FROM ZXR5

INTO TABLE <L_ZXR5>

WHERE (SOURCE).

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Wrong WHERE condition!` TYPE 'I'.

ENDTRY.

Regards,

Raj

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:21:19 GMT

Populate ur table in this way and check

source-line[1] : MATNR = '000000000000200066'

source-line[2] : AND

source-line[3] : OBJKEY = '12345'

Regards,

Joy.

Re: Dynamic where condition - Problem

Former Member — Wed, 30 Jul 2008 19:25:35 GMT

source can define as string.

EPORT  YDYN_C.

data: source type string.

data: it_flight type sflight_tab1.

data: p_carrid type sflight-carrid.
p_carrid = 'AA'.  <=== in your case define a variable and assign the material value to it
source = 'CARRID EQ P_CARRID' .
select * from
sflight
into table it_flight
where (source).

if sy-subrc eq 0.

endif.

Regards

Vijay Babu Dudla

Re: Dynamic where condition - Problem

Former Member — Thu, 31 Jul 2008 18:40:51 GMT

Hi all,

Thanks for the reply.I found out the answer for the issue.

When you pass the dynamic condition, it is better to put in Paranthesis i.e instead of MATNR EQ 000000000200066 , you can put (MATNR EQ 000000000200066 ) which solved my problem.

Regards,

Raj

Re: Dynamic where condition - Problem

Former Member — Thu, 31 Jul 2008 19:02:45 GMT

Please close your thread as being answered if you have solved the problem. Thanks.

Re: Dynamic where condition - Problem

Former Member — Thu, 31 Jul 2008 20:11:23 GMT

Hi Mike,

I made the posting answered But how Can I close the post.

Regards,

Raj.

Re: Dynamic where condition - Problem

Former Member — Thu, 31 Jul 2008 20:36:30 GMT

Marking it as answered closes it.

Rob

Re: Dynamic where condition - Problem

Former Member — Thu, 31 Jul 2008 20:52:38 GMT

I see the thread is marked as Answered now. Thanks.