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
>>>>>
>>>
|