Unable to build insert/update/delete/refresh queries with 5.3.9

[andrewsvaz]

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

[PavloP]

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

[andrewsvaz]

Pavel,

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

Thank you
Andrew

[ViktorV]

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

[ViktorV]

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