OraFAQ Forum: Forms » Tool Tip Require to Display the Data

Home » Developer & Programmer » Forms » Tool Tip Require to Display the Data (Form 6i, Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tool Tip Require to Display the Data [message #517259]

Mon, 25 July 2011 02:15

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Hi,

If it possible to display Tool Tip of a Column Require to
Display the Data contain in that Column.

How to Done, Kindly Guidence me.

Regards,

C V S

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517261 is a reply to message #517259]

Mon, 25 July 2011 02:21

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know (should research) but - why would you want to do that? You already see what's in the column. Otherwise, you couldn't see its tooltip either. So, what's the purpose of doing that?

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517262 is a reply to message #517261]

Mon, 25 July 2011 02:27

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Sir,

Thanks for Your immediate Reply.

The Requirement Due to Column display size is less then the Data contains in that Column hence we require to display the data of the column through tool tip.

Regards,

C V S

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517265 is a reply to message #517262]

Mon, 25 July 2011 02:32

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see; but, users can scroll through the column, can't they? That's what we (usually) do - click into the column and (using left and right keys on the keyboard) read what's in there.

Or, create a multi-lines item. Or, get into the item and open its "Editor".

[Updated on: Mon, 25 July 2011 02:34]

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517273 is a reply to message #517265]

Mon, 25 July 2011 02:54

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Thanks Sir,

I Just require to Know If it Possible to Display the Column data in Tool tip. Thus only i posted this query.

Regards,

C V S

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517280 is a reply to message #517273]

Mon, 25 July 2011 03:11

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK then, research done. Good news for you - it can be done.

I created a form based on Scott's DEPT table and shrank the DNAME item so that it doesn't display the whole value. I also created a POST-QUERY block-level trigger:

set_item_property('dname', tooltip_text, :dname);

The result:

/forum/fa/9221/0/

Attachment: tooltip.png
(Size: 7.91KB, Downloaded 5021 times)

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517286 is a reply to message #517280]

Mon, 25 July 2011 03:57

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

That won't work for a multi-record block though. In fact it won't work for a single record block if you query multiple records and skip between them with next/prev record.
Suggest you put the code in when-new-item-instance on the apprpopriate item.

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517289 is a reply to message #517286]

Mon, 25 July 2011 04:07

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

True (everything you said).

It works OK for a single record block when navigating through records using UP and DOWN keys on the keyboard (which was what I tested).

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517290 is a reply to message #517289]

Mon, 25 July 2011 04:11

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are you sure? Can't test it myself but everytime you go to a new record the post-query will fire resetting the tooltip. Which is fine when you're going down, but going back up should be a problem as no trigger will fire to reset the tooltip to the appropriate value for the previous record.

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517295 is a reply to message #517290]

Mon, 25 July 2011 04:23

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

50% sure. It works the DOWN way. /forum/fa/1606/0/

P.S. What a successful replying I have here ... the only valid statement seems to be the SET_ITEM_PROPERTY. Bravo.

[Updated on: Mon, 25 July 2011 04:26]

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517311 is a reply to message #517295]

Mon, 25 July 2011 06:23

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

I think there's a problem with my suggestion as well. I'm working from memory here, but doesn't the tooltip appear as soon as the mouse is over the item in question? In which case it'll display before when-new-item-instance fires.
In a single record block you can fix it by putting the code in when-new-record-instance, but I don't think you can make it work properly with a multi-record block.

Report message to a moderator

Re: Tool Tip Require to Display the Data [message #517320 is a reply to message #517311]

Mon, 25 July 2011 06:53

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

WHEN-NEW-ITEM-INSTACE seems to be working in a multi-record block. Though, you first have to navigate to that item, move a mouse away from it, and then move it back (over the item). That doesn't seem to be user-friendly.

However: as CVS_1984 (the OP) uses Forms 6i & if the application is a client-server based, mouse triggers work there (as opposed to 10g, where they won't work), right? If so, maybe one of WHEN-MOUSE-XXXX would do the job? I don't have Forms 6i installation, so I can't test it (which is good, as my tests are worthless).

Report message to a moderator

Previous Topic:	Oracle forms do not compile
Next Topic:	running 10g forms in firefox

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:02:00 CDT 2024