SET, KeyLinks is already set to the primary key of O (DIR_OBR)

--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:

>
> Roberto Freitas wrote:
> > I'm using IBO4_5 and FireBird 1.5.
> > I have a TIB_Grid based on a TIB_Query.
> > With this query's SQL property it's allowed to edit fields on

grid:

> > SELECT
> > O.DIO_CIIREG,O.DIO_DOCANO,O.DIO_DOCNUM,O.DIO_PARC,O.DIO_VENCTO,
> > O.DIO_VALOR,O.DIO_BOOL,
> > (SELECT D.DOC_LOTE FROM DOCUMENTO D WHERE D.DOC_CIIREG =
> > O.DIO_CIIREG AND D.DOC_ANO = O.DIO_DOCANO AND D.DOC_NUM =
> > O.DIO_DOCNUM) AS DOC_LOTE,
> > (SELECT D.DOC_DOC FROM DOCUMENTO D WHERE D.DOC_CIIREG =

O.DIO_CIIREG

> > AND D.DOC_ANO = O.DIO_DOCANO AND D.DOC_NUM = O.DIO_DOCNUM) AS
> > DOC_DOC,
> > (SELECT I.PCI_DESCR FROM PARCERIA I WHERE I.PCI_REG = (SELECT
> > D.DOC_PCIREG FROM DOCUMENTO D WHERE D.DOC_CIIREG = O.DIO_CIIREG

AND

> > D.DOC_ANO = O.DIO_DOCANO AND D.DOC_NUM = O.DIO_DOCNUM)) AS

PCI_DESCR,

> > (SELECT I.PCI_CCTCONTAF FROM PARCERIA I WHERE I.PCI_REG =

(SELECT

> > D.DOC_PCIREG FROM DOCUMENTO D WHERE D.DOC_CIIREG = O.DIO_CIIREG

AND

> > D.DOC_ANO = O.DIO_DOCANO AND D.DOC_NUM = O.DIO_DOCNUM)) AS
> > PCI_CCTCONTAF,
> > (SELECT P.PAR_RAZAO FROM PARCEIRO P WHERE P.PAR_REG = (SELECT
> > I.PCI_PARREG FROM PARCERIA I WHERE I.PCI_REG = (SELECT

D.DOC_PCIREG

> > FROM DOCUMENTO D WHERE D.DOC_CIIREG = O.DIO_CIIREG AND D.DOC_ANO

=

> > O.DIO_DOCANO AND D.DOC_NUM = O.DIO_DOCNUM))) AS PAR_RAZAO
> > FROM DIR_OBR O
> > WHERE O.DIO_CIIREG= :ciireg
> > ORDER BY O.DIO_BOOL DESC,O.DIO_VENCTO,O.DIO_PARC
> >
> > This other equivalent SQL (using JOIN clause) gives same result

set,

> > but it's NOT allowed to edit fields:
> > SELECT
> > O.DIO_CIIREG,O.DIO_DOCANO,O.DIO_DOCNUM,O.DIO_PARC,O.DIO_VENCTO,
> > O.DIO_VALOR,O.DIO_BOOL,
> >

D.DOC_LOTE,D.DOC_DOC,D.DOC_PCIREG,I.PCI_DESCR,I.PCI_CCTCONTAF,P.PAR_R

> > AZAO
> > FROM ((DIR_OBR O INNER JOIN DOCUMENTO D ON O.DIO_CIIREG =
> > D.DOC_CIIREG AND O.DIO_DOCANO = D.DOC_ANO AND
> > O.DIO_DOCNUM=D.DOC_NUM) INNER JOIN PARCERIA I ON D.DOC_PCIREG =
> > I.PCI_REG) IINER JOIN PARCEIRO P ON I.PCI_PARREG = P.PAR_REG
> > WHERE O.DIO_CIIREG= :ciireg
> > ORDER BY O.DIO_BOOL DESC,O.DIO_VENCTO,O.DIO_PARC
> >
> > So I suppose there is some kind of limitation when using JOIN

clause.

> > Anyway, I'm confused because with this another query using JOIN

edit

> > IS allowed:
> > SELECT G.meg_ciireg, G.meg_metodo, G.meg_ug, G.meg_grcod,
> > G.meg_trivial,
> > G.meg_inc, G.meg_alt, G.meg_exc, M.met_descr as metdescr,

M.met_tipo

> > as mettipo
> > FROM Metodo_GRP G INNER JOIN Metodo M
> > ON G.meg_ciireg = M.met_ciireg AND G.meg_metodo = M.met_metodo
> > WHERE (G.meg_ciireg = :ciireg) AND (G.meg_metodo >= 0)
> >
> > Well, what is the trick? Is there any software (IBO or

FireBird?)

> > limitations about this subject? What about later software

versions?

>
> Simply set KeyLinks to the primary key or a unique field

combination of O (DIR_OBR) and I think the 'simple query' will
become updateable in IBO.

>
> HTH,
> Set
>