Board index » delphi » table.refresh doesn't refresh?

Federico Balbi

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

table.refresh doesn't refresh?

Hi,
  I am using table.refresh method to refresh data on a paradox table that
is connected to a PC on the net that stores data.
If I run 2 or more images of the same application on the server PC I have
the correct refresh, but if I run my app on a remote client there's no
way to have my data updated when another user post/edit/delete a record.

I know there's a TNetDataLink component on the web, but how comes that the
refresh method doesn't do the job? Are there particular parameters to set?
Doesn't work on peer-to-peer connection?

Thanks,
ba...@poboxes.com

 
Markku Nevalaine

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:table.refresh doesn't refresh?


Quote
Federico Balbi wrote:

> Hi,
>   I am using table.refresh method to refresh data on a paradox table that
> is connected to a PC on the net that stores data.
> If I run 2 or more images of the same application on the server PC I have
> the correct refresh, but if I run my app on a remote client there's no
> way to have my data updated when another user post/edit/delete a record.

If the other network users don't see each others updates to shared
BDE/Paradox database, it almost always means that the NetFiledir
settings are not right.
Everyone should have the Netfiledir setting for example X:\MYDIR\DATA,
pointing to the same shared directory, and only the letter 'X' may vary
between different users. Otherwise lockings won't work, but sooner or later
corrupts your database.

Markku Nevalainen

Shu

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:table.refresh doesn't refresh?


Thats because on the client doing the updating the changes are caught in the
disk cache. You have to tell the BDE to write em to the disk. Can't remember
the command but it is in the BDE somewhere.
Quote
Federico Balbi wrote:
> Hi,
>   I am using table.refresh method to refresh data on a paradox table that
> is connected to a PC on the net that stores data.
> If I run 2 or more images of the same application on the server PC I have
> the correct refresh, but if I run my app on a remote client there's no
> way to have my data updated when another user post/edit/delete a record.

> I know there's a TNetDataLink component on the web, but how comes that the
> refresh method doesn't do the job? Are there particular parameters to set?
> Doesn't work on peer-to-peer connection?

> Thanks,
> ba...@poboxes.com

Wood

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:table.refresh doesn't refresh?


If you set LocalShare to true, the BDE won't cache the updates. It
will write them to the database right away so the refresh should then
work.

Woody

Quote
Federico Balbi wrote in message ...
>Hi,
>  I am using table.refresh method to refresh data on a paradox table
that
>is connected to a PC on the net that stores data.
>If I run 2 or more images of the same application on the server PC I
have
>the correct refresh, but if I run my app on a remote client there's
no
>way to have my data updated when another user post/edit/delete a
record.

>I know there's a TNetDataLink component on the web, but how comes
that the
>refresh method doesn't do the job? Are there particular parameters to
set?
>Doesn't work on peer-to-peer connection?

>Thanks,
>ba...@poboxes.com

Stephen Brow

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:table.refresh doesn't refresh?


Use the AfterPost event to call DbiSaveChanges(<dataset name>.handle).
You'll need to add BDE to the 'uses' section.

--
Stephen Brown

Quote
Shu wrote in message <3640BFCF.651ED...@thegrid.net>...
>Thats because on the client doing the updating the changes are caught
in the
>disk cache. You have to tell the BDE to write em to the disk. Can't
remember
>the command but it is in the BDE somewhere.

Other Threads

1. DBNavigator.Refresh doesn't (refresh) ??

2. DBNavigator.refresh doesn't (refresh) ??

3. D3 - refreshing of tables - refreshing tables update by one user to show to other users

4. refreshing tables - remote refresh -developing code

5. Refreshing tables - remote refresh -developing code

6. Refresh Component, and refreshing tables for another user

7. Query.Refresh doesn't work???

8. Why Doesn't TTable.Refresh Work Here?

9. TTable.Refresh doesn't

10. RichEdit doesn't refresh after a search and replace