Hi,
We mostly SPT and remote views to access our data from the SQL server. We are getting this problem browsing the numeric fields in the result of an SQLEXEC call. If the record has a value in the thousands, the value changes so that it completely ignores anything to the right of the comma (thousand separator) i.e. 11,345.67 becomes 11.0000.
Here is a sample of the code we use:
lcCommand = "SELECT TOP 100 PERCENT dbo.LnItem.InvQty, dbo.LnItem.Price, " ;
+ "dbo.LnItem.InvQty * dbo.LnItem.Price AS ItemTotal " ;
+ "FROM dbo.Item "
SQLEXEC(nMySQLConnect, lcCommand)
Has anyone encountered this before? Is there a setting in the SQL server side or the VFP side that I am missing? I tried it on two different PCs connected to the same SQL server with the same results. We are using SQL 2000 and VFP7.
Any help is greatly appreciated.
Thanks,
Arriyel