| Subject | Re: [firebird-support] How to implement SQLServer's WITH(NOLOCK) statment? |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-04-13T08:30:17Z |
At 05:26 PM 13/04/2008, you wrote:
./heLen
>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
>connection string?
./heLen