[pilot-db-list] (no subject)

[Peter T. <pe...@un...>]

<mar...@la...> wrote:
>Have you try to cast the result as integer???
Yes, I have. I only get 10 digits that has nothing to do with the result:
(sort 0 1 )(int (+ %2 (ffr 3 -1 0 )))
Am I doing something wrong?

This works but displays decimals.
(sort 0 1 )(+ %2 (ffr 3 -1 0 ))
Field 2 is an integer field.

Do you have any solution for this?

/Peter


>> I think DB looks great. The only problem I have is that
>calculated fields 
>> using sort and ffs (I think), always shows decimals even if
>all fields are 
>> integer fields. Even the example with accumulated loan comes
>up with 
>> decimals. This alone makes DB pretty useless. Who wants to
>fill the screen 
>> with empty decimals?
>> Can you fix this?
>> 
>> /Peter Thorstenson