Hi at all,
I have the follow situation:
- a number field named “qty” (numeric 9,2)
- a form in tableview mode with an object field with dataprovider qty-table-field
Now I want to show only the integer part of the number but when the user edit the cell must be able to input the decimal part also.
Then I put a format on the object-field like this:“##|##.##” all work fine.
[attachment=0]situation fine.JPG[/attachment]
In add I want add a conversion on the qty-table-field (topic at:http://www.servoy.com/forum/viewtopic.php?f=2&t=13523&p=69987#p69987) so when I put a special char I want return a fixed number ( so for ex:insert “t” into the cell and return -123 into the db).
Now the problem can be that the “#” into the format prevent my char insert.
So I have try to use a simple situation:
[attachment=2]situation.JPG[/attachment]
The result is this:
[attachment=1]situation 2.JPG[/attachment]
- when null the client put “##” char
- if I try to edit a cell I can’t put decimal part
- sometime some record disappear
At the end if I use only the format all work fine,if I use only the conversion to perform some action all work fine.
If I use both format and conversion something wrong.
The last observation is: If I put an “application.output” both input and output conversion-function than I can see that are called like this:
input
output
output
output
input
output
output
or similar way.
Thanks for the attention
Marco
P.s. I use servoy 5.0.1 with winXp.
All the test are done with both solutionModel form and environment form
