Servoy 3.0 Release Candidate 4

We announce the immediate availability of Servoy 3.0 Release Candidate 4

NOTE: this is PRE-RELEASE SOFTWARE, use with caution and make BACKUPS before you start.

This version is available through auto update and download page on Servoy website (developer section)

Changes:
[chg]-for oracle driver issue
[enh]-many webclient html output improvements
[enh]-sample code on JSDataset
[enh]-db password encription in property file
[fix]-security.deleteGroup(groupName)
[fix]-problem defining users from servoy-admin page
[fix]-onDataChange fired multiple times when autoSave disabled
[fix]-servoy relations will not longer join if a column-key value is NULL (to behave exactly like db relations)
[fix]-fixed relation use in combination with tableFilter
[fix]-cascading valuelists not populating in webclient

Previous releases:
http://forum.servoy.com/viewtopic.php?t=6935

I am getting the above message since RC1.

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Table ‘servoy_root_elements’ already exists

Did I bugger up my repository?

MySQL 4.1.12
and
MySQL 5.0.24
latest mysql-connector[/quote]

It seems to us the repository upgrade did not finish the first time, and it retries every time you start, best is to start over from a db backup before rc1.

thertzler:
I am getting the above message since RC1.

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Table ‘servoy_root_elements’ already exists

Did I bugger up my repository?

I had this when I upgraded from 2.2.5 to 3rcX. I solved this be exporting the solution from v2 then creating a new repository in v3 and then importing the solution.

Hi,

When in the Servoy Calculation Editor, if you click on the Application - Relation node once, it doesn’t gain focus, like all other nodes do.

When you click twice, it does gain focus, but the Outline keeps displaying the details of the previously selected node.

Paul

Great job this new release, Servoyians!

A few comments:

  • Fontsize from HTML, displayed in a label on a tabelview list, increases to very large size.
    At displaying the tableview list the first time, the fontsize is fine, but when I browse back to the same list, fontsize is very large.

  • How do I get rid of the horizontal scrollbar when I show a tableview list in a tabpanel? Even when the formsize of th elist is smaller then the tabpanel size AND I turn off horizontal scrolling on the form, the scrollbar still appears.

freecolours:

  • How do I get rid of the horizontal scrollbar when I show a tableview list in a tabpanel? Even when the formsize of th elist is smaller then the tabpanel size AND I turn off horizontal scrolling on the form, the scrollbar still appears.

Forget this one, got it fixed allready :roll:

freecolours:

  • Fontsize from HTML, displayed in a label on a tabelview list, increases to very large size.
    At displaying the tableview list the first time, the fontsize is fine, but when I browse back to the same list, fontsize is very large.

I found out that this happens when you don’t select a fontType to the tabpanel where the tableview list is called from.
Could this be fixed?

if you don’t select a font you get the default font (which depends on your LAF settings)

Jan Blok:
if you don’t select a font you get the default font (which depends on your LAF settings)

I would thought so too, but that doesn’t happen.
BTW: it nly happens in the Developer, not in the Web Client.

Servoy Developer
Version 3.0rc4-build 368
Java version 1.5.0_06-64 (Mac OS X)

I don’t this if this is a bug in the web client or a problem on my end, but I’m having a couple of minor display issues:
http://www.entropysolutions.net/test/se … 060908.jpg

  1. The text inside a typical text field isn’t vertically centered as expected. This happens only on Windows. In my stylesheet I have the following margin statement: 0 3px. Making it “0” had no effect.

  2. How can I push down the text of the radio buttons so it looks more even?

Hello,

In the tab sequence editor, after selecting an element(s), would it be possible to double-click it to move it to the other column?

A few more:

  1. In the Define Parts dialog, double-clicking a part adds it to the list on the right, but once it’s added, I can’t double-click it to remove it.

  2. I ran into a problem with tooltips and html areas. I found this thread: http://forum.servoy.com/viewtopic.php?t=2055 , but my problem is a little different. Setting the tooltip works OK, but getting it does not. I always get null. If I change the field display to image_media, I can get the tooltip just fine. It doesn’t matter if the tooltip contains HTML.

  3. In the smart client, when a user clicks on a button to submit/save a form, I display an icon to alert the user that there was a validation error. The icon is stored in a global dataprovider with a display type of html_area, and is filled in dynamically.

When I display the same form on the web, the icon doesn’t get displayed. Instead I get that broken image icon. I looked at the HTML source, and copied the SRC attribute into the browser (http://IP:8080/servoy-webclient/resourc … y/media?...), and the image displayed just fine, so is this is a bug, or a problem on my end?

  1. Do tooltips carry over to the webclient?

  2. It looks like you can tab to buttons in the smart client, but can’t hit the Enter key to trigger the method attached to it. Is this the expected behavior, or is it a problem w/Macs? It would make data entry a little bit easier if this feature were available.

  3. The selectOnEnter property has no effect on Macs. Can this issue be resolved, or is this a problem w/Macs?

On the Admin pages, the tooltip for commit/rollback of a specific trasnaction for one client says something like “Commit/Rollback all transactions on this server”. I assume this tooltip is incorrect?

Paul

The sample code of says the following:

//Get the edited records outstanding for a save
var array = databaseManager.getEditedRecords()
for( var i = 0 ; i < array.length ; i++ )
{
	var record = array[i];
	//use for example databaseManager.getChangedRecordData(record) here;
}

But, the described loop doesn’t work on the object databaseManager.getEditedRecords() returns. The code below does work:

var recs = databaseManager.getEditedRecords()
for ( i in recs)
{
	var record = recs[i];
	//use for example databaseManager.getChangedRecordData
}

Paul

Have a couple of issues/questions about databaseManager.getEditedRecords() and databaseManager.getChangedRecordData:

  • If you change a value on a record, but then change it back to the old value, then databaseManager.getEditedRecords() will return an edited record, but if you lookup the changed data (databaseManager.getChangedRecordData), it will contain nothing. Is it correct that databaseManager.getEditedRecords() returns a record that in effect holds no changes?

  • I have a main form (A) based on table user. On this form, I have a relationless tabpanel with a form (B) based on table profiles. Form B shows all profiles with a checkbox besides it. The checkbox contains an onDataChange method, that will insert a record into or remove a record from the user-profile table (I have a form user-profile based on this user-profile table, through which I do the delete/insert). This way I link users to profiles. Now I notice the following behavior:
    1: When a record gets added to the User-Profile table, databaseManager.getEditedRecords() returns no records, not even if the User table has changes as well.
    2: When I get the details of the altered records, it looks like I inserted/removed records into/from the Profiles table, where that did not happen: Records were added/removed into/from the User-Profile table

Paul

I’m trying to add a filter to a table using databasemanager.addTableFilterParam, but whatever syntax I try, no filter is added.

Can it be that this functionality is broken in the latest build?

Paul

In IE and FF when you click into a Type Ahead type of field with a valuelist attached, the dropdown is not displayed. Once you start typing, it will display whatever values are still matching. When you remove whatever you have typed, only hten all values from the valuelist are shown.

I’d expect the dropdown to be shown once the field receives focus.

Can this be fixed, or is it browser behavior and something we have to live with?

Paul

And the selected row in the Type Ahead dropdown is yellow… Can this be made the same as the selected row in the dropdown of a ComboBox, so some shade of blue? All default colors are shades of white, blue and grey, so the yellow sticks out…

Paul

Sorry to keep adding posts… but:
In FF, the dropdown with values from the valuelist on a type ahead field issometimes replaced by another popup that holds values that the browser hints. I guess they are previously types values in any field. You get the same popup when you doubleclick in a normal textfield.

It happens when you type something into the typeahead field, then remove the typed text, so the full valuelist showns in the dropdown and then you press the arrow down key, to browse through the dropdownlist.

Paul