Jump to content

How to develop a multi-user program with ADO connection


winsonsiu
 Share

Recommended Posts

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

  • Administrators

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

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

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

  • Administrators

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...