I've got a dBase table that was created with Database Desktop that has a
field, EQUIP_NO, defined as Numeric(5,0). I use a TQuery to perform a
sort, then do a batchmove to move it over to a new table. I have the
TBatchmove.Mode set to batCopy. The resulting table has no field type
defined for EQUIP_NO.
Trying to create the table structure with an SQL statement I find that I
cannot create a field type of Float, Numeric, or Integer (i.e. the field
is created but no field type is defined) -- only Decimal or SmallInt. I
must have something set wrong in the BDE Administrator. Any ideas?

D5, BDE 5.1.0.4