Transactions and waitlock is a good solution. Introduce a boolean field like reclocked before editing set it to 'Yes' and check if reclocked is 'No' before editing. Once you are done with editing reset it to 'No'. Just give a try.
Krishna.
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Thomas,
Nexus should be able to use transactions and a wait-lock.
Did you try-except your edit or post or commit-statements to catch any errors?
have more fun!
Bob
>
> I am using NexusDb version 1.08 and it does give me an error when a
> record is locked. Unfortunately it does not resolve the conflict by
> preventing the second user from editing the record. Which means that
> the first user can't exit the record and post because the second user is
> still editing the record.
>
> I am guessing that this is a problem that is tied to the Blob Memo that
> the user is trying to edit. Since Blob memos are handled differently
> than regular records, I am thinking that is why I am getting these ugly
> error messages.
>
> What do you suggest?
>
> Tom Nesler
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, April 26, 2006 11:00 AM
> To: [email protected]
> Subject: Re: [delphi-en] Using the TTable Edit Error Event
>
>
> Hi Thomas,
> as usual "it depends".
> Which Database do you use? A "normal" SQL Client / Server RDB (as
> Firebird or Interbase) is able to handle that automatically.
> So, which Delphi version and which DB you are talking about.
>
> Have fun
> Bob
>
>
> >
> > I am working on a multiuser application. One of my problems is
> record
> > locking, specifically when one user is editing a blob field and
> another
> > is editing the same record.
> >
> > I am guessing that I need to put some code in the Edit error event
> but
> > there is no example in the Delphi help file so I can only guess
> how to
> > use it correctly.
> >
> > Can some one give me an example on how to trap a record locking
> error
> > using this event? Also what do you recommend for help in
> understanding
> > the complexities of multiuser databases?
> >
> > Thanks in advance!
> >
> > Tom Nesler
> > Live long!... Code Well!... and Prosper!... V
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > -----------------------------------------------------
> > Home page: http://groups.yahoo.com/group/delphi-en/
> > To unsubscribe: [EMAIL PROTECTED]
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>
>
>
> -----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe: [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
>
>
>
>
> -----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe: [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
>
>
>
>
>
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "delphi-en" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Celebrate Earth Day everyday! Discover 10 things you can do to help slow climate change. Yahoo! Earth Day
[Non-text portions of this message have been removed]
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
SPONSORED LINKS
| C programming language | Computer programming languages | Java programming language |
| The c programming language | C programming language | Concept of programming language |
YAHOO! GROUPS LINKS
- Visit your group "delphi-en" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
