Unix Technical Forum

progress errors during session

This is a discussion on progress errors during session within the pgsql Databases forums, part of the PostgreSQL category; --> Hi Sorry for my bad English, but I still hope you will understand my problem. In <Procedure editor->Help->Recent Messages> ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Databases

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 12:39 AM
Diron
 
Posts: n/a
Default progress errors during session

Hi

Sorry for my bad English, but I still hope you will understand my problem.
In <Procedure editor->Help->Recent Messages> there is a list of
"Progress and operating system error messages generated during the session."
- this means list of ALL errors during WHOLE session.

My problem is that I can't recognize if errors appeared since my last "Run",
or they are generated earlier.
Some errors do not effect on screen, or Progress is "too fast"

Is any possibility to clear history of all errors in session (I don't want
to leave procedure editor to do that) ?
I can write my own procedure, but I don't know where Progress store these
informations (what system tables (_file) uses for that) ?

thanks for help

Greetings from Poland
Diron


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 12:39 AM
Kevin
 
Posts: n/a
Default Re: progress errors during session

"Diron" <diron_wytnij@to_go2.pl> wrote in
news:c8vi2i$975$1@nemesis.news.tpi.pl:

> Hi
>
> Sorry for my bad English, but I still hope you will understand my
> problem. In <Procedure editor->Help->Recent Messages> there is a list
> of "Progress and operating system error messages generated during the
> session." - this means list of ALL errors during WHOLE session.
>
> My problem is that I can't recognize if errors appeared since my last
> "Run", or they are generated earlier.
> Some errors do not effect on screen, or Progress is "too fast"
>
> Is any possibility to clear history of all errors in session (I don't
> want to leave procedure editor to do that) ?
> I can write my own procedure, but I don't know where Progress store
> these informations (what system tables (_file) uses for that) ?
>
> thanks for help
>
> Greetings from Poland
> Diron
>
>
>


All messages are stored in the promsgs file. I don't know that there is
a way to remove them since the beginning of the session. The messages
from the Procedure editor are stored in the ERROR-STATUS system handle
(a memory structure).

When using the procedure editor, make sure that
SESSION:SYSTEM-ALERT-BOXES = true, which forces all error and warning
messages to pop up as alert-boxes, instead of in the message area, which
should solve your problem.

Kevin
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 12:39 AM
Diron
 
Posts: n/a
Default Re: progress errors during session

Hi

> All messages are stored in the promsgs file. I don't know that there is
> a way to remove them since the beginning of the session.


yes, I know - this file contains all errors messages definitions

>The messages from the Procedure editor are stored in the ERROR-STATUS

system handle
> (a memory structure).


I don't think so ...
EROOR-STATUS - "A handle to error information on the last statement executed
with the NO-ERROR option."
last statement and LAST only , if you use NO-ERROR again previous errors
are cleared

> When using the procedure editor, make sure that
> SESSION:SYSTEM-ALERT-BOXES = true, which forces all error and warning
> messages to pop up as alert-boxes, instead of in the message area, which
> should solve your problem.


thank you, if I use both:
SESSION:SYSTEM-ALERT-BOXES = true.
SESSION:APPL-ALERT-BOXES = true.
it should solve my problem

But I'm still curious how get access to whole session errors ...

have a nice day
Diron


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-10-2008, 12:39 AM
Kevin
 
Posts: n/a
Default Re: progress errors during session

"Diron" <diron_wytnij@to_go2.pl> wrote in message
news:c91o7j$jbh$1@atlantis.news.tpi.pl...
>
> thank you, if I use both:
> SESSION:SYSTEM-ALERT-BOXES = true.
> SESSION:APPL-ALERT-BOXES = true.
> it should solve my problem
>
> But I'm still curious how get access to whole session errors ...
>
> have a nice day
> Diron
>
>


Okay, that makes more sense on what you are after. If you extract your
source (or download the source from http://www.possenet.org), look in the
prohelp directory. The two files we use to grab the messages in the
Procedure editor are:
_rcntmsg.p &
msgs.i

Fell free to use this code to create your own version of the Procedure
Editor messages system..

Kevin


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:57 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com