RE: How to display a heading with a SELECT statement?
It's also in the online help... HELP FORCE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 3:34 PM To: [EMAIL PROTECTED] Subject: RE: How to display a heading with a SELECT statement? It does work with UV. I found it in the User Reference pdf on page 1-50: Use in any RetrieVe sentence to force the display of column headings and headers when no records are selected. AdrianW -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
How to display a heading with a SELECT statement?
Hi I have a client who has a paragraph that does a SELECT and sends the result to a print queue. In other words, the results of the SELECT are a print job. But how can we/she print headings with that SELECT? Example code: CT VOC UCA.WEEKLYAUDIT UCA.WEEKLYAUDIT 0001 PA 0002 SP-ASSIGN Q21 [or even better: HS] 0003 CHECK BALANCES 0005 LIST ACCOUNTS WITH ACTYPE = 13 _ 0006 FULL.NAME A30 _ 0007 HEADING Accounts with account type 13 (P ... If there are no records to display, it says so, but no heading is produced. The report should at least say BLAH BLAH REPORT, at the start, and end with END OF REPORT. Any takers? Cheers, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately on +61 3 9291 1600. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to display a heading with a SELECT statement?
Wow, thanks. So easy. :o) -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Wednesday, 14 April 2004 14:38 To: 'U2 Users Discussion List' Subject: RE: How to display a heading with a SELECT statement? Add FORCE to your LIST. It's a very annoying UV feature ;-) Regards, David LeRoi Keiller wrote: If there are no records to display, it says so, but no heading is produced. The report should at least say BLAH BLAH REPORT, at the start, and end with END OF REPORT. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately on +61 3 9291 1600. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to display a heading with a SELECT statement?
1) Being unfamiliar with this, I checked the manuals regarding the use of FORCE in a LIST and I couldn't find that reference in the manuals. Could it be for UniData rather than UV? 2) Let the FORCE be with you. . . grin Hey, it's just too good a pun to resist. Steve At 02:38 PM 4/14/04 +1000, you wrote: Add FORCE to your LIST. It's a very annoying UV feature ;-) Regards, David LeRoi Keiller wrote: If there are no records to display, it says so, but no heading is produced. The report should at least say BLAH BLAH REPORT, at the start, and end with END OF REPORT. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to display a heading with a SELECT statement?
It does work with UV. I found it in the User Reference pdf on page 1-50: Use in any RetrieVe sentence to force the display of column headings and headers when no records are selected. AdrianW -Original Message- From: Steven M Wagner [mailto:[EMAIL PROTECTED] Sent: Wednesday, 14 April 2004 13:29 To: U2 Users Discussion List Subject: RE: How to display a heading with a SELECT statement? 1) Being unfamiliar with this, I checked the manuals regarding the use of FORCE in a LIST and I couldn't find that reference in the manuals. Could it be for UniData rather than UV? 2) Let the FORCE be with you. . . grin Hey, it's just too good a pun to resist. Steve At 02:38 PM 4/14/04 +1000, you wrote: Add FORCE to your LIST. It's a very annoying UV feature ;-) Regards, David LeRoi Keiller wrote: If there are no records to display, it says so, but no heading is produced. The report should at least say BLAH BLAH REPORT, at the start, and end with END OF REPORT. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users