Atozed Forums
IWDBEdit with currency formatting STILL NOT WORKING - Printable Version

+- Atozed Forums (https://www.atozed.com/forums)
+-- Forum: Atozed Software Products (https://www.atozed.com/forums/forum-1.html)
+--- Forum: IntraWeb (https://www.atozed.com/forums/forum-3.html)
+---- Forum: English (https://www.atozed.com/forums/forum-16.html)
+----- Forum: IntraWeb General Discussion (https://www.atozed.com/forums/forum-4.html)
+----- Thread: IWDBEdit with currency formatting STILL NOT WORKING (/thread-2310.html)

IWDBEdit with currency formatting STILL NOT WORKING - commusic - 03-03-2021

Hi there,

I'm trying to configure an IWDBEdit to display the input as a monetary value. Can anybody point me to some sample code, please?


More info:
Running C++ Builder with IW15.2.18.
IWDBEdit is using an ADOConnection.
The DB field is of type currency, of course.
WebApplication->RegionalSettings are set correctly.
Couldn't find anything on GitHub.


Thanks in advance,
Joe

RE: IWDBEdit with currency formatting - Alexandre Machado - 03-05-2021

This demo has an extensive example of using IWEdits for all numeric inputs

https://github.com/Atozed/IntraWeb/tree/master/15/Delphi/NewInputTypes

RE: IWDBEdit with currency formatting - commusic - 03-08-2021

(03-05-2021, 11:33 PM)Alexandre Machado Wrote: This demo has an extensive example of using IWEdits for all numeric inputs

https://github.com/Atozed/IntraWeb/tree/master/15/Delphi/NewInputTypes

Thanks. I was thinking more of examples of DataTypeOptions.Pattern, but if that isn't needed: great.

Unfortunately, I can't input ¢ this way - even if I set FloatDP = 2 or Step = 0.01 or both (or Step = 0,01).

The decimal separator ',' is ignored during input, though it is set correctly in WebApplication->RegionalSettings.DecimalSeparator.

If I use '.' instead, type 715.95 and leave the IWDBEdit, it is changed to 715.95,00 €. After loading the DataSet it's displayed as 71595,00€.

If a value like this 715,95 € is in the database, the IWDBEdit stays blank. On a post the field is emptied.

Switching the System's Settings to English (Great Britain), doesn't help, either. Nothing smaller than £1 can be entered.

RE: IWDBEdit with currency formatting - Lorbass - 03-12-2021

I have the same problem.

It seems that regional settings are not taken correctly.

RE: IWDBEdit with currency formatting - commusic - 03-22-2021

It's still not possible to input currency values correctly.
What's your status on this problem?

This is the result from input
1111.22

[Image: IWDBEdit_Currency.png]

The correct decimal seperator ',' is ignored.



Best regards,
Joe