We have an app that uses VFP remote views to access our Oracle DB using ODBC. If we browse one of these views that contain decimal numbers we can see the values to the right of the decimal place, but if we open this view into a workspace (or whatever you call them) i.e.

use myremoteview in 0 alias remview

and try to do anything with these decimal values then the values to the right of the place holder vanish.

So lets say my column DecCol has the value 2.345. If I do :

select remview

messagebox(DecCol)

it displays 2. If I set SET FIXED ON it shows 2.0.

To add a bit more spice, if we say that this view is updateable and we change the column value to 3.456 and save, there is no problem. It is literally just when we try and manipulate the column in any way that this occurs. The only time we can 'see' the full decimal value is in a browse window.

We have tried it on different machines, recreating the connection and views (even using gendbc). The behaviour seems consistent.

The oracle data-type is a plain old NUMBER(12,4).

Any help would be greatly appreciated.

Pablo