Refresh Method in Tables 1

[Gigatech]

I'm a Delphi 5 user. I'm using Paradox Database in a network environment. When I add a record in a machine, I can't see it in the other machines although I call the Refresh method. I'm using a DBGrid object for the view.

The worst consequence is that 2 users can add records with the same primary key and then the server keeps
the latest.

It is only when I exit the program and then run it again that I see the records that the other machines in the network added.

Thanks

 

[footpad]

GigaTech,

It sounds like you need to enable LOCAL SHARE on each workstation. To do this, start the BDE Administrator control panel applet. Then:

1. Choose the Configuration tab.
2. In the settings tree, choose System | INIT.
3. In the Definition tab, set LOCAL SHARE to TRUE.
4. Choose Object | Apply or click the Apply toolbar button.
5. Exit and restart all BDE client applications.

This should take care of your problem. If it doesn't, make certain that your network operating system doesn't use optimistic locking. If it does, you'll need to disable that.
Yes, I know it slows performance, but there's no helping that.

Hope this helps...

-- Lance