dbTalk Databases Forums  

Re: How to suppress those messages [404] etc

comp.databases.pick comp.databases.pick


Discuss Re: How to suppress those messages [404] etc in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
johnmarshall@xtra.co.nz
 
Posts: n/a

Default Re: How to suppress those messages [404] etc - 08-15-2006 , 06:09 AM







Success! The "T C" as recommended below did the trick thanks.

John


Simon Verona wrote:
Quote:
I could be wrong but inserting a line with "T C" on it after your select
statement has finished will clear teh screen.



Reply With Quote
  #2  
Old   
Luke Webber
 
Posts: n/a

Default Re: How to suppress those messages [404] etc - 08-15-2006 , 06:17 AM






johnmarshall (AT) xtra (DOT) co.nz wrote:
Quote:
Ross - I have some Procs where the display of data looks a bit
cluttered with messages like [404] 1 items selected out of 3922 items
appearing on the screen, and I thought that suppressing it would make
the screen output look cleaner.

Here's a little example:

DISPLAY VENDOR PRICE DETAILS

Enter Part Number, or 'B' to bypass :MY041

[404] 1 items selected out of 3922 items. <<<<<- I want to zap this
message

PRICING FOR MY041 FAB,LCD BRIGHT PLUS BUTTON,35-124
AS AT 19:14:32 15 Aug 2006

data display follows on
OK, got it. On the SELECT, replace the P command with a PH (Process with
Hush).

Luke


Reply With Quote
  #3  
Old   
Concerned_Netizen
 
Posts: n/a

Default Re: How to suppress those messages [404] etc - 08-15-2006 , 10:43 PM



PH is the grabber for stuff like that in proc. You can also test after exit by using the IF E = 404 , or like conditionals to redirect control to various statement labels within the proc, depending on the MV implimentation.






Reply With Quote
  #4  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: How to suppress those messages [404] etc - 08-17-2006 , 12:08 AM



There are two functions being discussed.
1) We want a message but we don't want to see it.
This is where they can use "T C" or "PH" or "CAPTURING" to suppress
output.
2) We don't want messages to be generated from AQL.
Use the "J" option at the end of the statment.
I think this is what Bruce is looking for.

Bruce Nichol wrote:
Quote:
Isn't there a NI-SUPP or a (B......??



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.