>Hello Tore
>This is what i want to do.
>I select data from an HP-3000 into a foxpro cursor.
>(9999.99 as vkpreis is just a dummy)
>I manipulate the foxprocursor (replace vkpreis with ....)
>I do a final select from my foxpro cursor (manipulating keys (substr(idtnr.....))
>into another foxpro cursor.
>This cursor is passed to the SAP-System later.
>
>
>I don't want want to divide by 1.2
>I tried round(vkpreis,2) with no success.
>Then i wanted to force foxpro to do some calculations to get vkpreis with 2 decimals.
>vkpreis / 1 is just a stupid dummycalculation.
>My hope was:
>round(vkpreis / 1,2) = vkpreis with 2 decimals
>no success
>
>I still do not understand why select round(xyz,2) as xyz gives me an xyz field with 4 decimals.
Round does not change the field type! To change the field type, you can use the Alter table command. Select into another field name than vkpreis, for instance vktemp. Then
Alter table yourtable add column vkPreis n(8,2)
Replace all vkpreis with vktemp
>Best regards
>Albert