wsv01 Posted September 21, 2018 Share Posted September 21, 2018 OK, so this is most likely not a uniGUI issue, but I do not seem to have this issue with a standard VCL application. I have a MSSQL database table with a money type column. I have a uniDBEdit control wired to that money column. I have a TFDStoredProc wired to the database table. In that TFDStoredProc I have a persistent field pointing to the money column in the TFDStoredProc. In that persistent field, I have a DisplayFormat of $###,###.00. When I enter a dollar amount in the field on the screen of say 25000.44, the display format takes over and shows $25,000.44. When I try to save the data, I get an error stating $25,000.44 is not a valid floating point value for field xxx. Of course this is because of the "$" and the "," in the display format. How do I get those out of there before the post actually takes place or what properties do I set to resolve this? For whatever reason, I do not seem to have this issue in standard VCL applications. I has to be something quite easy to fix because I cannot seem to find any relevant info about it on the web. I tried a whole bunch of things with no success. Quote Link to comment Share on other sites More sharing options...
GerhardV Posted September 21, 2018 Share Posted September 21, 2018 Use a TUniDBFormattedNumberEdit instead and set the FormattedInput property. Quote Link to comment Share on other sites More sharing options...
wsv01 Posted September 21, 2018 Author Share Posted September 21, 2018 So simple! Thanks so much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.