I create a HOLD table similar to this:

 
TABLE FILE ORDER_PAYMENTS
BY ORDER_KEY AS 'ORDER_NUMBER'
BY CUST_ID AS 'CUST_NUMBER'
WHERE ORDER_DT GE HADD((HGETC(8, 'HYYMDs')), 'DAY', -30, 8, 'HYYMDs');
WHERE INACTIVE_ACCT NE '1' OR INACTIVE_ACCT EQ MISSING;
WHERE ORDER_KEY IN &ORDER_KEY;
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS CUST_ORDERS FORMAT FOCUS INDEX ORDER_KEY
END

I wish to see what's in the table so I try this:

TABLE FILE CUST_ORDERS
 PRINT *
 END
 -EXIT
 

But all I get back is this:

0 NUMBER OF RECORDS IN TABLE= 9 LINES= 9

What am I doing wrong?

Thanks.

Thanks.

This message has been edited. Last edited by: Tamra,

Are these two TABLE requests in the same focexec or in two different focexecs?

Unless you have APP HOLD in your code, a HOLD file is temporary and only there for the duration of the session. So, you ought to see what happens if you do something like this:

TABLE FILE CAR
SUM RCOST BY COUNTRY BY CAR
ON TABLE HOLD AS TEST
END
TABLE FILE TEST
PRINT *
END
-RUN

Just one word of caution. If you're using APP HOLD, your hold file is going be written into an application path directory. So, you should be careful where you use it. Look up doc and read up on APP HOLD command.

"The APP HOLD command defines an application in which to hold output data files (and associated Master and Access Files, if applicable) created by a HOLD, SAVE, or SAVB process in the application.

APP HOLD is intended to be used to refresh files that are common for all users of the application. It should not be used for private files since it points to an application area that is used by multiple users. If the same hold name (HOLD or AS name, for example) is used, conflicts between users could result."

The 2 table requests are in the same file, one immediately following the other.

Since the files are private, I won't try APP HOLD.

Maybe I need to SET or unSET an option to make it work?

I'm sure I'm missing something minor.

I'll keep trying . Thanks for your help.

What happens if you add something like this to TABLE FILE CUST_ORDERS:

ON TABLE PCHOLD FORMAT EXL2K

quote:

0 NUMBER OF RECORDS IN TABLE= 9 LINES= 9

LINES = 9 indicates that the data are accessible, so much of this thread was off base.

The behavior looks like what you would expect in FOCUS with SET PRINT=OFFLINE

Throw in a
? SET ALL
and check the PRINT setting

gcarterIT

Did the ? SET ALL help you out at all?

Refer to all the Set commands within this documentWebFOCUS Developing Reporting
Page 440


Thank you for participating in the Focal Point Forum.

Kind Regards,
Tamra Colangelo
IBI Focal Point Moderator