Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
UNION hides "#401 The column FacturarA does not exist" |
Mon, Mar 16 2009 6:16 AM | Permanent Link |
Tiago Ameller | Courious (I think this worked on previous versions):
This query returns 1 row: SELECT 0 AS TIPO, ANO AS ANO_SERIE, CODIGO, FECHA, ASUNTO, SERIE, FACTURA, FECHAFACTURA, HISTORICO, FACTURARA, AVISOSYCOBROS, TOTALFACTURA, TOTALFACTURA - COBRADOCUENTA AS PENDIENTE, IF(FECHAANULACION IS NULL,FALSE,TRUE) AS ANULADO FROM MAEXPEDI WHERE FacturarA = 'G07682735' This query raises "#401 The column FacturarA does not exist": SELECT 1 AS TIPO, SERIE AS ANO_SERIE, CODIGO, FECHA, ASUNTO, SERIE, CODIGO AS FACTURA, FECHA AS FECHAFACTURA, HISTORICO, CLIENTE AS FACTURARA, AVISOSYCOBROS, TOTALFACTURA, TOTALFACTURA - COBRADOCUENTA AS PENDIENTE, IF (FECHAANULACION IS NULL,FALSE,TRUE) AS ANULADO FROM MAFACTU WHERE FacturarA = 'G07682735' ORDER BY FECHA DESC due CLIENTE AS FACTURARA is not valid for "WHERE FacturarA = 'G07682735'" Then this UNION should return the same error: SELECT 0 AS TIPO, ANO AS ANO_SERIE, CODIGO, FECHA, ASUNTO, SERIE, FACTURA, FECHAFACTURA, HISTORICO, FACTURARA, AVISOSYCOBROS, TOTALFACTURA, TOTALFACTURA - COBRADOCUENTA AS PENDIENTE, IF(FECHAANULACION IS NULL,FALSE,TRUE) AS ANULADO FROM MAEXPEDI WHERE FacturarA = 'G07682735' UNION SELECT 1 AS TIPO, SERIE AS ANO_SERIE, CODIGO, FECHA, ASUNTO, SERIE, CODIGO AS FACTURA, FECHA AS FECHAFACTURA, HISTORICO, CLIENTE AS FACTURARA, AVISOSYCOBROS, TOTALFACTURA, TOTALFACTURA - COBRADOCUENTA AS PENDIENTE, IF (FECHAANULACION IS NULL,FALSE,TRUE) AS ANULADO FROM MAFACTU WHERE FacturarA = 'G07682735' ORDER BY FECHA DESC but it runs ok and returns 1 row from MAEXPEDI plus ALL rows in MAFACTU |
Mon, Mar 16 2009 3:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tiago,
<< Then this UNION should return the same error: >> Yes, it is not issuing an exception as needed. I'll have a fix in the next build. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |