International Problem (decimal point issue with OLE DB Provider)
From: Stewart McGuire (sNmOcSgPuAiMre_at_pirnie.com)
Date: Thu, 25 Mar 2004 16:47:56 -0500
I have an application that will be used internationally. I don't have to
worry about different langauages because the company that will be using it
standardizes on English for their business. However, they DO use the local
standards for numeric display, dates, etc.
My problem is this:
I have floating point numbers stored in my DBF files.
Apparently Visual FoxPro uses a period internally to represent decimals.
Visual FoxPro has no problem displaying and working with that.
I also have a modeling engine written in Visual C++ that uses ADO to read
the data in, do calculations on it and write it back out.
ADO is looking for a comma, in the case of Dutch (Holland). So a number
that is stored as 3.14159 in the database is read in as 3.0 as the period is
not interpreted as the decimal point.
How do I get ADO to interpret the decimal point correctly when the
application is run with a locale that does NOT use a period for the decimal
Is there a way to tell ADO to use a period (without having to manually
change the locale information)?
Or is there a way to tell the Visual FoxPro OLE DB Provider what the correct
decimal point character is so it interprets the numbers correctly? I found
the "SET POINT TO" command in Visual FoxPro but found a page in the online
help that says that command is not supported in the OLE DB provider.
Any information would be extremely helpful!
Malcolm Pirnie, Inc.