|
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 |
