I am trying to execute this sentence :
SELECT PERNR
BEGDA
ZZCPRENDA
ZZDPRENDA
ZZTPRENDA
ZZPROV from ZPREN_EMP_FUNC into (wa_entr-n_pers,
wa_entr-frecog,
wa_entr-cod_prenda,
wa_entr-descrip,
wa_entr-tall_r,
wa_entr-origen)
where subty = '0003' and begda >= ran_f-low and begda <= ran_f-high
and pernr in num_per.
But It gives me and SQL error 'Error in module RSQL of the database interface'.
It is all because of the num_per table. It contains 3001 regs.
How can I solve it ? Should I modify the maximum size of the SQL statement ? or even the space??
Thanks in advance.