XBase and my problem with Float?

[Adam Frielink]

Using DBI::Xbase, I to store floating point numbers in a specific database.
Unfortunately, all my decimals have been dropped.

I have tried a few renditions of the CREATE TABLE command.

$createtable = "CREATE TABLE $AccessTable (Group1 CHAR(50), CP FLOAT, LY
FLOAT)";
$createtable = "CREATE TABLE $AccessTable (Group1 CHAR(50), CP FLOAT(4,16),
LY FLOAT(4,16))";

Right now I am using INT and programatically handling the decimal points...
(multiply by 10000 at writing and dividing by 10000 when reading)

So, what am I doing wrong?

Any help is appreciated.


Thanks,

Adam Frielink
Tyco Plastics