Abaksoft Posted February 4, 2020 Share Posted February 4, 2020 Dear Friends, In my old Unigui project i notice a strange behavior: store differences (item movements) Probably an error on my part regarding SQL queries or Server power cuts. However, I noticed, today to my dismay, that my Class was declared as TDataModule and not TUniGUIMainModule (which is multi Sessions). Could my store gap problem have come from there? In other words: will we now have to declare with Unigui all our classes : TMyclasse = class (TUniGUIMainModule) ? ..... end; and not in TMyclasse = class (TDataModule) ..... end; ______________ Note : The application is Multi users environment. Edit : My old Class (TDataModule) contain Concurrent SQL queries !!! Big Thx Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted February 4, 2020 Author Share Posted February 4, 2020 Auto answer : 1. we have to use TDataModule generated by Unigui Application. 2. Conserning my store gab problem, i found that i am using the same DBQuery component on mainModule, for all concurrent queries sessions (a bad old habit) The safe way is to create on the fly DBQuery inside a trandaction and free it at the end. sorry for any enconvenience. Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted February 5, 2020 Share Posted February 5, 2020 this should not be a problem, as the mainmodule is instantiated for each user, so your bdquery would have an instance for each user. Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted February 5, 2020 Author Share Posted February 5, 2020 Thank you wilton_rad, I will diagnose others portions code. Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted March 2, 2020 Author Share Posted March 2, 2020 Fixed. A catastrophic procedure a writed, was the cause. Sometimes my brain works at 3℅. Sorry for the alert. Quote Link to comment Share on other sites More sharing options...
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.