I edited the default value to remove the "Y" and set it to Y in the 6.5 version and that solved the problem. Thanks Razzak and others for the insight. Ron
On Sat, Jan 4, 2014 at 1:19 PM, A. Razzak Memon < [email protected]> wrote: > 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! > -- > > >
