| View previous topic :: View next topic |
| Author |
Message |
Rhea Grason
Guest
|
 Posted: Wed Nov 09, 2005 5:01 pm Post subject: Isolation Levels |
 |
|
I use Delphi5 as the front end to Sybase SQLAnywhere databases. I am having issues with locking. I have several queries which return more than one row. When one user has a query open for viewing only and then another user tries to make a change to a record from that query, the app will hang until the other user closes the query, and then the changes will be saved. What exactly do I need to do to make it possible for changes to be made by one user while another user may be looking at the same query set? I am using the BDE and cached updates.
|
|
| Back to top |
|
 |
SQL
Guest
|
|
| Back to top |
|
|
Oliver Townshend
Guest
|
| Posted: Thu Nov 10, 2005 7:03 am Post subject: Re: Isolation Levels |
|
|
| Quote: | I use Delphi5 as the front end to Sybase SQLAnywhere databases. I am having
issues with locking. I have several queries which return more than one row.
When one user has a query open for viewing only and then another user tries
to make a change to a record from that query, the app will hang until the
other user closes the query, and then the changes will be saved. What
exactly do I need to do to make it possible for changes to be made by one
user while another user may be looking at the same query set? I am using
the BDE and cached updates.
|
You shouldn't do a StartTransaction and then wait for user input. You can
save up the Start and Commit to wrap around your BatchUpdate. At least
that's my theory about what's going wrong. Haven't used SQLAnywhere with
BDE in a decade.
Oliver Townshend
|
|
| Back to top |
|
|
Rhea Grason
Guest
|
| Posted: Mon Nov 14, 2005 4:49 pm Post subject: Re: Isolation Levels |
|
|
I don't call a start transaction in code until the user has clicked on the save button. Is that what you mean?
|
|
| Back to top |
|
|
Oliver Townshend
Guest
|
| Posted: Tue Nov 15, 2005 4:11 am Post subject: Re: Isolation Levels |
|
|
| Quote: | I don't call a start transaction in code until the user has clicked on the
save button. Is that what you mean?
|
Well yes and no. That won't be causing your locking problems then, unless
their is an implicit transaction somewhere else. Sorry I can't help.
Oliver Townshend
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
