Unfortunately, if the user has the machine set up to use CHR(160) as the 1000 separator as the default on their machine, that's exactly what VFP will use (that's what SET SYSFORMATS does). You'll have to SEt SYSFORMATS OFF and thwn use SET SEPARATOR and SET DECIMAL (as well as SET DATE etc).
Cheers,
Andrew
>Setting language to French (standard) using Windows Regional settings change the 'Digit grouping symbol' to a white space character, ASCII 160, instead of space, ASCII 32.
>
>With SET SYSFORMATS ON, Visual FoxPro uses ASCII 160 as 1000 separator. In reports this separator for numeric values is not shown as a white space but as accent a character.
>
>Any workaround, how to get a white space as 1000 separator with Windows Regional Setting for French?
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.