Ron, Based on your QUOTES settings as double quotes, here is an example the corrected 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 , + `PrntStat` 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! --
