Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Update SQL and records currently being edited by other users |
Tue, Jun 5 2007 3:36 AM | Permanent Link |
"Al Vas" | Hi,
If I run an SQL update statement on a table, what happens when it comes across a record that is being used by another user? Does it update all the other records or does the statement stop at the point it cannot update a record and not perform the rest of the updates. DBISAM V3.30 Thanks Alex |
Tue, Jun 5 2007 4:01 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Al
I think this is where you need transactions. My understanding is that the changes will be made up to the point where it can't lock the record where it will crash. Roy Lambert |
Tue, Jun 5 2007 10:57 AM | Permanent Link |
Jason Lee | What locking model are you using: pessimistic or optimistic?
Regards, Jason Lee Al Vas wrote: > Hi, > > If I run an SQL update statement on a table, what happens when it comes > across a record that is being used by another user? Does it update all the > other records or does the statement stop at the point it cannot update a > record and not perform the rest of the updates. DBISAM V3.30 > > Thanks > > Alex > > |
Tue, Jun 5 2007 1:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Alex,
<< If I run an SQL update statement on a table, what happens when it comes across a record that is being used by another user? Does it update all the other records or does the statement stop at the point it cannot update a record and not perform the rest of the updates. DBISAM V3.30 >> You'll get a record lock error if DBISAM cannot update any single record that it needs to because it can't get a lock, and the update will stop at that point. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |