Truncating of numerical fields

[Jason Raikes]

I am using UCanAccess v4.0.2. I have a view in the Access database where one of the fields is double datatype. However, when I access the data through UCanAccess, the numbers are rounded down. Any clues would be welcome please.

[Gord Thompson]

You'll need to be more specific. Please provide a Minimum, Complete, and Verifiable example. The simplest test case works for me:

UCanAccess>SELECT * FROM dblTable;
-------------------
| id | txt | dbl |
-------------------

| 1 | pi | 3.141592653589793 |

UCanAccess>SELECT * FROM dblView;
-------------------
| ID | TXT | DBL |
-------------------

| 1 | pi | 3.141592653589793 |