Subject | Lookup field with TIBQuery |
---|---|
Author | marcoandrecarvalho |
Post date | 2005-02-21T20:06:20Z |
Hi!
I´m trying to use the component TIBQuery and make a join with a
table. Here is the tables:
TABLE FABRICANTE:
CD_FABRICANTE SMALLINT NOT NULL,
NM_FABRICANTE VARCHAR(30) NOT NULL
TABLE ANTENA:
CD_ANTENA SMALLINT NOT NULL,
ID_FABRICANTE SMALLINT,
DESCRICAO VARCHAR(40) NOT NULL,
GANHO FLOAT NOT NULL
I´m using the folowing SQL to do this:
SELECT FABRICANTE.NM_FABRICANTE, ANTENA.CD_ANTENA, ANTENA.DESCRICAO,
ANTENA.GANHO
FROM ANTENA
LEFT OUTER JOIN FABRICANTE ON (ANTENA.ID_FABRICANTE =
FABRICANTE.CD_FABRICANTE)
The question is: How can I do a query which gives me the ability to
edit that join? I want to simulate a LookupField in table ANTENA
(FABRICANTE.NM_FABRICANTE). I dont know if you understand... I just
want to edit the values (NM_FABRICANTE) of the above query, using the
TIB_Query. Is that possible or I have to use the TIBOTable to do that
(just like the TTable) ?
Thank you very much!
Marco André
I´m trying to use the component TIBQuery and make a join with a
table. Here is the tables:
TABLE FABRICANTE:
CD_FABRICANTE SMALLINT NOT NULL,
NM_FABRICANTE VARCHAR(30) NOT NULL
TABLE ANTENA:
CD_ANTENA SMALLINT NOT NULL,
ID_FABRICANTE SMALLINT,
DESCRICAO VARCHAR(40) NOT NULL,
GANHO FLOAT NOT NULL
I´m using the folowing SQL to do this:
SELECT FABRICANTE.NM_FABRICANTE, ANTENA.CD_ANTENA, ANTENA.DESCRICAO,
ANTENA.GANHO
FROM ANTENA
LEFT OUTER JOIN FABRICANTE ON (ANTENA.ID_FABRICANTE =
FABRICANTE.CD_FABRICANTE)
The question is: How can I do a query which gives me the ability to
edit that join? I want to simulate a LookupField in table ANTENA
(FABRICANTE.NM_FABRICANTE). I dont know if you understand... I just
want to edit the values (NM_FABRICANTE) of the above query, using the
TIB_Query. Is that possible or I have to use the TIBOTable to do that
(just like the TTable) ?
Thank you very much!
Marco André