Paradox Community

Items in pnews.paradox-programming

Subject:Re: lockRecord() - doesn't
Date:Wed, 20 Jul 2022 20:18:15 -0800
From:Peter <peterspammenot@whiteknight.email>
Newsgroups:pnews.paradox-programming
BDE is setup exactly the same on every machine. LocalShare = true is 
confirmed on all machines.

2 WinXP machines, 2 Win7 machines- 1 of these Win7 machines is a 
dedictaed server for all files, which is also configured to be 
MasterBrowser and all other machines set to NOT be master browser, i.e. 
masterbrowser disabled.

No Win 10/11 machines.

If the table is locked by interactive editing, then the locking system 
works on all machines, i.e. they will not open and the error pops up 
that the table is locked by another user, whether interactive or 
programmatically.

If the lock is a record lock (lockRecord() ) then it has no effect on 
the other machines, I can make table changes interactive or 
programmatically and also enumlocks does not show the record lock of the 
  machine that set the record lock.

Does it work properly for you?



On 07/20/2022 07:49 p.m., Tom Krieg wrote:
> WinXP and Win7 networking are different. Have a look for a mix of SMB 
> versions. Different networking protocol. Make sure it's all the same. 
> Are the tables on aserver? Or one machine using Paradox sharing with 
> others? BDE set up exactly the same? Local share = true on EVERY 
> machine?  Are there Win10 or 11 machines on the network?
> 
> When you lock a record on one machine, can you move to that record on 
> another machine and lock it also?
> 
> On 21/07/2022 12:18 pm, Peter wrote:
>> Exact, caps and all.
>>
>> Another experiment
>> Opened same table on three machines. Interactively, modified table on 
>> one Machine and saw changes ripple to the other machines. Strange 
>> enough, changes on one machine (Laptop WinXP) caused the Win7 machine 
>> to refresh the table but the other machine (WinXP) would not refresh 
>> until I did enumlocks() or something to refresh the table manually.
>>
>> I would conclude the machines are talking to each other and the Pdox 
>> locking mechanism is working, sorta/kinda.
>>
>>
>> On 07/20/2022 06:03 p.m., Tom Krieg wrote:
>>> Do all machines point the BDE to the same IDAPI32.cfg file? It must 
>>> be the exact same path (the drive letter can be different but the 
>>> path must be the same).
>>>
>>> On 21/07/2022 9:35 am, Peter wrote:
>>>> Just ran some tests on a customer's system that uses Windows Server. 
>>>> Got the exact same results.
>>>>
>>>> It seems that enumlocks() will not report recordlocks (lockrecord() 
>>>> ) placed on a different machine.
>>>>
>>>>
>>>>
>>>> On 07/20/2022 12:45 a.m., modridirkac wrote:
>>>>> Did you set Local share to false, in BDE?
>>>>> It should be TRUE.
>>>
> 


Copyright © 2004 thedbcommunity.com