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

[ttc . inc]

Check your character settings in the new database.  If you have Quotes set to " instead of ' or something other than + for the plus character you would get this error.

 

-Bob

 

-------------- Original message --------------

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