This topic is locked

Error in Query Designer

4/12/2017 4:46:44 PM
PHPRunner General questions
D
Daviant author

Regards;
I am presenting a problem that I do not know if it is normal or it is a fault.
I have 2 tables with the following SQL statement:



SELECT

dbo.[DVC-DOCUMENTOS-SII].RUT,

dbo.[DVC-DOCUMENTOS-SII].FOLIO,

dbo.[DVC-DOCUMENTOS-SII].NOMBRE,

dbo.[DVC-DOCUMENTOS-SII].EMISION,

dbo.[DVC-DOCUMENTOS-SII].TOTAL,

dbo.[DVC-DOCUMENTOS-SII].RECEPCION,

dbo.[DVC-DOCUMENTOS-SII].TRACK,

dbo.[DVC-DOCUMENTOS-SII].ENTIDAD,

dbo.[DVC-DOCUMENTOS-SII].NUMERO,

dbo.[DVC-DOCUMENTOS-SII].NOTAS,

dbo.[DVC-DOCUMENTOS-SII].TIDO,

dbo.MAEEDO.LIBRO,

dbo.MAEEDO.ESPGDO,

dbo.[DVC-DOCUMENTOS-SII].TIPO,

dbo.MAEEDO.FEULVEDO

FROM dbo.[DVC-DOCUMENTOS-SII]

LEFT OUTER JOIN dbo.MAEEDO ON dbo.[DVC-DOCUMENTOS-SII].ENTIDAD = dbo.MAEEDO.ENDO AND dbo.[DVC-DOCUMENTOS-SII].NUMERO = dbo.MAEEDO.NUDO AND dbo.[DVC-DOCUMENTOS-SII].TIDO = dbo.MAEEDO.TIDO

AND YEAR(dbo.[DVC-DOCUMENTOS-SII].EMISION) = YEAR(dbo.MAEEDO.FEEMDO)

AND MONTH(dbo.[DVC-DOCUMENTOS-SII].EMISION) = MONTH(dbo.MAEEDO.FEEMDO)

ORDER BY dbo.[DVC-DOCUMENTOS-SII].RECEPCION DESC, dbo.[DVC-DOCUMENTOS-SII].FOLIO DESC


Everything works fine except for the "Query designer" option where the following message appears when I select it:
PHPRunner was unable to parse your SQL query. Designer tab is not available.
Why does this happen?
Many thanks
(Google translator)

Sergey Kornilov admin 4/13/2017

PHPRunner's Query Designer won't be able to parse some SQL Query. In this case you need to edit SQL Query manually.