Javier - Very interesting.
I added the BROWSE * FROM ppsout just before the PRINT and it does display the data correctly! Then the PRINT command fails with the same error message. CONNECT wdoss SET ERROR MESSAGE 2038 OFF DROP TABLE ppsb NOCHECK DROP TABLE ppsbt NOCHECK DROP TABLE ppsout NOCHECK SET ERROR MESSAGE 2038 ON CREATE TABLE ppsb (ssnb TEXT 11) LOAD ppsb FROM rpt1.dat PROJECT ppsbt FROM pps USING ssn,firstnme,lastnme,crew JOIN ppsb USING ssnb WITH ppsbt USING ssn FORMING ppsout BROWSE * FROM ppsout PRINT ppsout ORDER BY crew + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE|ZOOMPERCENTAGE 98 RETURN If I isolate the PRINT command in an .RMD by itself, it works fine: connect wdoss PRINT ppsout ORDER BY crew + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE percentage 98 RETURN Dayle Coxen Florida DOT (850) 410-5635 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, December 01, 2011 3:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: -ERROR- Table ppsout does not exist! Dayle, A couple of thoughts: First, I would use the following code for the first 3 lines: SET ERROR MESSAGE 2038 OFF DROP TABLE ppsb DROP TABLE ppsbt DROP TABLE ppsout SET ERROR MESSAGE 2038 ON Second, what happens if you add the code: BROWSE * FROM ppsout Does the data display correctly? Does the report print correctly afterwards Can you run the report by itself after your code exits? Is there any code in your report (Reports>>Actions) that is deleting the table? Also, it seems like your report and table names are the same. I vaguely recall running into some sort of problem with similar names in reports/forms/tables; have you tried renaming the table or report? Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle Sent: Thursday, December 01, 2011 12:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - -ERROR- Table ppsout does not exist! Hello all - Maybe someone can enlighten me. I am converting a .CMD file from 7.6 to 9.1. I isolated the issue to the following 11 lines of code. When I trace the below .RMD, I get the message "-ERROR- Table ppsout does not exist!" after executing line 10. The report "ppsout" uses a table of the same name. 01 DROP ppsb 02 DROP ppsbt 03 DROP ppsout 04 CREATE TABLE ppsb (ssnb TEXT 11) 05 LOAD ppsb FROM rpt1.dat 06 PROJECT ppsbt FROM pps USING ssn, firstnme,lastnme,crew 07 JOIN ppsb USING ssnb WITH ppsbt USING ssn FORMING ppsout 08 PRINT ppsout ORDER BY crew + 09 OPTION SCREEN|WINDOW_STATE MAXIMIZED + 10 |ZOOM_TYPE percentage 98 11 RETURN When I exit the trace and use Database Explorer to look for the table (ppsout), it is there. It contains the rows and columns expected. When I open the report (ppsout) with report designer and select the preview tab it looks fine. ppsb, ppsbt both contain values that I expected. The only way I could get the report to run was to add a CONNECT to the database between lines 07 and 08. It then works fine. Thanks in advance. Dayle Coxen Florida DOT 850-410-5635
