DB Monitor Questions

jfudickar · Post by **jfudickar** » Thu 22 Feb 2007 00:06

Hi,

some questions to DBMonitor

1. Why does it show allways 0 rows affected when selecting records?

SELECT DISTINCT USERNAME FROM ALL_USERS

-- 0 row(s) affected.

2. Does it recognice the runtime Name change of a component name?

3. Please show in the log when a component is destroyed

Greetings and thanks
Jens

Plash · Post by **Plash** » Thu 22 Feb 2007 14:02

1. The RowsAffected property represents count of rows that have been affected during query execution but not by fetching. Therefore it always equals to 0 for SELECT statements.
2. The DBMonitor doesn't reflect changes of the Name property of a component. It groups events by original component name.
3. We will investigate possibility to add such functionality.

jfudickar · Post by **jfudickar** » Thu 22 Feb 2007 15:00

Hi

1. Is it possible to enhance this?
2. How is the handling with components, which are created at runtime. When is the name fetched?
3. Thanks.

Jens

Plash · Post by **Plash** » Fri 23 Feb 2007 08:56

1. We will investigate possibility to add such functionality.
2. DBMonitor takes a component name when the first event from this component is received.

In ODAC 6 you can use the MonitorMessage method of TCustomDAConnection to send custom messages to DBMonitor.

jfudickar · Post by **jfudickar** » Fri 23 Feb 2007 11:07

1. Thanks.
The monitor component of allround automations protocols each fetch block with the timestamp (default every 25 rows)
2. What is the first event? Session assigning?

Greetings
Jens

Plash · Post by **Plash** » Mon 26 Feb 2007 09:12

First event means the first event that is displayed in DBMonitor. For example, call of the Prepare or Execute methods of TOraQuery.