Hi,
I have a DW, where in one of the column is string, with editmask ####.00
When I'm setting a value in DW like 1234.56, insert into database lookis like '123456' , and i would like to looks like 1234.56.
I've tried GetItemFormattedString, and something hardcoded like string(dw.getitemstring,'####.00') but nothing works.
Is this even possible to get value with mask?
Oracle 12c, PB 2017 R3 build 1858
Hi Michael ... Modified suggestion ....
IF String (DWO.Name) = "DecColumn" THEN
IF POS (Data, ".", 1) = 0 THEN
THIS.Post ue_set data ( DWO.Name , Data)
END IF
// In ue_set_data .(Args as_name and as_data) ...
IF Lower(as_name) = "deccolumn" THEN
IF POS (as_data, ".", 1) = 0 THEN
String ls_data
ls_data = String ( as_data, "#.00") // OR you could sub-string it ;-)
THIS.SetItem ( ls_name, ls_data )
END IF
Food for thought. HTH
Regards ... Chris