uniguibbs Posted July 31, 2013 Posted July 31, 2013 i put a Tconnection on UniMainModule , all the other TDataSet link to the Tconnection. when i save a TDataSet to database, a exception raise : "Connection is busy with results for another command." what's going on? Quote
uniguibbs Posted August 1, 2013 Author Posted August 1, 2013 i put a unitimer on mainmodule . timer run per 10 seconds to update a record . may be it's the error reason Quote
Darth Florus Posted August 5, 2013 Posted August 5, 2013 I experiment this kind of problem with SQL Server because of dataaware. My solutions is to use StoredProcedure to manipulate data. They are so many ways to do that. Just pick one. Quote
uniguibbs Posted August 6, 2013 Author Posted August 6, 2013 i use StoredProcedure. exception still exists. all dataset use one Tconnecton; may be timer execute in one thread. may be timer cause the exception Quote
Administrators Farshad Mohajeri Posted August 6, 2013 Administrators Posted August 6, 2013 UniTimer only works when put on a TUniForm or a TuniFrame. Quote
Darth Florus Posted August 6, 2013 Posted August 6, 2013 If You use ADO to stablish the connection there are Asynconous update mode avaliable you cant use it as a workarround of a Timer. Or just simply use ADO, work very well with SQLServer. But still mandatory to not use DataAware framework to update data, only to show data on a grid. This is bassed on my experience of use Delphi with SQLServer. Best Regards Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.