At 12:45 PM 1/4/2014, Ronald C Peterson wrote:
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,
Take the extra double quotes out of the PrnStat DEFAULT column value.
Or, simply follow the following syntax:
-- Example:
SET ERROR MESSAGE 2038 OFF
DROP TABLE RetnOrds
SET ERROR MESSAGE 2038 ON
CREATE TABLE `RetnOrds` +
(`Operator` INTEGER , +
`Order#` REAL , +
`PTIPrt#` TEXT (12) , +
`ProdDate` DATE , +
`Shift` INTEGER , +
`Machine` INTEGER , +
`Label#` INTEGER , +
`QtyInBox` INTEGER , +
`BoxComp1` TEXT (1) , +
`Pallet#` INTEGER , +
`PltComp1` TEXT (1) , +
`OrdComp1` TEXT (1) , +
`EntrDate` DATE , +
`EntrTime` TIME , +
`PrmtStat` TEXT (1) DEFAULT "Y" , +
`Jobpstrf` DATE , +
`Prdpstrf` DATE , +
`Priorqty` INTEGER , +
`Ship` TEXT (1) , +
`Shfcomp1` TEXT (1) , +
`Opid` TEXT (4) )
COMMENT ON TABLE `RetnOrds` IS 'Returned Orders'
RETURN
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
