Board index » delphi » Querys w/cached updates don't refresh correctly in Multi-User environment with Paradox

Ing. Antonio E. Mejía Weir

Delphi Developer
Sat, 02 Sep 2000 03:00:00 GMT

Querys w/cached updates don't refresh correctly in Multi-User environment with Paradox

Im using querys with cached updates, but when Im in a multi-user
environment for some reason I cant see what the other users are doing
when I refresh the query closing it and opening it again. Ive tryed
different things:

- Changed the ChachedUpdates property to false and then back to true.
- Called the Unprepare method.
- Changed the select statement to a generic one and back to the one I
need.

None of these seems to work. Apparently it has something to do with the
Paradox driver, because if I switch to Interbase, it works fine!.

Has anybody encountered this problem?, and if so, How did you fix it?.

 
Brian Bushay Tea

Delphi Developer
Sun, 03 Sep 2000 03:00:00 GMT

Re:Querys w/cached updates don't refresh correctly in Multi-User environment with Paradox


Quote

>None of these seems to work. Apparently it has something to do with the
>Paradox driver, because if I switch to Interbase, it works fine!.

Do you have Local Share set to TRUE?

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Ing. Antonio E. Mejía Wei

Delphi Developer
Sun, 03 Sep 2000 03:00:00 GMT

Re:Querys w/cached updates don't refresh correctly in Multi-User environment with Paradox


Yes,  LOCAL SHARE is set to True.
Also the NetFileDir and the PrivateDir are set correctly.

Quote
Brian Bushay TeamB wrote:
> Do you have Local Share set to TRUE?

> --
> Brian Bushay (TeamB)
> Bbus...@DataGuidance.com

Other Threads

1. Cached Updates don′t seem to work rigth with Paradox Driver in Multi-user environment

2. How can I refresh data in multi-user environment

3. Confirmed D2 bug: cached updates don't work for master/detail - here's why

4. BDE can't handle transaction correctly with cache updates

5. Problem with table updates in a multi-user environment

6. Ho to control if a table is updated from another user in a multiuser environment

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

8. Help: updating multiple local database tables with unique id's in multiuser environment

9. Cached updates and multi-user

10. D1, dbf - refreshing grids in multi-instance (multi-user) case