Paradox Community

Items in pnews.paradox-programming

Subject:Re: Synchronizing priv tbls with master tbl
Date:Tue, 31 Jul 2018 07:46:01 -0400
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-programming
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