Bob, It's possible that PROJECTing from an ODBC has issues but someone else with more knowledge is going to have to chime in. I think that the new update for V8 has not quite been released yet because of a couple of issues.
I think I would create a define a new temporary table with the structure you need and then insert the data. Something like this. SET ERROR MESSAGE 2038 OFF DROP TABLE tApproveQuote SET ERROR MESSAGE 2038 ON CREATE TEMPORARY TABLE `tApproveQuote` + (`WorkOrderID` INTEGER , + `CustomerID` INTEGER , + `CustPO` TEXT (30) , + `EquipUPC` TEXT (8) , + `ProdMfr` TEXT (30) , + `ProdModel` TEXT (30) , + `ProdDescription` TEXT (40) , + `EquipSerialNbr` TEXT (30) , + `EquipPropNbr` TEXT (30) , + `Status` TEXT (1) , + `OrderDate` DATE , + `CalDate` DATE , + `CompanyName` TEXT (50) , + `WorkLocated` TEXT (1) ) APPEND WOStatus TO tApproveQuote I understand that APPEND is not fully compliant but I use it whenever I can. Other wise do a SELECT INSERT into the temporary table. Jan
