- Hans Groeneveld
- PowerBuilder
- Monday, 9 January 2023 09:25 AM UTC
Hi
Since PB22 (build 1892) we do have problems with XML export from datawindows.
We use the following function toi retrieve XML from a datawindow:
Describe('DataWindow.Data.XML')
The problem is that de decmal sign sometimes is set to a comma, instead of a point.
When that happens once, all the other exports that works fine before do also export the wrong decimal sign.
Ex. I have three datawindows with a SSQL with decimal columns in it.
When the first and second export fine( with a point as a decimal sign) and the third exports a comma as a decimal sign.
Then the second time the first and second datawindow export a comma as a decimal sign too.
It keeps getting wrrong. I have to close the application. After that de the first and second datawindow export fine again.
When I export the third datawindow right after the start of the application, all the three export a comma as a decimal sign.
It seems that something in the third datawindos does broken the XML export function.
I tried the SetCultureFormat() function. Just before the Describe:
IF lds_sub.SetCultureFormat('sDecimal=. sThousand= ') <> 1 THEN
MessageBox('SetCultureFormat lds_sub', 'error')
END IF
But that did not help. The SetCultureFormat does return a 1.
Is there a know problem with the decimal sign in the 'DataWindow.Data.XML' ?
We like to deplooy our application with the PB22 version, therefor we need a fix for this problem.
KInd RegaRDS
Hans
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.