result of select statement as tooltip

[hudo]

Hello,

I got a table "table_content"
ID STATUS
1234 1
1235 1
1236 12
1237 65
1238 1
1239 13


and another table "table_error"
STATUS Description
1 Everything ok
2 IO-ERROR
12 TYPE-ERROR
13 NO CONNECTION
65 NO VALID DATA

I display the table_content in a form and by going with the mouse over a STATUS field (ie: STATUS = 12) the corresponding entry(ies) from a select
(here: select description from table_error where status = 12) should appear just like the TOOLTIP. (here: TYPE-ERROR)

 

[HimanB]

Hi,
Make a Control Block & add a Control item in it with bevel -- None.
Make a small Canvas & Place Text-item on it.
Now create a trigger when-mouse-enter on STATUS feild.
In this trigger write the query to Select Status description based on the Status value of current record & use Show Window/Show view built-ins to display the Canvas & text item.
Add triggers When-mouse-click,When-mouse-click,When-mouse-double-click & When-mouse-leave and use buil-ins Hide view/Hide Window to hide the Pop-up canvas.

HTH
Regards
Himanshu

 

[HimanB]

Sorry Hudo,
I did not see that you wanted to display the message as Tooltip.
For this you do not need to create extra Canvas,block or Item.
Simply make use of when-new-item-instance trigger and set the TOOLTIP_TEXT property with the text of the Status Description feild which you should fetch in the above mentioned trigger based upon the Current record's Status id.

HTH
Regards
Himanshu