Hello Paul,

super, it is working now!

Is there some Tips & Tricks document for IBObjects available in the www to read through? I would never have thought about putting a IB_LookupCombo on to a TIB_Grid to achieve such nice results! I bet that there are many more nice things like this available which I just don't know of.
I just started to work my way throught the "IBO Tech Info Sheets". Is that the right place?

Thanks a lot again for you help

Rainer


-----Ursprüngliche Nachricht-----
Von: Paul Vinkenoog [mailto:paul@...]
Gesendet: Mittwoch, 5. November 2003 00:20
An: IBObjects@yahoogroups.com
Betreff: AW: [IBO] TIB_ComboBox / TIB_LookupCombo


Hello Rainer,

> thanks a lot for your instructions! They seem to "mostly" work
> except that I get a exception "field name tls_line_stop.ls_lsr_id
> was not found" when I enter the cell for lsr_reason_text and select
> a item from the combobox (showing up nicely as you described).

You forgot to include tls_line_stop.ls_lsr_id in the select clause:

> SELECT LS_START_DATE_TIME, LS_END_DATE_TIME,

--> add LS_LSR_ID, <--

> LSR_REGION, LSR_REASON_TEXT
> FROM TLS_LINE_STOP
> LEFT OUTER JOIN TLSR_LINE_STOP_REASON
> ON LS_LSR_ID=LSR_ID

(...)

> next QLineStopReasons.KeyDescLinks to : "lsr_reason_text=LS_LSR_ID"

KeyDescLinks should be: lsr_reason_text=lsr_reason_text

(The left hand side being the field from the lookup query, the right
hand side from the keysource query. They are often the same, but
not always.)

OK, if you change those two things it should work.


Greetings,
Paul Vinkenoog



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tm86fb5/*http://www.netflix.com/Default?mqso=60178323&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1754451/rand=432469653>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]