Devart Forums

Hi,

I recently upgraded to 5.3.9 and noticed that I'm unable to create the insert/update sql statements with the UniQuery Editor of a rather big query that was working ok with 5.3.8.

I'm using this query:

select p.idprmdocsedt, p.idtipodoc, p.idsubtipodoc, p.idarea, p.idunidfunc,
p.idfuncao, p.idprofissao, p.idusuario, p.idgrupotrab, p.idperfil,
p.pdselabor, p.pdsedita, p.pdsrevis, p.pdsaprov,
p.pdsinser, p.PDSARQUIV, p.PDSDESCARTE, p.PDSDIRNEG, p.PDS_HASHVAL,
p.PDSNEGTERC, p.PDSADICREPTXT, p.PDSDELREPTXT,
p.IDUSUCRIADOR, p.IUCPDS, p.DTHRPDS,
a.AREANIVELHIER, a.areadesc, uf.UNFNIVELHIER, uf.unfdesc,
fn.FNCNIVELHIER, fn.fncdesc, r.PROFNIVELHIER, r. PROFDESC,
us.usunome, us.ususobrenome, gt.gptdesc, pg.perfdesc
from prmdocsedt p
Left outer join subtipo_documento sd on (sd.idtipodoc = p.idtipodoc)
and (sd.idsubtipodoc = p.idsubtipodoc)
Left Outer Join area a on (a.idarea = p.idarea)
Left Outer Join unidade_funcional uf on (uf.idarea = p.idarea)
and (uf.idunidfunc = p.idunidfunc)
Left Outer Join funcao fn on (fn.idfuncao = p.idfuncao)
Left Outer Join Profissao r on (r.IdProfissao = p.IdProfissao)
Left Outer Join usuario us on (us.idusuario = p.idusuario)
Left Outer Join perfil pg on (pg.idperfil = p.idperfil)
LEft Outer Join grupotrab gt on (gt.idgrupotrab = p.idgrupotrab)
where
p.idtipodoc = :IDTIPODOC
and p.idsubtipodoc = :IDSUBTIPODOC
order by a.AREANIVELHIER, a.areadescproc, uf.UNFNIVELHIER, uf.unfdescproc,
fn.FNCNIVELHIER, fn.fncdesc, r.PROFNIVELHIER, r.PROFDESCPROC,
us.usunomeProc,us.ususobrenomeproc, gt.gptdescproc

I go to the Sql generator, select the table prmdocsedt and try to generate the Update SQLs, the only thing that it makes is:

-Insert Query
INSERT INTO PRMDOCSEDT
(PDSDELREPTXT)
VALUES
(:PDSDELREPTXT)

-Update Query
UPDATE PRMDOCSEDT
SET
PDSDELREPTXT = :PDSDELREPTXT
WHERE
IDPRMDOCSEDT = :Old_IDPRMDOCSEDT

-Refresh query
SELECT PDSDELREPTXT FROM PRMDOCSEDT
WHERE
IDPRMDOCSEDT = :IDPRMDOCSEDT

etc...

where I should get

INSERT INTO PRMDOCSEDT
(IDPRMDOCSEDT, IDTIPODOC, IDSUBTIPODOC, IDAREA, IDUNIDFUNC, IDFUNCAO, IDPROFISSAO, IDUSUARIO, IDGRUPOTRAB, IDPERFIL, PDSELABOR, PDSEDITA, PDSREVIS, PDSAPROV, PDSINSER, PDSARQUIV, PDSDESCARTE, PDSDIRNEG, PDSNEGTERC, PDS_HASHVAL, IUCPDS, DTHRPDS, IDUSUCRIADOR, PDSADICREPTXT, PDSDELREPTXT)
VALUES
(NEXT VALUE FOR GEN_IDPRMDOCSEDT, :IDTIPODOC, :IDSUBTIPODOC, :IDAREA, :IDUNIDFUNC, :IDFUNCAO, :IDPROFISSAO, :IDUSUARIO, :IDGRUPOTRAB, :IDPERFIL, :PDSELABOR, :PDSEDITA, :PDSREVIS, :PDSAPROV, :PDSINSER, :PDSARQUIV, :PDSDESCARTE, :PDSDIRNEG, :PDSNEGTERC, :PDS_HASHVAL, :IUCPDS, :DTHRPDS, :IDUSUCRIADOR, :PDSADICREPTXT, :PDSDELREPTXT)
RETURNING
IDPRMDOCSEDT


Working with Firebird v2.5.3, XE3 and Unidac 5.3.9
If needed I can send a example DB and project.

Thank you
Andrew

We can't reproduce the problem. Please send a database creating script to pavelp*devart*com.

Pavel,

Did you receive my email with the example DB and the descriptions?
Were you able to reproduce the problems?

Thank you
Andrew

Thank you for the information.
We have reproduced the problem and investigation is in progress.
We will notify you when we have any results.

We have fixed this problem, the fix will be included in the next release. We are going to release UniDAC this week.