Page 1 of 1
DBMonitor and parameters
Posted: Fri 12 Nov 2004 10:34
by GEswin
Is there any way of viewing the full sql sentence in dbmonitor when using parameters ? On one tab we have the SQL sentence with the parameters, on the other tab the values for the parameters.. I would like to see also the full resulting SQL, which may be usefull for debugging or for copy & paste purposes.
Thanks in advance,
J.Pieter Vos
Re: DBMonitor and parameters
Posted: Fri 12 Nov 2004 14:41
by Ikar
DBMonitor doesn't provide such functionality.
Posted: Sun 14 Nov 2004 21:00
by GEswin
Would it be possible to have DBMonitor to provide this functionality in a next release ? It would be nice and usefull to see complete resulting sql sentence instead of having to complete it by hand.
Posted: Tue 16 Nov 2004 10:37
by Ikar
DBMonitor serves for monitoring and debugging purposes and reflects queries in the same look as they were generated or set by users, i.e. with using parameters.
Now we are considering ability of enhancement TMySQLMonitor component functionality. Probably, we'll add a new property or use TMySQLMonitor.TraceFlags.tfMisc to determine necessity of TMySQLMonitor.OnSQL call with the final query.
Is this solution acceptable?
At any case, this functionality won't be available for cases of using new MySQL 4.1 API.
Posted: Tue 16 Nov 2004 14:19
by GEswin
Well I do everything with 4.1, specially now that since end october the 4.1 is considered stable and for production. So if it doesn't work with 4.1 it doesn't have any sense for me.
Posted: Tue 16 Nov 2004 15:45
by Ikar
In this case it makes sense not using MySQL Server 4.1, but just using a new API. So until MySQL AB supports compatibility with the old API, there might be no problems.
Posted: Wed 17 Nov 2004 23:19
by GEswin
Today I turned on logs at mysql server and can see there full sql sentences, so this solves my problem/question right now.. anyway, would be nice to have it integrated in dbmonitor
Posted: Thu 18 Nov 2004 12:39
by Ikar
As to DBMonitor, unlikely at the nearest time. Is it interested for you a solution with TMySQLMonitor?
Posted: Thu 18 Nov 2004 16:36
by GEswin
Yes, I would be very interested in seing this directly from DBMonitor. And I think many other user will be also interested.
Posted: Fri 19 Nov 2004 16:22
by Ikar
I should repeat myself, we don't plan to extend DBMonitor functionality in this way. Is it interested for you a solution with enhancement of TMySQLMonitor component functionality?
Posted: Sat 20 Nov 2004 00:01
by GEswin
Hi Ikar... sorry I readed to quickly the messages, i have some stressing days
Yes, enhancing TMySQLMonitor for this purpose would be excellent too, so my answer is Yes, I would be very pleased.
Posted: Tue 23 Nov 2004 12:14
by Ikar
Ok. We'll plan this task on the further versions.
Posted: Tue 25 Jan 2005 12:48
by Ikar
New build was released and you can download it (MyDAC 3.50.0.16) now from Core Lab server.
Posted: Wed 26 Jan 2005 13:14
by GEswin
OK thanks a lot, i'm going to d/l right now