Hello,
I noticed a situation where a Servoy client was waiting because some other user was changing a record that the client also wanted to read.
I want to avoid this, so I want to do dirty reads.
Since this looks to me as a database problem, I found in my case, that my database connection needs an extra line.
I am using SQL Server 2005, so I want to add the following line:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
But there is no way from Servoy to give extra statement when creating a database connection.
I even don't know if a db connection stays alive as long as the client has connection.
Or even the DB-connection is handled by the Application Server and not by Smart Client.
In that case, how many db connection will there be?
I was thinking about sending a RawSQL statement on open of my solution, but will that really work or is there another way to do that?
Martin