topic Re: Dynamic SQl results in DUMP in Application Development and Automation Discussions

Dynamic SQl results in DUMP

Former Member — Thu, 19 Feb 2009 12:31:24 GMT

Does someone see what is wrong in my dynamic SQL statement is reuslts in a dump!

DUMP and CODE below!

Runtime error SAPSQL_WHERE_MISSING_VALUE

Except. CX_SY_DYNAMIC_OSQL_SYNTAX

Datum en tijd 19.02.2009 13:30:13

Korte tekst

A comparison value is missing in a condition specified dynamically.

Wat is er gebeurd?

Error in the ABAP Application Program

The current ABAP program "!PR_RVVEEN_USED_FIELDS" had to be terminated because

it has

come across a statement that unfortunately cannot be executed.

Foutenanalyse

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SYNTAX', was not

caught and

therefore caused a runtime error.

The reason for the exception is:

The current ABAP program has tried to execute an Open SQL statement

in which a condition was (partially) specified dynamically. In the

part specified at runtime, the program expects to find a literal as

the comparison value.

===============================================

itable = 'pa0001'

CALL FUNCTION 'DD_NAMETAB_TO_DDFIELDS'

EXPORTING

tabname = iname

TABLES

ddfields = ddfields.

LOOP AT ddfields.

data: where_tab(30) occurs 1 with header line,

where_clause(30) type c.

concatenate ddfields-fieldname '<> " "' into where_clause SEPARATED BY space.

append where_clause to where_tab.

select pernr from (itable) into table lt_pernr where (where_tab).

if sy-subrc = 0.

write 'FIELD COTAINS A VALUE'.

endif.

ENDLOOP.

Re: Dynamic SQl results in DUMP

Former Member — Thu, 19 Feb 2009 12:32:36 GMT

The dump is because of a error in the where clause!

Re: Dynamic SQl results in DUMP

Former Member — Thu, 19 Feb 2009 12:34:22 GMT

while debugging check the values in where_tab and itable

Re: Dynamic SQl results in DUMP

former_member222860 — Thu, 19 Feb 2009 12:37:47 GMT

Hi,

Concatenate operator also in where-clause, like this

concatenate ddfields-fieldname ' = ' ' " "' into where_clause SEPARATED BY space.

thanks\

Mahesh

Re: Dynamic SQl results in DUMP

Sm1tje — Thu, 19 Feb 2009 12:38:37 GMT

When I look at the coding. I'm missing the rest of the WHERE clause

In the where_tab I can't find any operator like 'EQ' or 'NE'.

1. try to catch the exception using TRY -- ENDTRY and retrieve the error message.

2. In debugging, before SELECT, check the contents of the where_tab. It should look like a 'normal select' , something like this WHERE fielda = 10.

Re: Dynamic SQl results in DUMP

Former Member — Thu, 19 Feb 2009 12:42:53 GMT

Already tried this

concatenate ddfields-fieldname 'NE space' into where_clause SEPARATED BY space.

append where_clause to where_tab.

select pernr from (itable) into table lt_pernr where (where_tab).

this work for Characterfields but not for no character fields.

Re: Dynamic SQl results in DUMP

Sm1tje — Thu, 19 Feb 2009 12:57:35 GMT

I'm also missing a dot ('.') at the end of the line. Command should always end with a point.

For numeric characters you can use '0000' (depending on number of characters).

BTW. you are creating the dynamic where clause within the loop, without clearing (initializing ) anything. This will lead to the next problem.

Edited by: Micky Oestreich on Feb 19, 2009 2:13 PM

Re: Dynamic SQl results in DUMP

Sm1tje — Thu, 19 Feb 2009 13:13:27 GMT

Sorry, forget about the IS INITIAL.

I got it working for me, but your requirement is not all to clear to me, since you are looking for a selection, where a certain field is NOT filled?

It is probably only a test program, so it's not that important.