Displaying long varchar field

Classic Servoy
1

Hello,

I have a table with columns id, date, notes.

The notes field is a varchar of 2048 characters.

I am looking for a way in Servoy to display this data. I currently have it in a TableView Locked form with 3 columns of data.

Which displays the notes field for as much will fit in the column. So it gets truncated.

I want the user to be able to see all the text without have to click on it and popup and display it in a seperate control. Word Wrap onto multiple lines would be nice.

This is read only data. just history notes on talking with clients.

Any suggestions would be appreciated.

lach

Servoy 3.5.3 rel 516
MacOS X Tiger

2

Is your field a TEXT_FIELD now?
If you change the displayType-property of the field to TEXT_AREA and set the horizontal scrollbar to “never”, the text will be wrapped.

3

Hi Joas,

Thanks for the info.

With your suggestions it now word wraps the text.

But it only displays one line, I have to click into the field and hit the up and down arrows to scroll through the text.

Is there a way to have the TEXT_AREA grow vertically “as needed”?

I would like the ability to show the complete paragraph on the screen.

A side question would be can a tableview have different width rows?

THanks again.

lach

4

Hi lach,

Have you considered using tooltips for this ?

You can set your tooltip to be a formatted result of the varchar field and use HTML to add styling if needed including things like colour, font and line breaks etc

Cheers
Harry

5

Harry,

Thanks for the ideas. I have defined a tooltip based on the varchar but it will not give me the tooltip pointer when I hoover over the field in the Tableview.

Is there some magic (setting) I am missing?

Thanks

lach

6

Hi lach,

Have you checked ‘displayTags’ property ?

Cheers
Harry

7

Hi Harry,

The Tooltip works with every view except Tableview. So I can only assume it is a limitation in Servoy.

I have the displayTags property checked.

Thanks.

Lach

8

Hi Lach,

I have tooltips working on TableView forms

You may want to take a snapshot of the form properties or create a small demo solution and post it here for checking

Cheers
Harry

9

Harry,

Here is what I found.

Tooltips only work on TEXT_FIELDS. I had my field set to TEXT_AREA or HTML_AREA and I get no tooltip popup.

Thanks for the suggestion I am going to see if the users like it.

Lach

Servoy Developer
Version 3.5.4-build 517
Java version 1.5.0_13-121 (Mac OS X)

10

Hi Lach,

Maybe I just don’t use tooltips on text_area etc but I thought that this operational issue was fixed some time ago in one of the version 2.x releases :?:

Maybe I’ll do some digging around …

Good luck
Cheers
Harry

11

If this is a read-only view, why not provide it in Print Preview mode or as a pdf, and set the printSliding property for the field to “Allow height to: Grow” (turn off scrollbars)

just another idea …

re tooltips, I believe they don’t work in table-view

kazar

12

Hi Kazar,

I went with your suggestion. Everything turned out fantastic.

Thanks for the help.

Lach