Subject Re: [firebird-support] How to implement SQLServer's WITH(NOLOCK) statment?
Author Helen Borrie
At 05:26 PM 13/04/2008, you wrote:
>In SQLServer I can force a select statment to ignore any locks on a
>table (in effect having a shared read on the table).
>How can I accomplish that in Firebird? should I use a special
>connection string?

You don't - because you never need to ask for "shared locks" in Firebird. Shared read always applies. Locks don't exist until a transaction requests a write and the request succeeds. You can set certain transaction parameters to govern behaviour, if you have a particular behaviour in best you explain what you want to achieve.