If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > data not updating across network

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-25-11, 06:49
greatbrit greatbrit is offline
Registered User
 
Join Date: Aug 2004
Posts: 3
data not updating across network

Hello everyone,

Here's the problem:
If I change any field on a form on one PC, it does not update the same field on the form of the other PC.

One weird thing is that if I change the field in the actual table on my development Vista PC (while the application is running), then I instantly see the change on my PC's form, but again, it does not appear on the XP PC's form.

If I close the form, then re-open it, then the field shows the correct data.

The application consists of 3 PCs. The data on a shared mapped drive (T:\mydata) on one PC, and forms stored locally on C: on each of the two PCs running the app. My development PC is Vista, the other is XP with latest service packs, running Pdox Runtime. BDE 5.01. Paradox 10.

In the BDE, 'net dir' is set to T:\myfolder. Share = TRUE. The application starts with a -o option ensuring they are both using the same idapi.cfg (and I have checked that the BDE looks identical on both PCs.

I am very rusty on networked apps, but I thought if you change a field on one PC, it would automatically update in on another PC. Am I missing a setting somewhere? Any other ideas what is going wrong? Many thanks in advance for any ideas.
Reply With Quote
  #2 (permalink)  
Old 08-25-11, 08:54
Steve Green Steve Green is offline
Registered User
 
Join Date: Dec 2007
Posts: 282
a) are you just changing a field, or have you actually posted the changed record?

b) could you have some code buried in the app that sets the network refresh to zero (which actually turns off the refresh)?
__________________
--
Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies
Reply With Quote
  #3 (permalink)  
Old 08-25-11, 09:41
greatbrit greatbrit is offline
Registered User
 
Join Date: Aug 2004
Posts: 3
Quote:
Originally Posted by Steve Green View Post
a) are you just changing a field, or have you actually posted the changed record?

b) could you have some code buried in the app that sets the network refresh to zero (which actually turns off the refresh)?
a) The form has a table in edit mode, so I just change the value of a field on the form. But I also tried it with going to the actual table and making the change there (then moving off the record). That updated my development form, but didn't update the XP PC. But I know that both PCs are pointing at that same data as I can exit the form, then return, and it is then correct.

b) Certainly not that I know about. What would I search for to look for that? Can I set something to force it to work?

Thanks very much, I appreciate the help.
Reply With Quote
  #4 (permalink)  
Old 08-25-11, 09:49
Steve Green Steve Green is offline
Registered User
 
Join Date: Dec 2007
Posts: 282
sounds more like network refresh, not internal refresh.. oplocks, write caching, etc.. as I suggest in almost EVERY thread here, go to the paradox community site, where you'll find way more help than just me..

Home - Paradox Community

go to Support / Newsgroups
__________________
--
Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies
Reply With Quote
  #5 (permalink)  
Old 08-25-11, 10:16
greatbrit greatbrit is offline
Registered User
 
Join Date: Aug 2004
Posts: 3
tyvm Steve, giving that a try now.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On