Subject | Record editing with Lookupcombo |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-07-23T11:54:27Z |
Hi!
I have grid with TIB_Lookupcombo in it
It's datasource is:
SELECT ID , NIMI FROM KULULIIGID
Keylinks: ID=KULU
KeyDesclinks: NIMI=KULUNIMI
My grids query is:
SELECT MAJA,AASTA,KUU,KULU
, (select NIMI from KULULIIGID where ID=KULUD.KULU) as
KULUNIMI
, SUMMA , TARIIF
FROM KULUD
JOIN KULULIIGID on id=kulud.kulu
where NONDELETE=0 AND MAJA=:MAJA and AASTA=:AASTA and
KUU=:KUU and tariif=:TARIIF
for update
(I'm using UpdateSQL to insert,edit and delete data)
The problem is with Lookupcombo - I can't change the
values. I can Insert new record, I can delete record, I can
edit other fieds, but when I want to change the KULUNIMI
from LookupCombo, then nothing happens (dropdown opens but
I cant select other row from there).
What am I missing?
BTW, I'm using IBO 4.0.1232
Riho-Rene Ellermaa
Ellermaa Tarkvaratöökoda
http://www.ellermaasoft.ee
I have grid with TIB_Lookupcombo in it
It's datasource is:
SELECT ID , NIMI FROM KULULIIGID
Keylinks: ID=KULU
KeyDesclinks: NIMI=KULUNIMI
My grids query is:
SELECT MAJA,AASTA,KUU,KULU
, (select NIMI from KULULIIGID where ID=KULUD.KULU) as
KULUNIMI
, SUMMA , TARIIF
FROM KULUD
JOIN KULULIIGID on id=kulud.kulu
where NONDELETE=0 AND MAJA=:MAJA and AASTA=:AASTA and
KUU=:KUU and tariif=:TARIIF
for update
(I'm using UpdateSQL to insert,edit and delete data)
The problem is with Lookupcombo - I can't change the
values. I can Insert new record, I can delete record, I can
edit other fieds, but when I want to change the KULUNIMI
from LookupCombo, then nothing happens (dropdown opens but
I cant select other row from there).
What am I missing?
BTW, I'm using IBO 4.0.1232
Riho-Rene Ellermaa
Ellermaa Tarkvaratöökoda
http://www.ellermaasoft.ee