Paradox Community

Items in pnews.paradox-programming

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


Copyright © 2004 thedbcommunity.com