Discussion:
network / lock
(too old to reply)
Michel
2008-11-26 07:53:13 UTC
Permalink
Hello,
I have a multi users application; Ofently when trying to edit a row in a form a user recieves a lock message "Row is in use by another, Retrying lock" while another user is editing the same table but not the same row. Is it right ?
in the application ini file, Lock is set to OFF and Reprocess to 32000 (already tryed to 0), in BDE local share is set to True on each station.
thanks for remarks

Michel
Geoff Wass [dBVIPS]
2008-11-27 05:47:37 UTC
Permalink
Post by Michel
Hello,
I have a multi users application; Ofently when trying to edit a row in a form a user recieves a lock message "Row is in use by another, Retrying lock" while another user is editing the same table but not the same row. Is it right
?
Post by Michel
in the application ini file, Lock is set to OFF and Reprocess to 32000 (already tryed to 0), in BDE local share is set to True on each station.
thanks for remarks
Michel
Michel,

Does the form use a single table or a group of tables which are somehow
related to one another? It may not be the main table, but a child table
which is being "locked".
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
.|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
Michel
2008-11-27 09:04:38 UTC
Permalink
Post by Geoff Wass [dBVIPS]
Post by Michel
Hello,
I have a multi users application; Ofently when trying to edit a row in a form a user recieves a lock message "Row is in use by another, Retrying lock" while another user is editing the same table but not the same row. Is it right
?
Post by Michel
in the application ini file, Lock is set to OFF and Reprocess to 32000 (already tryed to 0), in BDE local share is set to True on each station.
thanks for remarks
Michel
Michel,
Does the form use a single table or a group of tables which are somehow
related to one another? It may not be the main table, but a child table
which is being "locked".
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
hello Geoff,
thanks for support.
effectivly, there is a parent/child relation between tables.
so, I've just found an article from Ken Mayer about this purpose saying : "The most common reason this error occurs is that not all of your queries, databases or datamodules are deactivated" at this adress :
http://www.dbase.com/knowledgebase/int/code_tips_tricks_advice/misccode.htm

I've just added some code following this remark, and tests will begin soon.
I let you informed in a few days
regards,
Michel
Geoff Wass [dBVIPS]
2008-11-28 05:59:17 UTC
Permalink
Post by Michel
hello Geoff,
thanks for support.
effectivly, there is a parent/child relation between tables.
http://www.dbase.com/knowledgebase/int/code_tips_tricks_advice/misccode.htm
I've just added some code following this remark, and tests will begin soon.
I let you informed in a few days
regards,
Michel
Michel,

Good luck. Keep us posted.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
.|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
Michel
2008-12-01 07:36:15 UTC
Permalink
Post by Geoff Wass [dBVIPS]
Post by Michel
hello Geoff,
thanks for support.
effectivly, there is a parent/child relation between tables.
http://www.dbase.com/knowledgebase/int/code_tips_tricks_advice/misccode.htm
I've just added some code following this remark, and tests will begin soon.
I let you informed in a few days
regards,
Michel
Michel,
Good luck. Keep us posted.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
.|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
Geoff,

issue seems to be solved ! 0 error message during 2 full working days (instead of many times a day)
regards,
Michel
Geoff Wass [dBVIPS]
2008-12-02 05:25:38 UTC
Permalink
Post by Michel
Geoff,
issue seems to be solved ! 0 error message during 2 full working days (instead of many times a day)
regards,
Michel
Michel,

That's sounds great. Thanks for the success report.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
.|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
Glenn Johansen
2008-11-28 15:47:10 UTC
Permalink
See autoLockChildRows in the OLH

- glenn
Post by Michel
Hello,
I have a multi users application; Ofently when trying to edit a row in a
form a user recieves a lock message "Row is in use by another, Retrying
lock" while another user is editing the same table but not the same row.
Is it right ?
in the application ini file, Lock is set to OFF and Reprocess to 32000
(already tryed to 0), in BDE local share is set to True on each station.
thanks for remarks
Michel
Michel
2008-11-28 20:22:08 UTC
Permalink
thanks for your interesting suggestion Glenn which should be helpfull; I did'nt see this setting in any discussing before.

Regards,
Michel
Post by Glenn Johansen
See autoLockChildRows in the OLH
- glenn
Post by Michel
Hello,
I have a multi users application; Ofently when trying to edit a row in a
form a user recieves a lock message "Row is in use by another, Retrying
lock" while another user is editing the same table but not the same row.
Is it right ?
in the application ini file, Lock is set to OFF and Reprocess to 32000
(already tryed to 0), in BDE local share is set to True on each station.
thanks for remarks
Michel
Continue reading on narkive:
Loading...