Paradox Community

Items in pnews.paradox-programming

Subject:Re: Synchronizing priv tbls with master tbl
Date:Wed, 1 Aug 2018 13:02:25 -0500
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-programming
Datarefresh, datarefreshoutside have always been quirky for me.
Datarecalc will sometimes refresh things.
Moving to the beginning of the table and back again sometimes work too.
I actually have better luck with network refreshes updating faster than 
local ones.

On 7/31/2018 8:31 PM, Peter wrote:
> 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