Error in the module RSQL accessing the database interface

Former Member — Mon, 20 Jul 2009 09:46:16 GMT

HI all ,

i have written query like this,

SELECT single stlnr FROM stpo INTO w_stlnr WHERE idnrk IN r_matnr.

assume that they are 10 part number are there when date retrival from this query upto 9 part number i am not getting run time error

10 part number i am getting runtime error in PRD , ITS working fine in QLT for same variant.

Error analysis

The system attempted to open a cursor for a SELECT or OPEN CURSOR

statement but all 16 cursors were already in use.

The statement that failed accesses table "STPO ".

The erroneous statement accesses table "STPO ".

please guide me how to solve this promblem.

Regards ,

Santosh

Edited by: santosh jajur on Jul 20, 2009 3:50 PM

Re: Error in the module RSQL accessing the database interface

former_member194669 — Mon, 20 Jul 2009 14:00:03 GMT

Try to change this way


data : begin of i_stlnr occurs 0.
data : stlnr like stpo-stlnr.
data : end of i_stlnr.

SELECT stlnr FROM stpo INTO table i_stlnr WHERE idnrk IN r_matnr.
if sy-subrc eq 0.
  read table i_stlnr index 1.
  move i_stlnr-stlnr to w_stlnr.
endif.

a®

topic Error in the module RSQL accessing the database interface in Application Development and Automation Discussions

Error in the module RSQL accessing the database interface

Re: Error in the module RSQL accessing the database interface