Announcement

Collapse
No announcement yet.

function in report do not works with ` `

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • function in report do not works with ` `

    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?

  • #2
    i created new report with the SQL and works fine.
    i think that this bug is when i modify a report.

    Comment


    • #3
      i find out that the error is when the function has 2 or more parameters. with one it works fine.

      Comment

      Working...
      X