Scrollbars and a single clob [message #602000] |
Thu, 28 November 2013 08:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/86d9b1f57e461d571279f47711f3699f?s=64&d=mm&r=g) |
philquinn
Messages: 6 Registered: November 2013
|
Junior Member |
|
|
Hi,
I'm a Business Analyst trying to help a colleague out.
We have a form which displays the contents of one single CLOB. If the CLOB contains a lot of text, then a scrollbar allows scrolling through the text.
Problem is, when we invoke the form, the scrollbar is always at the bottom of the text,i.e., the end of the contents of the CLOB.
Is there a way to force the scrollbar to the top, thus displaying the 'start' of the contents of the CLOB?
Many thanks.
Phil.
|
|
|
|
Re: Scrollbars and a single clob [message #602002 is a reply to message #602001] |
Thu, 28 November 2013 09:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/86d9b1f57e461d571279f47711f3699f?s=64&d=mm&r=g) |
philquinn
Messages: 6 Registered: November 2013
|
Junior Member |
|
|
We have a table of notes against an entity (mortgage)
Each row has a unique ID and a CLOB
When we display all the notes for a mortgage, we concatenate all the clobs into one single clob and display that.
We don't display the individual CLOBS as we end up with multiple mini scroll bars per row, which looks terrible
[Updated on: Thu, 28 November 2013 09:27] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: Scrollbars and a single clob [message #602336 is a reply to message #602238] |
Tue, 03 December 2013 04:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Could you create a stored (database) function which would do that "concatenation" job, and then - in a POST-QUERY trigger - fetch function's value into a form item? (I'm not saying that it would solve your problem, though; I just don't have any other ideas).
|
|
|