Select - Endselect gives a dump

[Former Member]

Hi Folks,

In our code we are using Select-Endselect. These a piece of code inside this select-endselect. Certain table has say 4 records corresponding to this query. Then the select-endselect works fine for 4 iterations. But then it dumps at the fifth one (when ideally it should should just skip to end-select). There are no breakpoints or commit statements inside the select-endselect.

Could you please suggest what could be the reason for this?

Thanks

[Former Member]

Hi Folks,

In our code we are using Select-Endselect. These a piece of code inside this select-endselect. Certain table has say 4 records corresponding to this query. Then the select-endselect works fine for 4 iterations. But then it dumps at the fifth one (when ideally it should should just skip to end-select). There are no breakpoints or commit statements inside the select-endselect.

Could you please suggest what could be the reason for this?

Thanks

[Former Member]

hi Munish,

Please place the dump details here

Regards,

Santosh

[Former Member]

Hi Santosh,

The details are following:

The dump type is 'DBIF_RSQL_INVALID_CURSOR'.

From the details:

The error occurred in a statement in which table "FKKVKP " is accessed

The code:

008230 FROM fkkvkp AS ca

008240 JOIN ever AS c

008250 ON ca_{vkont = c}vkonto

008260 JOIN eanl AS i

008270 ON c_{anlage = i}anlage

008280 JOIN evbs AS p

008290 ON i_{vstelle = p}vstelle

008300 JOIN iloa AS fl

008310 ON p_{haus = fl}tplnr

008320 JOIN adrc AS a

008330 ON fl_{adrnr = a}addrnumber

> WHERE ca~gpart = t_partner-partner.

008350

Regards,

Munish

[Former Member]

Debugging a SELECT.... END SELECT statement, always leads to dump.

So don't debug a SELECT... ENDSELECT statement.

Regards,

Pavan P.

[Former Member]

Hi Pavan,

The statement dumps even without debugging (with the same error). For testing, the breakpoint was set at the beginning (on the select ) only & not inside the select-endselect.

Regards,

Munish

[Former Member]

Hi,

Can you just paste your code.

Regards,

Atish

[Former Member]

Hi !

Do you have code construction that causes implicid COMMIT WORK

(i.e. a function module that hase one, a call screen or a popup message ... ??)

That won't work within a SELECT-ENDSELECT.

In that case you'll have to change your code to a LOOP-ENDLOOP.

Regards

rainer

Some Reware points would be nice if that helped a bit...

[Former Member]

Hi Rainer,

Theres a concatenation statement & a couple of other select statements inside select-endselect. Moreover it seems to work perfectly for first 4 iterations. (when there are only 4 corresponding records in the db table)

Regards,

Munish

[Former Member]

hi check out ur code

1> if you have used corresponding then the feilds shld be declared in the same order

2> check your data element for which it is giving u the dump is the declaration same as declared in database tabel.

please check these 2 points i hope u will get rid of the dump

also if it doesnt helps you paste your code here

thnkx

bhanu

[Former Member]

Eventually we had split up the query.

Regards,

Munish

[Former Member]

Eventually we had split up the query.

Regards,

Munish

[Former Member]

Hi,

In debugging mode Select- End select will go for dump most of times,

Come out of debugging and try..