Not a valid floating point value error on post

[wsv01]

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.

[GerhardV]

Use a TUniDBFormattedNumberEdit instead and set the FormattedInput property.

[wsv01]

So simple!  Thanks so much!