Subject | RE: [IBO] How could i get "real" SQL Statements with IBO Monitor? |
---|---|
Author | Jason Wharton |
Post date | 2004-05-05T19:30:58Z |
Sounds like you want some sort of logging, not monitoring.
Use triggers and log tables.
Look at the IB LogManager tool. Perfect for this sort of thing. It automates
the creation of all your triggers and log tables.
Jason
-----Original Message-----
From: cgar1136 [mailto:cgar1136@...]
Sent: Wednesday, May 05, 2004 12:23 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] How could i get "real" SQL Statements with IBO
Monitor?
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
looking for a way to know wich field was updated just seeing
a "Monitor" Log, with the information that the IBMonitor gives me i
don't know wich of all fields was updated and wich conserves it's
previous values.
Maybe what i'm looking for is not in the IBMonitor, may be could i
get that information from th IBO_Connection Events... maybe something
like the Event OnError, that have parameters that give to me the SQL
Statement that causes the error, something like that it's wath i'm
looking for but not only at errors; at updates, inserts, deletes or
selects; some event where i can get the SQL that the Query's
components send to the server.
Best Regards and thanx
Carlos G
Use triggers and log tables.
Look at the IB LogManager tool. Perfect for this sort of thing. It automates
the creation of all your triggers and log tables.
Jason
-----Original Message-----
From: cgar1136 [mailto:cgar1136@...]
Sent: Wednesday, May 05, 2004 12:23 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] How could i get "real" SQL Statements with IBO
Monitor?
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:
> What you see in IBO monitor is the REAL statement being executed onthe
> server.Ok, i'm sure that this is great at many cases, but for now i'm
looking for a way to know wich field was updated just seeing
a "Monitor" Log, with the information that the IBMonitor gives me i
don't know wich of all fields was updated and wich conserves it's
previous values.
Maybe what i'm looking for is not in the IBMonitor, may be could i
get that information from th IBO_Connection Events... maybe something
like the Event OnError, that have parameters that give to me the SQL
Statement that causes the error, something like that it's wath i'm
looking for but not only at errors; at updates, inserts, deletes or
selects; some event where i can get the SQL that the Query's
components send to the server.
Best Regards and thanx
Carlos G