uniguibbs Posted July 31, 2013 Share 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? Link to comment Share on other sites More sharing options...
uniguibbs Posted August 1, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
mhmda Posted August 2, 2013 Share Posted August 2, 2013 which database you use? Link to comment Share on other sites More sharing options...
uniguibbs Posted August 2, 2013 Author Share Posted August 2, 2013 sql server2008 Link to comment Share on other sites More sharing options...
Darth Florus Posted August 5, 2013 Share 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. Link to comment Share on other sites More sharing options...
uniguibbs Posted August 6, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted August 6, 2013 Administrators Share Posted August 6, 2013 UniTimer only works when put on a TUniForm or a TuniFrame. Link to comment Share on other sites More sharing options...
Darth Florus Posted August 6, 2013 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now