Skip to Content
0
Former Member
Mar 25, 2009 at 01:42 PM

SQL Sentence Error

22 Views

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.