hi !
one report will occurs runtime error currently.
Runtime Errors DBIF_RSQL_INVALID_RSQL
Except. CX_SY_OPEN_SQL_DB
occuring this runtime erorr of circumstance :
When the inquiry's terms of the scope of the date of the bigger (the system used for a long time, and a large quantity of data up-to-date, the database will soon increase)
report code as follow:
SELECT awerks blifnr bekgrp agjahr amatnr abelnr abuzei aebeln
aebelp abwart alfbnr alfpos axblnr abudat a~menge
awrbtr awaers admbtr ahswae abwtar bbsart
INTO CORRESPONDING FIELDS OF et_out
FROM ekbe AS a JOIN ekko AS b ON aebeln = bebeln
AND AWERKS = BBUKRS
WHERE a~belnr IN s_belnr AND
a~ebeln IN s_ebeln AND
b~lifnr IN s_lifnr AND
b~bsart IN g_r_bsart AND
a~budat IN s_budat AND
a~vgabe = 1 AND
a~matnr IN s_matnr AND
a~werks = p_werks AND
b~ekgrp IN s_ekgrp AND
a~menge > 0 AND
a~bwart IN ('101','102','105','106','161','162','122','123') .
include other select .
ENDSELECT .
in debug I found that this statement can be perform
SELECT awerks blifnr bekgrp agjahr amatnr abelnr abuzei aebeln
aebelp abwart alfbnr alfpos axblnr abudat a~menge
but loop again,in this statement occur runtime dump!
so i want to know what limit about select ... endselect!
and it's working function!
thank you very much!