dump error

[Former Member]

Hi,

There is a select statement like this in my program.

SELECT dispo INTO g_dispo

FROM t024d

UP TO 1 ROWS WHERE dispo IN dispo.

ENDSELECT.

when i give the dispo value in the selection-screen and try to debug the program,it is selectng the vaue into g_dispo table.But after that it is giving dump error as 'Invalid interruption of database selection'.What would be the reason for this?

[Former Member]

Hi,

If you want the single record to be selected then try this:

SELECT SINGLE dispo INTO g_dispo

FROM t024d

WHERE dispo IN dispo.

here g_dispo would be the structure.

[Former Member]

hi there....

firstly, insert the dispo value into a field of the table , not the entire table. and secondly, try to remove endselect.

hope it helps...

[Former Member]

Hi,

If you want the single record to be selected then try this:

SELECT SINGLE dispo INTO g_dispo

FROM t024d

WHERE dispo IN dispo.

here g_dispo would be the structure.

[Former Member]

U cannot put a break point in debugging mode in

select.. endselect .. as it commits the work ..

(also U cannot put a commit work in select-endselect)

when U use commit work all the pointers to the database are

lost and U'll get dump.

[Sm1tje]

loose the endselect!

[Former Member]

Remove the endselect.

Amit.