Subject | change lookup field without refetch |
---|---|
Author | e9426420@stud4.tuwien.ac.at |
Post date | 2001-10-19T12:33:53Z |
I have a table (t1) and a lookup table (t2).
In a query I select records from t1.
It looks like this
select t1.* ,
(Select desc from t2
where t1.Type=t2.type) as Description
from t1
The user can change t1.type from an search-window which returns type and de=
scription to me. In the data-aware controls the lookup-field "description" d=
on´t change immediately, only after a refresh. Because I know the value of "=
description" from the search-window it should be possibly to change it at on=
ce (perhaps with the bufferXXX properties). I want to avoid a second lookup-=
query only for this purpose.
thanks Oliver
In a query I select records from t1.
It looks like this
select t1.* ,
(Select desc from t2
where t1.Type=t2.type) as Description
from t1
The user can change t1.type from an search-window which returns type and de=
scription to me. In the data-aware controls the lookup-field "description" d=
on´t change immediately, only after a refresh. Because I know the value of "=
description" from the search-window it should be possibly to change it at on=
ce (perhaps with the bufferXXX properties). I want to avoid a second lookup-=
query only for this purpose.
thanks Oliver