I have just entered the wonderful world of Servoy and ambitiously emabarked on converting a filemaker solution after working on a few tutorials/examples. Am building an inventory system with the classic purchases to lineitems to inventory model. All works well except my number formatting in line items table keeps reverting to whole numbers not decimals ie.enter 4.1 and becomes 4. i have changed the formatting option a number of times eg. #,##0.00 but still reverts back to whole numbers! This behaviour will occur sometimes instantly sometimes only on returning to the record. I have seen this issue mentioned on the forum but couldn’t find a satisfactory solution for it. Please help as so far i have enjoyed the power of Servoy but need to resolve this before i move on.
Do numbers need to have a length specified? All mine currenlty set at 12. Using Sybase as the backend. Servoy 2.2.4
Welcome to the wonderful world of Servoy. It can be a little frustrating initially but is well worth the effort.
Is your line items field set as an Integer rather than a number? Easy to check with Tools / Designer / Dataproviders. Note you cannot change a field type/name etc in Servoy but can do this using Sybase Central - however remember to restart Servoy afterwards so that it picks up the changes.
Hi Graham. Fields previously were all numbers. I tried removing/deleting the fields and created them again with no lengths to the number field. All numbers and calcs. seem to format properly and work well now, so i assume the field length was the problem. I have only been going a few days now but am finding the basic mechanics of Servoy seem to make sense just fiddly things like this slow me down.
copy and paste between methods/examples is sensational!
I would like to make a post sometime in the future on my thoughts of Servoy after coming from a filemaker world. Might be interesting for other newbies thinking of making the change