Hi I'm adding a new field to a table and get this error.
The field is named truck_days, type integer. field # is 56 but that
shouldn't be a problem, I have tables with 80 or more fields working
perfectly.
System is XP Pro FB 2.0
This is a snippet from the ddl of the table.
TRUCK_MILES INTEGER,
SMTP_HOST CH40_NAME /* CH40_NAME = CHAR(40) default
'*****Not Known****' NOT NULL */,
TRUCK_DAYS INTEGER
);
There are lots of other integer fields in the same table that can be
updated with no problems, and lots of other table with integer fields
too.

When I enter a number and try to commit this is what I get.

Error Message:
----------------------------------------
Incompatible column/host variable data type.
Dynamic SQL Error.
SQL error code = -303.
conversion error from string "2-JAN-1900 1:26:24.0000".

--
Alan J Davies
Aldis