开发者

Crystal Reports with SQL Server 2005: Setting Transaction Isolation Level

开发者 https://www.devze.com 2022-12-11 15:40 出处:网络
Is there a way to specify the transaction isolation level when Crystal Reports queries a SQL Server 2005 database without resorting to any of the following:

Is there a way to specify the transaction isolation level when Crystal Reports queries a SQL Server 2005 database without resorting to any of the following:

  • Encapsulating the report's query in a stored procedure that executes SET TRANSACTION ISOLATION LEVEL... before the query itself
  • Han开发者_如何学Pythond-writing the SQL query in Crystal Reports to execute SET TRANSACTION ISOLATION LEVEL...


I was able to embed this in a Command object:

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

--Command objects need to return a value
SELECT GetDate()

This Command object was in addition to the query that I 'wrote' in the Database Expert.

Will you elaborate on the necessity of setting the ISOLATION LEVEL?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号