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

Error in the module RSQL accessing the database interface

Former Member — Tue, 11 Nov 2008 14:50:22 GMT

I have written the following query.

SELECT a~no

a~hist_no

a~chk_stat

a~chk_date

a~user as chk_user

b~name as chk_by

into corresponding fields of table hist

from zhist as a INNER JOIN zuser as b on

a_{user = b}bname

where pspnr = v_pspnr

and chk_no = v_chk_no.

I am getting the dump "Error in the module RSQL accessing the database interface".

Please provide me the solution.

Thanx,

Selva.

Re: Error in the module RSQL accessing the database interface

Former Member — Wed, 12 Nov 2008 04:26:35 GMT

Hi,

As i have analysed your query in that you are putting the data in the internal table 'hist' which is also a standard structure and if you check in SE11 'hist' is the standard structure for 'Tablespace History' and might be because of that it is causing the problem.

Kindly check by changing the name of the internal table to tt_hist and then try.

I think that will solve the problem.

Regards,

Harsh Goel

Re: Error in the module RSQL accessing the database interface

Former Member — Mon, 26 Apr 2010 12:11:20 GMT

resolved