Sql alter table

1

Hi,

I am using the ALTER TABLE function to add a new colomn to my table in MS Access.
I have absolutely no trouble with:

$sql = “ALTER TABLE downloads ADD “.$file_x.” varchar(3)”;

But this new column has a text datatype. I need one that only takes numerical values. I have tried:

$sql = “ALTER TABLE downloads ADD “.$file_x.” int(3)”;
$sql = “ALTER TABLE downloads ADD “.$file_x.” integer(3)”;
$sql = “ALTER TABLE downloads ADD “.$file_x.” numeric(3,0)”;

but with no effect.

Any ideas?