dbTalk Databases Forums  

[Info-Ingres] Who raised the databsase event

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] Who raised the databsase event in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] Who raised the databsase event - 08-06-2010 , 08:26 AM






Hi All,

I'm assuming I've missed something very simple...but, how do I trap who raised a database event?

I'm looking at inquire_sql() and I see stuff for the dbeventtext, the dbeventowner etc.. but nothing for who raised the bloody thing.

Martin Bowes

Reply With Quote
  #2  
Old   
Deb Farrell
 
Posts: n/a

Default Re: Who raised the databsase event - 08-07-2010 , 07:16 AM






On Aug 6, 2:26*pm, Martin Bowes <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Quote:
Hi All,

I'm assuming I've missed something very simple...but, how do I trap who raised a database event?

I'm looking at inquire_sql() and I see stuff for the dbeventtext, the dbeventowner etc.. but nothing for who raised the bloody thing.

Martin Bowes
OK... So in source/src/front/embed/hdr/iilibq.h
typedef struct IIEV_{
struct IIEV_ *iie_next; /* Next event on list
*/
char iie_name[DB_MAXNAME+1]; /* Event name */
char iie_owner[DB_MAXNAME+1];/* Event owner */
char iie_db[DB_MAXNAME+2]; /* Database(+2 for
alignment) */
DB_DATE iie_time; /* Timestamp */
char *iie_text; /* Optional text */
} II_EVENT;

Anyone think it might be nice to extend this to put in a char
iie_raisedby[DB_MAXNAME+1]; /* Who raised the bloody thing */
Also adding dbeventraisedby as a flag to inquire_sql ?

Once I get off my lazy fat arse and complete my new date format
code...this has got a fair chance of being my next project.

Martin Bowes

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

Default Re: Who raised the databsase event - 08-09-2010 , 01:10 PM



On Aug 7, 5:16*am, Deb Farrell <dlfarr... (AT) hotmail (DOT) com> wrote:
Quote:
On Aug 6, 2:26*pm, Martin Bowes <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:

Hi All,

I'm assuming I've missed something very simple...but, how do I trap whoraised a database event?

I'm looking at inquire_sql() and I see stuff for the dbeventtext, the dbeventowner etc.. but nothing for who raised the bloody thing.

Martin Bowes

OK... So in source/src/front/embed/hdr/iilibq.h
typedef struct IIEV_{
* * struct IIEV_ * * * **iie_next; * * * * * * */* Next event on list
*/
* * char * * * * * * * *iie_name[DB_MAXNAME+1]; /* Event name */
* * char * * * * * * * *iie_owner[DB_MAXNAME+1];/* Event owner */
* * char * * * * * * * *iie_db[DB_MAXNAME+2]; * /* Database(+2 for
alignment) */
* * DB_DATE * * * * * * iie_time; * * * * * ** /* Timestamp */
* * char * * * * * * * **iie_text; * * * * * * */* Optional text */

} II_EVENT;

Anyone think it might be nice to extend this to put in a char
iie_raisedby[DB_MAXNAME+1]; /* Who raised the bloody thing */
Also adding dbeventraisedby as a flag to inquire_sql ?

Once I get off my lazy fat arse and complete my new date format
code...this has got a fair chance of being my next project.

Martin Bowes
It would be a nice feature, the quick short term solution is to have a
gentleman's agreement that the raiser will include their name in the
event text :-)

If you do work on this be aware you will need to bump the GCA protocol
level as you would also need to expose this in the comms area, see the
GCA_EV_DATA structure in the GCA manual (GCA/GCF API External
Interface Specification 9.0, page 8-10) as well as deal with backwards
compatibility. I.e. a new event structure will be required, you can't
edit GCA_EV_DATA.

Chris

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.