RETURN, ORDER and LABEL are all reserved words. I never know whether adding a suffix is allowable so I don’t.
You could try renaming all of them. Regards, Alastair. From: Ronald C Peterson Sent: Saturday, January 04, 2014 5: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
