Subject: | Re: Synchronizing priv tbls with master tbl
| Date: | Tue, 31 Jul 2018 13:19:51 -0700
| From: | Peter <peter@whiteknight.email>
| Newsgroups: | pnews.paradox-programming
|
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
>>>
>
|