|Subject||Re: [firebird-support] How to implement SQLServer's WITH(NOLOCK) statment?|
At 05:26 PM 13/04/2008, you wrote:
>Hi,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 mind...so best you explain what you want to achieve.
>In SQLServer I can force a select statment to ignore any locks on a
>table (in effect having a shared read on the table).
>SELECT * FROM Items WITH(NOLOCK).
>How can I accomplish that in Firebird? should I use a special