Add decimals to an existing numeric field

[José Luis Sánchez]

Hello,
I've a dbf with a numeric field without decimals. I would change the field adding 2 decimals, but I don't know. When I hace to change the structure of a DBF I create a nuew structure with dbcreate and then append the data from the old dbf. Doing this with character fields doesn't give an error, but if I do this with numeric field adding decimals it give me an error.

I use EMAGdbu from Enrico and this program changes the size of the numeric fields without problems, but I don't know how to do this in my programs.

Regards,
José Luis

[lucasdebeltran]

Hi,

Please, have a took at Fivedbu sources, there is such routine.

[Armando]

Jose Luis:

Perhaps the problem is the field's size, remember, you will need a field size + 3, for sample:

If your field has a lenght 7 with no decimals (7,0), (1234567) when you add the decimals
you need a field with leght 10 with 2 decimals, 1234567.89

Regards

[José Luis Sánchez]

I have downloaded the latest public fivedbu sources from code.google. The routine in fivedbu sources is the same I use, and gives the same error when you change a numerical field with 2 integer positions - numeric (2,0) - to another with 2 integer positions and 2 decimals - numeric (5,2) -.

Any help, please ?

Regards,