Can't show grid

QuestionsCan't show grid
Gustavo Ageitos asked 6 years ago

Hi Abu Ghufran

I have a full version 1.4.8 build 105-20130424

and cant show grid.

this my ->select_command = "SELECT
MAX(INTPAC.ORI) AS oPaciente,
MAX(INTPAC.PAC) AS nPaciente,
MAX(CLIPAC.NOM) AS Nombre,
MAX(CLIPAC.NDO) AS NroDocumento,
MAX(CLIPAC.FNA) AS FechaNac,
DATEDIFF(year,MAX(CLIPAC.FNA),GETDATE()) AS Edad,
MAX(CLINST.DES) AS Institucion,
MAX(INTSEC.NOM) AS Sector,
MAX(CLISER.NOM) AS Servicio,
MAX(CNSRPO.DES) AS Tipo,
MAX(CLIPRF.NOM) AS Profesional,
MAX(DGI.DES) AS Diagnostico_Ing,
MAX(DGE.DES) AS Diagnostico_Egr,
MAX(INTPAT.DES) AS Motivo,
MAX(CLIPAC.OBS) AS Observacion,
MAX(INTPAC.FIN) AS Fecha_ing,
MAX(INTPAC.FEG) AS Fecha_egr,
MAX(INTPAC.EGR) AS Egreso
FROM INTPAC
LEFT JOIN CLIPAC
ON INTPAC.ORI=CLIPAC.ORI
AND INTPAC.PAC=CLIPAC.PAC
LEFT JOIN CLINST
ON CLIPAC.INS = CLINST.INS
LEFT JOIN CLISER
ON INTPAC.SVP = CLISER.SER
LEFT JOIN CNSRSP
ON INTPAC.ORI=CNSRSP.ORI
AND INTPAC.PAC=CNSRSP.PAC
AND CLIPAC.HCL = CNSRSP.HCL
AND CNSRSP.PRG = '465'
LEFT JOIN CNSRPO
ON CNSRSP.PRG = CNSRPO.PRG
AND CNSRSP.RSP_NUM = CNSRPO.RSP
LEFT JOIN INTPAT
ON CLIPAC.MOT = INTPAT.PAT
LEFT JOIN INTPAT DGI
ON CLIPAC.DGI_P = DGI.PAT
LEFT JOIN INTPAT DGE
ON CLIPAC.DGE_P = DGE.PAT
LEFT JOIN INTSEC
ON INTPAC.SCP = INTSEC.SEC
LEFT JOIN CLIPRF
ON CNSRSP.PRF = CLIPRF.PRF
WHERE
INTPAC.SCP IN (SELECT SEC FROM INTSEC WHERE NOM LIKE '%PISO%' OR NOM LIKE '%UTI%' OR NOM LIKE '%UCE%' OR NOM LIKE '%LIMBO%')
AND INTPAC.FEG BETWEEN CONVERT(Datetime,'2017-12-01 00:00:00',120) AND CONVERT(Datetime, '2017-12-31 23:59:59', 120)
GROUP BY INTPAC.ORI, INTPAC.PAC, CLIPAC.NOM ";

1 Answers
Gustavo Ageitos answered 6 years ago

Solved, cant use select in where 🙁

Your Answer

14 + 1 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?