i created a report with this SQL in version 7.00001 and this worked fine.
SELECT f_get_ccp_nmrodoc(ccp_cdgo,tdo_cdgo) as numero_factura, ccp.ccp_nmro as ccp_ccp_nmro
from ccp_cntas_cyp ccp, ter_trcro ter
where ccp.ter_cdgo = ter.ter_cdgo and ccp.neg_cdgo = 1 and ccp_procsdo = ‘S’ and ccp_actvo = ‘S’ and ccp.ccp_tpocnta = ‘CXC’
now, i modified my report and SC set
automatically to my function:
SELECT f_get_ccp_nmrodoc(ccp_cdgo,tdo_cdgo)
as numero_factura, ccp.ccp_nmro as ccp_ccp_nmro, ccp_newfield as newfield
from ccp_cntas_cyp ccp, ter_trcro ter
where ccp.ter_cdgo = ter.ter_cdgo and ccp.neg_cdgo = 1 and ccp_procsdo = ‘S’ and ccp_actvo = ‘S’ and ccp.ccp_tpocnta = ‘CXC’
and with these
do not works!
how can i fix this bug?