I have a table in 6.5++ named RETURNS that when I unload and reload gives
an error and won't create it in the reloaded database?  I renamed it to
RetnOrds and got the same error?  Thoughts?

Here is unload of the table
CREATE TABLE `returns`  +
(`operator` INTEGER  ,  +
 `order#` REAL     ,  +
 `ptiprt#` TEXT    (12) ,  +
 `proddate` DATE     ,  +
 `shift` INTEGER  ,  +
 `machine` INTEGER  ,  +
 `label#` INTEGER  ,  +
 `qtyinbox` INTEGER  ,  +
 `boxcompl` TEXT    (1) ,  +
 `pallet#` INTEGER  ,  +
 `pltcompl` TEXT    (1) ,  +
 `ordcompl` TEXT    (1) ,  +
 `entrdate` DATE     ,  +
 `entrtime` TIME     ,  +
 `prntstat` TEXT    (1) DEFAULT ""Y"" ,  +
 `jobpstrf` DATE     ,  +
 `prdpstrf` DATE     ,  +
 `priorqty` INTEGER  ,  +
 `ship` TEXT    (1) ,  +
 `shfcompl` TEXT    (1) ,  +
 `opid` TEXT    (4) )

Ron

Reply via email to