why this query does not work in Lazarus?
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2009-02-24 17:24

hello, a have a query that works in pgAdmin, but when i use Zquery it
does not work, just
Access Violation. The query is :

select  guiaFechaIngreso as "Fecha",
   ProvNombre as "Proveedor",
   D.ClasCodigo as "Cod. Modelo",
   CL.clasNombre as "Modelo",
   gde2Costo as "Cto Unitario",
   D.moneSigla as "Moneda",
   gde2Serie as "Serie",
   guiaDocSerie || '-' || guiaDocNumero as "Nro de Guia",
   gufaNumDoc as "Documento",
   tidoNombre as "Tipo Doc"-- gufaTipoDoc
from STguia as S, STproveedor as P, STguia_detalle2 as D,
STguia_docAsociado as A, STTipoDoc as TD, STclase as CL
where   S.guiaPreNum = D.guiaPreNum
and    P.provRuc = S.guiaRUCproveedor
and    A.guiaPreNUm = S.guiaPreNUm
and    A.guiaPreNUm = D.guiaPreNUm
and    gufaTipoDoc = tidoCodigo
and    D.clascodigo = CL.clascodigo

----------------------------------------------------------------------
cpalx · 2009-02-24 17:50

i changed to this way and now works perfectly  

SELECT "GU"."guiafechaingreso", "PR"."provnombre",
   "GD2"."clascodigo", "GD2"."gde2costo",
   "GD2"."monesigla", "GD2"."gde2serie",
   "GU"."guiadocserie", "GU"."guiadocnumero",
   "DA"."gufanumdoc", "TD"."tidonombre"
FROM    "STgestion_B3"."public"."stguia_detalle2" AS "GD2",
   "STgestion_B3"."public"."stguia_detalle" AS "GD",
   "STgestion_B3"."public"."stguia" AS "GU",
   "STgestion_B3"."public"."stguia_docasociado" AS "DA",
   "STgestion_B3"."public"."stproveedor" AS "PR",
   "STgestion_B3"."public"."sttipodoc" AS "TD"
WHERE    "GD2"."gudeid" = "GD"."gudeid"
AND    "GD"."guiaprenum" = "GU"."guiaprenum"
AND    "DA"."guiaprenum" = "GU"."guiaprenum"
AND    "PR"."provruc" = "GU"."guiarucproveedor"
AND    "TD"."tidocodigo" = "DA"."gufatipodoc"

----------------------------------------------------------------------
Marc · 2009-02-24 23:22

Tip, if you don't use case sensitive fields, remove all "

----------------------------------------------------------------------
cpalx · 2009-02-25 14:29

thanks for your tip, i will do it.