Multiple open MSQueries on the same MSConnection

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 21
Joined: Wed 28 Jul 2010 11:24

Multiple open MSQueries on the same MSConnection

Post by Petya » Wed 30 Nov 2011 11:04

Hello folks,

I wonder what if I leave more than 1 opened resultsets on a single instance of TMSConnection in the main thread - in other words what if I open a second one while the first query is still open ?
TMSQueries are .Created dynamically by code - MSConnection is put on the main Form.
SDAC for Delphi 5 Registered CRSDA-02971

Is it okay or should I close the first ? :?:

Thanks, Peter


Post by AndreyZ » Thu 01 Dec 2011 11:07


You can open as many datasets using one connection as you want.

Post Reply