DUMP

[Former Member]

Hi friends,

In my program I am modifying the field in the temporary table (ZTEST) which I am created . if I modify this table with select single *

It is working fine. But if I modify between select * and endselect then the dump error is coming and the error analysis is as shown below.

In st22 the error analysis is

An exception occurred. This exception will be dealt with in more detail

below. The exception, assigned to the class 'CX_SY_OPEN_SQL_DB', was not caught, which led to a runtime error. The reason for this exception is:One of the database selections included a database commit.The selection was then supposed to continue. Before a

database commit, however, all outstanding database selections must be concluded.

Possible causes in the application program:

Within a loop (SELECT/LOOP/EXEC SQL), one of the following

statements is used:

- MESSAGE (apart from MESSAGE S...)

- COMMIT WORK

- ROLLBACK WORK

- CALL SCREEN

- CALL DIALOG

- CALL TRANSACTION

- SUBMIT

- BREAK-POINT

- WAIT

In debugging mode, a program sometimes triggers

a "COMMIT WORK" during the database selection. As a result

this termination may also occur in debugging mode with a correct

a "COMMIT WORK" during the database selection. As a result

this termination may also occur in debugging mode with a correct

program.

A "COMMIT WORK" during debugging may be due to the following reasons:

1. A program or screen was regenerated

and updated in the database.

2. Each user needs a private process in debugging mode, but

the number of available processes is restricted. If this

limit is exceeded, each debugging step then requires a

"COMMIT WORK".

The error occurred in a statement in which table "ZTEST " is accessed.

Thanks for your help.

[Former Member]

Hi,

I think you are trying to debug (Step) through the select and end select statements.

This is causing the dump.

Please do not debug the select end select.

[Former Member]

Hi Thanks for your reply. But with out in debugging mode also getting the same dump.

[Former Member]

can you please paste your code ?

Thanks

Seshu