The snippet of code below was created by the "UNLOAD ALL FOR tablename" from an early 7.1 database.
When the edited file (to allow for placing the table into RRBYW10) is RUN to place the table into RRBYW10 I get this error: ERROR - As column Tax is used in another table, its type cannot be redefined (2942) Then when I checked. . .The RRBYW10 table, InvoiceHeader, does indeed have a column "Tax", BUT its type is also CURRENCY, so I thought: "What's the big deal here?" I quickly renamed the InvoiceHeader "tax" column to "taxx" and temporarily deleted (+ tax) from the computed column in the table, and proceeded to RUN the file to install the new table. No errors. Now RRBYW10 has my new table "Invoices" with the column "Tax" And the "InvoiceHeader" table with the column "Taxx" Both are CURRENCY When attempting to rename the column "Taxx" back to "Tax" in the InvoiceHeader table I get the same error as when I first attempted to run my UNLOADED file: "ERROR-As column Tax is used in another table, its type cannot be redefined (2942)" However, I can add a new column "Tax" with no problem. "What is going on here?" ================================= CREATE TABLE `Invoices` + (`Invoice` INTEGER , + `CustNumber` INTEGER , + `InvDate` DATE , + `NetAmt` CURRENCY , + `TaxCode` INTEGER , + `Tax` CURRENCY , + `InvTotal` CURRENCY , + `AmtPaid` CURRENCY , + `PaidBy` TEXT (10) )
