Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/Database/DBExpress/TSQLMonitor    [ Add a report in this area ]  
Report #:  1358   Status: Closed
Extending the TSQLMonitor to BDE's SQL-Monitor level
Project:  Delphi Build #:  6.402
Version:    6.0 Submitted By:   Dietmar Brueckmann
Report Type:  New Feature Request Date Reported:  5/27/2002 4:44:13 AM
Severity:    Extreme corner case Last Updated: 11/6/2007 5:32:03 AM
Platform:    All versions Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : 11.0.2627.5503
Duplicate of:  None
Voting and Rating
Overall Rating: (12 Total Ratings)
3.42 out of 5
Total Votes: None
Description
1. I did'nt see the parameters (set with ParamByName) - especially for problems with ApplyUpdates I change the query to TQuery to see the parameters.
2. I didn't see the "RowsAffected"-value - it would be nice to see it especially for delete-statements.


OFF TOPIC:
==========

This is a so very hard problem (and some other), that I decide to use BDE-TQuery for all new projects instead of dbExpress. I can't do a basic-technical change and loose information sources for solving projects problems.

And BORLAND - I can't understand why the functionality is less than the paragon of BDE what is the name of the man who has done such a job.
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

Luigi Sandon at 9/27/2002 2:03:50 AM -
I agree with the off-topic part of the description: not only dbExpress i buggy, but we have no tools to understand what's happening. Often I gave up fighting with strange dbExpress behaviours and switched to BDE, ADO or DOA.

Now you are deprecating BDE, but I was unable to see dbExpress as a replacement and to make enoguh experience using it.

Developing a fair better SQL Monitor should not be so a complext task!

Peter Budai at 8/28/2003 1:35:19 AM -
Did you ever compare speed with and without sqlmonitor activated ??
I couldn't believe this: with active monitor is simple select many times slower !!

And what a job does sqlmonitor for us ? Fast useles.. You see sql command, but you don't see params values !!

Only one information was interesting (and also very strange) for me: sql select with 2 parameters and there was 5 !!! calls to bind parambyname... whoaa...

Jehudi Hermie at 8/17/2004 3:15:29 AM -
It would definitely be a good feature if you can see
the sent params in de monitor-trace like you could before
in the BDE-monitor

Server Response from: ETNACODE01