Devart Forums

Hi,

Does the new version of MyDAC support non-blocking queries? Or maybe UNIDAC?

Hello,

For the time being, MyDAC doesn't support executing non-blocking queries. You can leave your suggestion at our UserVoice page ( http://devart.uservoice.com/forums/1046 ... components ), and if there are many votes for your suggestion, we will implement it.

So, if I would like to implement some thread-safe queries using a connection pool implementation.

Is there a safe way to check whether a connection is already in use?

Suppose I have a MyQuery connected to a MyConnection. I issue a time-consuming MyQuery.Execute in thread. In another thread I want to issue another .Execute but somehow I have to check if the Connection is used or not.

The right way to work in a multithreaded application is to have connection (the TMyConnection component) in each thread. In this case, your application will be threadsafe. You can have infinite amount of queries running through one connection in one thread, but you must not run several queries from several threads through one connection. We already have a suggestion about the property that shows that a connection is already in use. You can vote for it at http://devart.uservoice.com/forums/1046 ... -that-show