|
From: Wesley N. <We...@Ke...> - 2017-03-03 17:14:15
|
It appears to have something to do with viewing and possible sorting on the table columns tab. Switching from one table to another with the columns tab open sometimes causes all the column data to be shown twice. How this gets back into my Pervasive schema is something I have not been able to duplicate consistently. Sometimes it happens, but most times the schema is unchanged. I wish I could figure out a way to duplicate it consistently. I restarted Squirrel and cannot get it to corrupt the tables. I am going to dig into it further on my end. We did just do a major software update and possibly they had something wrong in there update process. Best Regards, Wesley S. Newswanger<http://w3w.cm/today.astounding.equals> IT & Database Administrator Keystone Collections(tm) Office: 866.881.6680 ext. 1028 Email: we...@ke... <mailto:we...@ke...> [cid:image001.gif@01D29411.916F96D0]<http://www.keystonecollections.com/> From: Wesley Newswanger Sent: Friday, March 03, 2017 9:47 AM To: 'Squ...@li...' <Squ...@li...> Subject: Columns double when running a simple select table I am running into a weird problem with Squirrel snapshot 20170214_2214 causing my columns to double in my Pervasive database. If I run a simple Select * from query on a table it adds a whole set of duplicate columns. The duplicate columns do not show in the query. After this happens I get the following error when attempting to link in MS Access - 'Cannot define field more than once'. Squirrel shows the column names twice. Here is an example of table schema from Pervasive before and after running a query. /* ========================================== * TABLE: INVENTORY_COST * ========================================== */ CREATE TABLE "INVENTORY_COST"( "PART" CHAR(20), "LOCN" CHAR(2), "COST" NUMERIC(16,6), "MATL" NUMERIC(16,6), "LABOR" NUMERIC(16,6), "OVHD" NUMERIC(16,6), "OUTS" NUMERIC(16,6), "FREIGHT" NUMERIC(16,6), "OTH" NUMERIC(16,6), "CHG_DATE" DATE, "CHG_TIME" TIME, "CHG_BY" CHAR(8), "CHG_PGM" CHAR(8), "FILLER" CHAR(30)); CREATE UNIQUE NOT MODIFIABLE INDEX "INVENTORY_COSTK00" USING 0 ON "INVENTORY_COST"("PART", "LOCN"); /* ========================================== * TABLE: INVENTORY_COST * ========================================== */ CREATE TABLE "INVENTORY_COST"( "PART" CHAR(20), "LOCN" CHAR(2), "COST" NUMERIC(16,6), "MATL" NUMERIC(16,6), "LABOR" NUMERIC(16,6), "OVHD" NUMERIC(16,6), "OUTS" NUMERIC(16,6), "FREIGHT" NUMERIC(16,6), "OTH" NUMERIC(16,6), "CHG_DATE" DATE, "CHG_TIME" TIME, "CHG_BY" CHAR(8), "CHG_PGM" CHAR(8), "FILLER" CHAR(30), "column0" CHAR(20), "column1" CHAR(2), "column2" NUMERIC(16,6), "column3" NUMERIC(16,6), "column4" NUMERIC(16,6), "column5" NUMERIC(16,6), "column6" NUMERIC(16,6), "column7" NUMERIC(16,6), "column8" NUMERIC(16,6), "column9" DATE, "column10" TIME, "column11" CHAR(8), "column12" CHAR(8), "column13" CHAR(30)); CREATE UNIQUE NOT MODIFIABLE INDEX "INVENTORY_COSTK00" USING 0 ON "INVENTORY_COST"("PART", "LOCN"); Best Regards, Wesley S. Newswanger<http://w3w.cm/today.astounding.equals> IT & Database Administrator Keystone Collections(tm) Office: 866.881.6680 ext. 1028 Email: we...@ke... <mailto:we...@ke...> [cid:image001.gif@01D29411.916F96D0]<http://www.keystonecollections.com/> |
