winsonsiu Posted November 13, 2013 Share Posted November 13, 2013 When I finished my first web application by unigui, use ADO connection to connect MS SQL server, no problem in single user, but in multi-user mode , all action of the data such as update ,delete will influence the other user. I use ADO connection and Query and put it into Main Module. Link to comment Share on other sites More sharing options...
Oliver Morsch Posted November 13, 2013 Share Posted November 13, 2013 1) You have set AutoCoInitilize to True in UniServerModule? 2) What option do you use: dirtyread, readcommited, ...? 3) What problems? Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted November 13, 2013 Administrators Share Posted November 13, 2013 When I finished my first web application by unigui, use ADO connection to connect MS SQL server, no problem in single user, but in multi-user mode , all action of the data such as update ,delete will influence the other user. I use ADO connection and Query and put it into Main Module. Deleting a row from a table will affect other users who use same table. Table is one users are many. Link to comment Share on other sites More sharing options...
rullomare Posted November 13, 2013 Share Posted November 13, 2013 Hi, maybe you can help : For Ms-Sql Server look for BEGIN TRANSACTION, COMMIT TRANSACTION, ROLLBACK TRANSACTION and SET TRANSACTION ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SNAPSHOT | SERIALIZABLE }[ ; ] BEGIN TRAN T1;UPDATE table1 ...;BEGIN TRAN M2 WITH MARK;UPDATE table2 ...;SELECT * from table1;COMMIT TRAN M2;UPDATE table3 ...;COMMIT TRAN T1; Regards Link to comment Share on other sites More sharing options...
winsonsiu Posted November 14, 2013 Author Share Posted November 14, 2013 For an example , I open the program in two browsers, both ADO query in edit mode, and then one browser press save and run the post command in ADO query, after that the second browser can't post the record, prompt out dataset not in edit mode. Look like two browser use the same ado query, how to solve this problem, thank you very much Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted November 14, 2013 Administrators Share Posted November 14, 2013 For an example , I open the program in two browsers, both ADO query in edit mode, and then one browser press save and run the post command in ADO query, after that the second browser can't post the record, prompt out dataset not in edit mode. Look like two browser use the same ado query, how to solve this problem, thank you very much Are you sure your AdoQuery is on MainModule? 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