DBMonitor and parameters

GEswin · Post by **GEswin** » Fri 12 Nov 2004 10:34

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

Ikar · Post by **Ikar** » Fri 12 Nov 2004 14:41

DBMonitor doesn't provide such functionality.

GEswin · Post by **GEswin** » Sun 14 Nov 2004 21:00

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.

Ikar · Post by **Ikar** » Tue 16 Nov 2004 10:37

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.

GEswin · Post by **GEswin** » Tue 16 Nov 2004 14:19

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.

Ikar · Post by **Ikar** » Tue 16 Nov 2004 15:45

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.

GEswin · Post by **GEswin** » Wed 17 Nov 2004 23:19

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

Ikar · Post by **Ikar** » Thu 18 Nov 2004 12:39

As to DBMonitor, unlikely at the nearest time. Is it interested for you a solution with TMySQLMonitor?

GEswin · Post by **GEswin** » Thu 18 Nov 2004 16:36

Yes, I would be very interested in seing this directly from DBMonitor. And I think many other user will be also interested.

Ikar · Post by **Ikar** » Fri 19 Nov 2004 16:22

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?

GEswin · Post by **GEswin** » Sat 20 Nov 2004 00:01

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.

Ikar · Post by **Ikar** » Tue 23 Nov 2004 12:14

Ok. We'll plan this task on the further versions.

Ikar · Post by **Ikar** » Tue 25 Jan 2005 12:48

New build was released and you can download it (MyDAC 3.50.0.16) now from Core Lab server.

GEswin · Post by **GEswin** » Wed 26 Jan 2005 13:14

OK thanks a lot, i'm going to d/l right now

Devart Forums

DBMonitor and parameters

DBMonitor and parameters

Re: DBMonitor and parameters