This will not be a problem - becaurse only one user can select the
record for update at a time.
Best regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
--- In [EMAIL PROTECTED], "Don Price"
<[EMAIL PROTECTED]> wrote:
>
> Hi Karsten,
>
> Thanks for the information, but that has me a little confused,
when you
> say: You should only use this method when unconsistent data can be
> tolerated.
>
> This method is being called in the static SalesTable::Find method,
I
> would expect you wouldn't want inconsistent data here.
>
> What happens when two users call this method
> Ie
> user A reads record 1.
> User B reads record 1.
> User A updates field 1,3 and calls update
> User B updates field 1,2 and calls update
>
> I would suspect field 3 update is lost?
>
>
>
> Thanks,
> Don
>
> -----Original Message-----
> From: kwc_thydev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 09, 2004 4:29 AM
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] Re: selectForUpdate SelectLocked
>
> Hi,
>
> 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 Links
| 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.
