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

[Walker, Buddy]

Myron      R:>SHOW CHARS    It should be the last item listed.    Make sure the IDQUOTES are set the ` (this is a backwards single quote) normally under the tilde    The way to set it is    R:>SET IDQUOTES = `   Buddy From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Myron Sent: Monday, October 10, 2005 1:15 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Creating a Temporary Table Buddy, I’m game, how do I determine what the IDQUOTES are set for? I know what the QUOTES are set for and I’m assuming (I know the trouble I can get into) it is a different thing. Thanks   From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Monday, October 10, 2005 1:09 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Creating a Temporary Table   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