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

[Myron]

Bernie, Somewhere along the way I remember Razzak saying that with the new release(s) you should be using IDQUOTES. So, the question becomes this; looking forward what is the best way to write the program so that it will work with future versions?   Once I set the IDQUOTES for ` it worked fine. I just needed help with the IDQUOTES. Thanks for your help. Myron   From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Monday, October 10, 2005 1:59 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Creating a Temporary Table   Myron, I don't use quotes around col name, try it without quotes. Bernie Lis ----- Original Message ----- From: Myron To: RBG7-L Mailing List Sent: Monday, October 10, 2005 12:55 PM 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