pass thru float rounding issue 1

[baltman]

I'm connected to a MS SQL Server database via a DSNless connection string and pulling out data using a FoxPro front end. I'm having an issue with float fields. No matter what is stored I only get back 2 decimals. I have a work around of multiplying within the query and dividing back with the data once it is local, but surely there is a better way. Could this be a SQL database configuration issue? Or perhaps a SQL Server driver issue? The driver on the local machine is dated 2003. I've also seen this behavior with MS Access.

I'd really appreciate any help.

Thanks,
Brian

 

[SQLDenis]

try converting to decimal while selecting

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[baltman]

Just the nudge I needed. I had noticed the convert command but didn't know what to do with it.

Thanks,
Brian