Devart Forums

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

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.

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

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.

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

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