[RBG7-L] - RE: Creating a Temporary Table

[Walker, Buddy]

Myron     Check your settings for the IDQUOTES.   Buddy   From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Myron Sent: Monday, October 10, 2005 12:55 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Creating a Temporary Table I’m having difficulty creating a temporary table. So, I went back to RRBYW10. The code below comes from RRBYW10, the file is TempTbls.rmd. When I trace the code in RRBYW10 it traces fine. I then move the code into a new database and I get an error message: -ERROR-Syntax error (2367) Can someone please explain to me why it works in one database and not another?     SET ERROR MESSAGE 2038 OFF DROP TABLE tInvoiceHeader CREATE TEMPORARY TABLE `tInvoiceHeader` + (`TransID` INTEGER, +  `CustID` INTEGER, +  `EmpID` INTEGER, +  `TransDate` DATE, +  `BillToCompany` TEXT (40), +  `BillToAddress` TEXT (30),  +  `BillToCity` TEXT (20), +  `BillToState` TEXT (2), +  `BillToZip` TEXT (10), +  `ShipToCompany` TEXT (40), +  `ShipToAddress` TEXT (30), +  `ShipToCity` TEXT (20), +  `ShipToState` TEXT (2), +  `ShipToZip` TEXT (10), +  `NetAmount` CURRENCY, +  `Freight`= ( netamount* .01) CURRENCY, +  `Tax`= ( netamount* .081) CURRENCY, +  `InvoiceTotal`= (NetAmount+Freight+Tax) CURRENCY)   Thanks Myron