Convert DBF Clipper to DB Paradox

[BagaMash]

I need help in a conversion of DBF tables for DB Paradox.
My just problem is a conversion of (N)umeric values with more than 2 decimals.

I.E.:

Clipper: Field,Type,Witdh,Decs
ENTNUM,N,10,4

DataBase Desktop 7 convert to:
Paradox7: ENTNUM,N,10,2

Anybody help me? hehe

Tanks.... and sorry for very bad english, I am brazilian guy.

 

[svanels]

Opening the table with the Database Desktop and saving as a paradox file does not make the conversion? S. van Els
SAvanEls@cq-link.sr

 

[Guest_imported]

Paradox it is a local database. Isn't it?
Why don't you use interbase (it is free) and client/server!
goto borland website and download interbase.
You can use "double precision".

Double precision can have:

16 integer
15 integer and 1 decimal
14 integer and 2 decimals
13 integer and 3 decimals
12 integer and 4 decimals
11 integer and 5 decimals
10 integer and 6 decimals
9 integer and 7 decimals
...

Interbase is a good database (free and client/server).
Borland also have a comercial certificated version.

Go and see.
And good work

 

[BagaMash]

Tnks for help... but don't work.

I need convertion of 4 decimals DBF for 4 decilmals DB....

And DataBase Desktop round to 2 decimals....

 

[TonHu]

Well, then ditch Database Desktop...for conversion
As a programmer you should be able to do it for yourself. I'll outline the steps to make it easier.
- Get VKDBF package from Torry
- Create the Paradox table
- Compile & install VKdbf into D5/D6
- Put it on a form and also a Paradox DB
- Use some for/next loop to get all the data from A to B
- Voila...

This is p-code ofcourse!

HTH
TonHu

 

[EricDraven]

You could have already done what you set out to do with the Database desktop. The DD automatically rounds fields to two decimal places but stores the actual figure. Place the dd into edit mode, select the field and press F2 to see the actual figure. I know the paradox 7 tables only show two decimal places but actually store the amount you enter!

 

[BagaMash]

It's right EricDraven...

I used DD only for conversion and don't edit.

Well, that's ok....
[]'s