This method is only active on MS-SQL where it can be used to switch
to uncommitted read mode which will not be blocked by other users
having locks on the desired data. Default is that reads are blocked
by other users having update locks on the desired data.
You should only use this method when unconsistent data can be
tolerated.
On MS-SQL writer blocks reader - meaning that any uncomitted writes
will block the reader in case of eg. a table scan.
Best regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
--- In [EMAIL PROTECTED], "Don Price"
<[EMAIL PROTECTED]> wrote:
> If you at the salesTable method Find, there is a new function
called
> selectLocked, has anybody used this before. I typically use
> selectforupdate. If you look at the context help for the
parameters it
> appears to be different lock types, one exclusive one shared.
Don't know
> why you would put on two different lock types?
>
> salesTable.selectForUpdate(_forUpdate);
> salesTable.selectLocked( (_forUpdate);
>
> Interesting enough InventTable and Custtable finds do not do the
> selectLocked.
>
> Can anybody set me straight on this?
>
> Thanks,
> Don
>
>
> [Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
