Paradox Community

Items in pnews.paradox-programming

Subject:Re: Synchronizing priv tbls with master tbl
Date:Tue, 31 Jul 2018 18:31:40 -0700
From:Peter <peter@whiteknight.email>
Newsgroups:pnews.paradox-programming
Well, sporadic at best.
I've spent days on this problem, time to move on.

I ended up creating a 3 second timer that issues a DataLockRecord and 
immediately DataUnLockRecord. This updates the field on the other 
machines instantly. I will add a setTimer(3000) on the records' arrive 
event, maybe the form's mouseclick?

Thanks for chipping in the ideas guys.

Peter


On 07/31/2018 01:19 PM, Peter wrote:
> Thanks for the tip. I do perform a lock/unlock but does not have the 
> desired effect.
> 
> I was under the impression that the basic function was when a user has 
> the same form open and makes a change to a table (that is in the data 
> model) that the other user would receive a "DataRefreshOutside" and the 
> field being displayed would be updated automatically.
> 
> I need a trigger on the form when another user makes a change to a field.
> 
> Peter
> 
> 
> On 07/31/2018 04:46 AM, Steven Green wrote:
>> you can specify the cfg file to use, on the command line
>>
>> you should specifically try to lock a record in a multi-user 
>> environment.. you should specifically try to post a changed record in 
>> a multi-user environment
>>
>> -- 
>>
>> Steven Green
>> Myrtle Beach, South Carolina, USA
>>
>> http://www.OasisTradingPost.com
>>
>> Collectibles and Memorabilia
>> Vintage Lego Sets and Parts
>> - and Paradox support, too
>> "Peter"  wrote in message news:5b5fbc73$1@pnews.thedbcommunity.com...
>>
>> Did some more research. I found that one of the machines is using
>> IDAPI.cfg and the other 2 are using IDAPI32.cfg.
>>
>> Can someone tell me how to force Pdox to use IDAPI32.cfg because when I
>> eleiminate the IDAPI.cfg it just makes a new one. Thank you.
>>
>> Peter
>>
>> Update:
>> Registry:
>> Local_Machine\Software\Borland\Database Engine\CONFIGFILE01 (changed
>> from IDAPI.cfg to IDAPI32.cfg).
>>
>> That seems to have done it, now all 3 machines are running idapi32.
>> Unfortunately it has not amde a difference :(
>>
>> Peter
>>
>>
>> On 07/30/2018 11:15 AM, Peter wrote:
>>> Thanks for the feedback everyone.
>>>
>>> I built the server and got it to be the master browser, tested, same 
>>> inconsistent results. Now I am completely flummoxed.
>>>
>>> It seems to me in a multi-user environment that if user_1 is viewing 
>>> a table and user_2 changes a field that user_1 should see the field 
>>> contents updated within the set refresh rate. I thought this would 
>>> apply equally whether viewing a table displayed or via form.
>>>
>>> Barring any other ideas I guess I'll have to come up with a different 
>>> strategy for syncing.
>>>
>>> Peter
>>>
>>>
>>>
>>> On 07/28/2018 06:31 AM, Steven Green wrote:
>>>> 1) always have a dedicated server, if possible.. a shared server is 
>>>> using half the cycles to be a server, half the cycles to be a 
>>>> workstation.. and if you lock up or crash the "workstation", you've 
>>>> crashed your server
>>>>
>>>> 2) in your example / test, you are depending on paradox to control 
>>>> and protect a multi-user app.. up to a point, it does.. but if your 
>>>> app posts, locks, error traps, etc., then YOU control it
>>>>
>>>>
>>>> -- 
>>>>
>>>> Steven Green
>>>> Myrtle Beach, South Carolina, USA
>>>>
>>>> http://www.OasisTradingPost.com
>>>>
>>>> Collectibles and Memorabilia
>>>> Vintage Lego Sets and Parts
>>>> - and Paradox support, too
>>>> "Peter"  wrote in message news:5b5b75a3$1@pnews.thedbcommunity.com...
>>>>
>>>> I checked all the machines, 1 of the workstations had Enable Offline
>>>> Files checked so I unchecked it.
>>>>
>>>> I make the change in a field and simply move to the next record (no
>>>> code). I do this on the table, I also tried it on a test form.
>>>>
>>>> I also checked the "Folder Options" in W-Explorer and made sure the
>>>> following were checked on all 3 machines
>>>> Automatically search for network folders and printers
>>>> Use simple file sharing
>>>>
>>>> I've spent over 10hrs chasing this demon and am thinking the best thing
>>>> is to build a dedicated server.
>>>>
>>>>
>>>> On 07/27/2018 07:05 AM, modridirkac wrote:
>>>>> You do PostRecord and/or UnlockRecord after changing field, do you 
>>>>> (or just move to next line)?
>>>>> You have checked "No files or progarms from the shared folder are 
>>>>> available offline" in folder's sharing properties on "server"?
>>>>>
>>>>>
>>>>> Jure
>>>>
>>


Copyright © 2004 thedbcommunity.com