# Servoy 3.5.9

**URL:** <https://forum.servoy.com/t/servoy-3-5-9/10456>\
**Category:** Classic Servoy\
**Created:** [March 20, 2009, 2:44pm UTC](https://forum.servoy.com/t/servoy-3-5-9/10456 "2009-03-20T14:44:48Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [March 20, 2009, 2:44pm UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/1 "2009-03-20T14:44:48Z")

</div>

We are pleased announce the immediate availability of Servoy 3.5.9

Make a backup of your current Servoy installation (directory and database) before installing.

This version will be available shortly through auto update for users of 3.5 versions (check via help menu → check for new version)

Changes:  
[enh] HTTP Tunnel SSL support  
[fix] case 123350 Image Alignment in printing  
[fix] case 198427 Servoy removes records on dbmg.rollbackEditedRecords(…)  
[fix] case 195122 Open form in dialog for the second time exits find mode.  
[fix] case 136597 WC: logging out from within a FID and showing a different URL afterwards  
[fix] case 185710 Turkish language, db column , dataprovider problem  
[fix] case 187321 StackError using .setChildSortDataprovider() on DbTreeView  
[fix] case 187416 broken media fields display in web client  
[fix] case 190951 strange behavior on form in dialog  
[fix] case 190986 form in dialog and currentcontroller issue  
[fix] case 198474 Webclient: button is not working properly  
[fix] case 185751 Servoy prints in low resolution only  
[fix] case 50698 requestFocus(false) doesn’t work properly  
[fix] case 80394 Webclient: Forms with a navigator show unwanted scrollbars  
[fix] case 97673 Null Validation error  
[fix] case 154845 Attaching onRecordEditStart method on ListView requires extra click  
[fix] case 169751 ComboBox Issue, list scrolldown, does list close  
[fix] case 190189 margin in styles not working right in table-view  
[fix] case 195129 Webclient problem with find (related \> unrelated tab, switching while in find)  
[fix] case 199556 showRecord, does not take over the currentSelectedIndex in some situations  
[fix] case 168412 datefields in webclient does not respect fontsize in style

Previous release  
[viewtopic.php?f=16&t=11915](http://www.servoy.com/forum/viewtopic.php?f=16&t=11915)

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 20, 2009, 3:08pm UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/2 "2009-03-20T15:08:56Z")

</div>

I’m missing the following:

case update (SVA:195553), DBTreeview doesn’t show correct font in webclient

And also

case 189002 databaseManager.getChangedRecordData() gives wrong result

Which is very important. It gives wrong data in the database

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [March 20, 2009, 3:41pm UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/3 "2009-03-20T15:41:36Z")

</div>

You are correct, those where reported and fixed against 4.x versions (and merge back a significant time later)

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 9:36am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/4 "2009-03-23T09:36:32Z")

</div>

I see change in dbtreeview setChildSortDataprovider

[fix] case 187321 StackError using .setChildSortDataprovider() on DbTreeView

There was an error in 3.5.7  
That was fixed in 3.5.8  
But now the sort order has changed again, so it looks like the 3.5.7 behavior is back again

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 9:40am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/5 "2009-03-23T09:40:53Z")

</div>

Tableview changes

I see a difference in tableviews between version 3.5.8 and 3.5.9  
See the screenshots

3.5.8:

[attachment=2]tableview358.JPG[/attachment]

3.5.9:

[attachment=1]tableview359.JPG[/attachment]

And when I click a field in the tableview, then the articledescription is readable again:

[attachment=0]tableview359Click.JPG[/attachment]

What causes this situation?

Martin

 ![tableview359Click.JPG](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/1X/04d3f22c51f4805fa8147de6dfeaff794f566474.jpeg)

 ![tableview359.JPG](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/f/f029182ed95033a04767f38c3da10bf9fd0915f5.jpeg)

 ![tableview358.JPG](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/1X/3acb2a7cea0d7588037316ba633306f332468bbe.jpeg)

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [March 23, 2009, 9:43am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/6 "2009-03-23T09:43:28Z")

</div>

martin

is this web or smart?

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 9:52am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/7 "2009-03-23T09:52:03Z")

</div>

Smart client

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [March 23, 2009, 9:57am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/8 "2009-03-23T09:57:44Z")

</div>

it looks like you have an extra border around it.  
What exactly did you configure in the properties or style?

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 10:11am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/9 "2009-03-23T10:11:55Z")

</div>

I made some additional checks.  
Changing L&F doesn’t change anything, so it has nothing to do witg L&F

The field properties have bordertype DEFAULT

The stylesheet properties for fields are:

field  
{  
background-color:#FFFFFF;  
border-style: inset;  
border-width: 0px 0px 0px 0px;  
border-color: #999999 #ffffff #ffffff #999999;  
font-family: Arial;  
font-size: 11pt;  
color: #000000;  
text-align: left;  
vertical-align: top;  
font-weight: normal;  
}

This articledescription you see on the screenshots, is a label, because it contains %%…%%. The stylesheet properties for this label are:

label.field  
{  
background-color:#FFFFFF;  
border-style: inset;  
border-width: 0px 0px 0px 0px;  
border-color: #999999 #ffffff #ffffff #999999;  
font-family: Arial;  
font-size: 11pt;  
color: #000000;  
text-align: left;  
vertical-align: top;  
font-weight: normal;  
}

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [March 23, 2009, 10:26am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/10 "2009-03-23T10:26:25Z")

</div>

i think you are seeing the results of this fix:

[fix] case 190189 margin in styles not working right in table-view

please also add the nargin property to your css, something like:

margin: 0,0,0,0

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 10:30am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/11 "2009-03-23T10:30:54Z")

</div>

You are correct Johan,

Now the form shows again like it should be.

Thanks

Martin

---

<div class="post-metadata">

**Author:** ![Gabi\_Boros](https://avatars.discourse-cdn.com/v4/letter/g/73ab20/32.png) [@Gabi\_Boros](https://forum.servoy.com/u/Gabi_Boros)\
**Post date:** [March 23, 2009, 10:36am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/12 "2009-03-23T10:36:34Z")

</div>

please note that using setChildSortDataprovider, you specify the sorting for the children of a node,  
and therefor if you want the root nodes to be sorted, you need to sort the root foundset, before adding it to the tree;  
also, note that the child sort dataprovider should be in the left table of a relation

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 10:40am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/13 "2009-03-23T10:40:48Z")

</div>

Only fieldtype HTML-area, do not show correct way. When I make it a TEXT-field, then that border is gone  
How can I avoid this extra border when HTML area in tableview?

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 10:43am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/14 "2009-03-23T10:43:18Z")

</div>

> Gabi Boros:  
> please note that using setChildSortDataprovider, you specify the sorting for the children of a node,  
> and therefor if you want the root nodes to be sorted, you need to sort the root foundset, before adding it to the tree;  
> also, note that the child sort dataprovider should be in the left table of a relation

I know. It worked correctly in 3.5.8. There was a fix from 3.5.7 to 3.5.8 and it looks like this fix is gone.  
And I see the problem in the childnodes

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [March 23, 2009, 10:49am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/15 "2009-03-23T10:49:26Z")

</div>

> martinh:  
> Only fieldtype HTML-area, do not show correct way. When I make it a TEXT-field, then that border is gone  
> How can I avoid this extra border when HTML area in tableview?

this seems to be a issue, can you create a case for this?  
I think TextArea and HtmlArea are both a problem now.

---

<div class="post-metadata">

**Author:** ![drookwood](https://avatars.discourse-cdn.com/v4/letter/d/ecae2f/32.png) [@drookwood](https://forum.servoy.com/u/drookwood)\
**Post date:** [March 23, 2009, 10:54am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/16 "2009-03-23T10:54:17Z")

</div>

I am seeing similar issues with borders / margins on fields in table view, and I do specify margins as well in the CSS. It appears that every field has an extra 1 pixel margin or border applied which disappears when you click on the field itself. HTML areas in table view also behave differently to fields - where the CSS is set to “border-width: 0px 0px 1px 1px;” the area is actually displaying with 2 pixel width borders where specified instead of 1 pixel width borders - until you click on the area itself, then it correctly shows only 1 pixel. Normal fields are not similarly affected - if I specify the border as “border-width: 0px 0px 1px 1px;” then that is what is displayed BUT there then appear to be extra margins added which again disappear when you click on the field.

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 11:01am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/17 "2009-03-23T11:01:12Z")

</div>

Case 199988 was added

---

<div class="post-metadata">

**Author:** ![Gabi\_Boros](https://avatars.discourse-cdn.com/v4/letter/g/73ab20/32.png) [@Gabi\_Boros](https://forum.servoy.com/u/Gabi_Boros)\
**Post date:** [March 23, 2009, 11:16am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/18 "2009-03-23T11:16:35Z")

</div>

> martinh:
> 
> > Gabi Boros:  
> > please note that using setChildSortDataprovider, you specify the sorting for the children of a node,  
> > and therefor if you want the root nodes to be sorted, you need to sort the root foundset, before adding it to the tree;  
> > also, note that the child sort dataprovider should be in the left table of a relation
> 
> I know. It worked correctly in 3.5.8. There was a fix from 3.5.7 to 3.5.8 and it looks like this fix is gone.  
> And I see the problem in the childnodes

can you post the code where you are building the binding, with the child sort provider & the return of the child sort provider ?

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [March 23, 2009, 11:24am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/19 "2009-03-23T11:24:23Z")

</div>

var \_binding = elements.dbtreeview.createBinding(‘globis\_framework’, ‘sec\_user\_menu’)

\_binding.setChildSortDataprovider(‘treeview\_sortorder’) ;  
\_binding.setNRelationName(‘sec\_user\_menu\_to\_sec\_user\_menu$parent\_menu\_id’)

treeview\_sortorder calculation:  
return ‘parent\_menu\_id asc, menuitem\_sequence asc’;

---

<div class="post-metadata">

**Author:** ![Gabi\_Boros](https://avatars.discourse-cdn.com/v4/letter/g/73ab20/32.png) [@Gabi\_Boros](https://forum.servoy.com/u/Gabi_Boros)\
**Post date:** [March 23, 2009, 11:38am UTC](https://forum.servoy.com/t/servoy-3-5-9/10456/20 "2009-03-23T11:38:16Z")

</div>

> martinh:  
> var \_binding = elements.dbtreeview.createBinding(‘globis\_framework’, ‘sec\_user\_menu’)
> 
> \_binding.setChildSortDataprovider(‘treeview\_sortorder’) ;  
> \_binding.setNRelationName(‘sec\_user\_menu\_to\_sec\_user\_menu$parent\_menu\_id’)
> 
> treeview\_sortorder calculation:  
> return ‘parent\_menu\_id asc, menuitem\_sequence asc’;

the bug is that only the first sort is applied from the sortorder;  
can you fill in a case for this ?

[Next page](https://forum.servoy.com/t/servoy-3-5-9/10456.md?page=2)
