Hello,
I am trying to insert into a field called thismonth some values.
They are things like: 21.65 and 34.75 and 56.233
When I do the insert the values in my Access 2000 database are rounded to
22, 35 and 56.
Here is my code:
$upd = $dbh->prepare( qq{update Customers set ThisMonth = ? where Company =
?} );
$upd->bind_param( 1, $gigabytesTOTAL, SQL_INTEGER);
$upd->bind_param( 2, $company);
####Execute the Update####
$upd->execute();
$upd->finish;
In my Access Database I have the Field ThisMonth set to DataType Number.
The format type is set to General Number and the decimal places I have tried
'AUTO' and then things like 4 or 7. Still it doesn't work.
Any ideas would be greatly appreciated.
Thanks,
John
