Change the quotes on the prnstat line to single quotes.
`prnstat` TEXT (1) DEFAULT ''Y''
Albert
On 1/4/2014 10:45 AM, 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
