🚀 go-pugleaf

Alain Baillard wrote:

> Hi,
>
> I am trying to access an Interbase Table using SQL Links (2.5) from
> vdbase
> 5.6 ......no problems...but...there are numeric fields in an Interbase
>
> table stored in NUMBER (9,2). In vdbase this shows as LONG 4 with -2
> as
> Decimals and values which for example in Interbase show as 4.52 show
> as 4
> in vdbase.......I have this nasty feeling there is no way around, but
> I
> could be wrong (yet again).
>
> Hope someone can help....Thanks.....Alain

   I am having similar problems just trying to write a simple querry for
a dBASE database (.dbf)  My select statement says:
SELECT ANNTY_EE + ANNTY_EARN TOT_ANNUITY FROM PAYROLL

When I run this querry, however, Visual dBASE truncates to zero decimals
in the resulting field TOT_ANNUITY even though the ANNTY_EE and
ANNTY_EARN fields are numeric fields with 2 decimals.....

How can we get proper querries now that QBE has been cut??????????