I cant get a field on report from a view

Posted by felipedz on Stack Overflow See other posts from Stack Overflow or by felipedz
Published on 2013-06-10T23:53:15Z Indexed on 2013/06/27 22:21 UTC
Read the original article Hit count: 173

Filed under:
|

When I get a field, this work good.

But, when get a field from a 'VIEW', is a problem because the code of a VIEW is:

CREATE OR REPLACE VIEW tabla_clientes AS
SELECT id_cliente,nombre, CONCAT('$ ',FORMAT(monto_a_favor,0), '???'), CONCAT('$ ',FORMAT(calcular_monto_por_cobrar_cliente(id_cliente),0)) 
FROM cliente;

When I compile this. Appears errors from the name of fields.

Description                                            |  Object
----------------------------------------------------------------------------
Syntax error, insert ";" to complete BlockStatements   | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}
Syntax error on tokens, delete these tokens            | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}
Syntax error on token ",", delete this token           | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}

If I change the name at this field appears other error.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about jasper-reports