Hello all, Well it took a while but I finally found the problem. I just couldn't believe that this would be a problem. Here is the offending code.
APPEND tDays TO CUSTOMER As you can surmise tDays is a TEMPORARY table that is generated from TABLES, TEMPORARY TABLES, and TEMPORARY VIEWS and to be in the same order as the permanent table CUSTOMER so I would be able to just issue the APPEND command. In fact there is an append command just 4 lines earlier that work just fine so why was would this fail? My job (and I had to accept it) was try to figure out why. Although my current why is only a theory it is a plausible one. I received this database as an upgrade project. However I would not be able to make any column name changes because the new project needed to be run in parallel with the existing 4.5 plus application. The customer table contains several columns with the $ at the end of the column name. This appears to be the problem area. Although I could create Temporary tables and views with the $ in the column name, it didn't like me issueing an APPEND with the $ in the name. But this issue only occurred in the use of an REFF (external) form. You may remember that this code worked at the R>. I have reason to believe it also worked in a regular form. It just failed in the external form. I have changed my original APPEND to INSERT INTO CUSTOMER + (CUSTNO,ORDER$,ACTUAL$,RETURNS$,NETSALE$,WEEK,RT) + SELECT + CUSTNO,ORDER$,ACTUAL$,RETURNS$,NETSALE$,WEEK,RT + FROM tDays and I am back on my way. As this particular scenarior would be difficult to replicate in RRBYW14 as it would require column name changes which would officially break the standard database for testing I am not requesting a bug fix or an enhancement request. In my opionion this is clearly a bad data base issue. I only offer this information as an area for people to be aware of. DO NOT USE COLUMN NAMES WITH SPECIAL CHARACTERS!!! I know many of us may have used them in previous iterations of databases and all of my new ones never use special characters. Have a great day (I know mine will be better since I found this)! Jan
