Application has a ToraSession and several MultThread.
Application.mainform.create:
begin
GameDb.Server := '127.0.0.1';
GameDb.Username := 'test';
GameDb.Password := '1';
GameDb.Options.Net := false;
GameDb.ThreadSafety := True;
GameDb.Open;
end;
MultThread.execute :
var
query:ToraQuery;
NowName,id :string;
begin
//.........Get values
NowName:='vkes';
id :='a123';
//.........
try
Query := Toraquery.create(nil);
try
Query.Session := GameDB;
Query.sql.Text := 'update userb set name=' + quotedstr(NowName)+' where ID= ' + quotedstr(id);
adoQuery.execute;
finally
FreeAndNil(query);
end;
except
//.............deal errors
//..............
end;
end;
Puzzle: Does ToraSession need critical directive symbol when MultThread execute SQL.[/quote]
Puzzle: ToraSession and MultThread
-
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53