Subject | Re: [IBO] TIB_LookupCombo in a Grid |
---|---|
Author | lobolo2000 |
Post date | 2001-09-04T05:44Z |
Mike,
Since the IB_LookupCombo works as planned outside the grid, then you have to
add to your sqlbook query a lookup column, and correctly define your
KeyDescLinks. This property allows an IB_LookupCombo to know which column in
the grid it should be linked to and consequently update.
SELECT BANKCODE , DTE , REF , ACCOUNTAMOUNT ,
BANKAMOUNT , BANKSTREF, BOOKREF , CHART ,
(SELECT CHARTDESC FROM CHART WHERE
ACCOUNT=BANKDETAILS.CHART) AS
CHARTLU,
CHQNO , DETAILS , RECEIPTNO ,
COSTCROSSREF,LINENO
FROM BANKDETAILS
Where Bankcode=:Bankcode
Order By Lineno
KeyDescLinks: CHART.CHARTDESC=CHARTLU
I guess this should work.
HTH
_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com
Since the IB_LookupCombo works as planned outside the grid, then you have to
add to your sqlbook query a lookup column, and correctly define your
KeyDescLinks. This property allows an IB_LookupCombo to know which column in
the grid it should be linked to and consequently update.
SELECT BANKCODE , DTE , REF , ACCOUNTAMOUNT ,
BANKAMOUNT , BANKSTREF, BOOKREF , CHART ,
(SELECT CHARTDESC FROM CHART WHERE
ACCOUNT=BANKDETAILS.CHART) AS
CHARTLU,
CHQNO , DETAILS , RECEIPTNO ,
COSTCROSSREF,LINENO
FROM BANKDETAILS
Where Bankcode=:Bankcode
Order By Lineno
KeyDescLinks: CHART.CHARTDESC=CHARTLU
I guess this should work.
HTH
_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com