Try removing the double quotes around the Y following DEFAULT.
From: [email protected] [mailto:[email protected]] On Behalf Of Ronald C Peterson Sent: Saturday, January 04, 2014 12:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Table named RETURNS 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
