another multi-user "see each other data" problem - Printable Version +- Atozed Forums (https://www.atozed.com/forums) +-- Forum: Atozed Software Products (https://www.atozed.com/forums/forum-1.html) +--- Forum: IntraWeb (https://www.atozed.com/forums/forum-3.html) +---- Forum: English (https://www.atozed.com/forums/forum-16.html) +----- Forum: IntraWeb General Discussion (https://www.atozed.com/forums/forum-4.html) +----- Thread: another multi-user "see each other data" problem (/thread-1559.html) |
another multi-user "see each other data" problem - karolm - 03-01-2020 So i have created a desktop test app, before moving to intraweb, with SQlite and dbExpress and opened two copies of the app. I have one SQLConnection and two SQLQuery. SQLQuery1.SQL:=insert into topics(da,topic) values(1,'1') SQLQuery2.SQL:=insert into topics(da,topic) values(2,'2') there is a suspicious var Form1: TForm1; in the interface part, which I do not know how to remove In form.oncreate SQLConnection1.Connected:=true The first copy runs the first code Code: procedure TForm1.Button2Click(Sender: TObject); and the second copy runs the second code Code: procedure TForm1.Button3Click(Sender: TObject); When I run the codes one after another I get all right two records inserted into the database, but when I start the second code before the first transaction finishes, I get both OK messages but there appears only one record inserted in the database. The second transaction waits normally until the first finishes. |