topic Re: runtime error in Application Development and Automation Discussions

runtime error

Former Member — Fri, 18 Apr 2008 08:25:35 GMT

i am developing a report and when i execute it gives me runtime error.

the runtime error is:Error in the module RSQL accessing the database interface.

and it shows the the error line which i have written and it is like this.

select * from zfiexpartf into corresponding fields of table it_partp

where zzvencode in s_vcode and zzp_fxcyr in r_year and

zzp_fxcqtr in r_qtr.

give me an advice so as to what to do .

thanks in advance.

jacob.

Former Member — Fri, 18 Apr 2008 08:28:18 GMT

How is it_partp defined.

ThomasZloch — Fri, 18 Apr 2008 08:35:17 GMT

what does the short dump say under "error analysis"?

Former Member — Fri, 18 Apr 2008 08:45:30 GMT

Hi,

Check you database table also. Does it has inconsistent data??

Thanks and Regards,

lakshmi.

Former Member — Fri, 18 Apr 2008 08:47:51 GMT

make sure that

s_vcode

r_year and

r_qtr are all select-options otherwise use EQ instead of IN.