Hi all,

Workin with 2 tables concurrent access, I'm running into the folowing issue:

Table a (requests) with a flag field
Table b (orders)

- Rows from table a are displayed in a dbgrid, filtered based on flag field (only empty flags are displayed on grid)
- User 1 select a row from table a and copy it to table b, updating flag field, thus becoming invisible in grid, after refreshing table a
- At same time, User 2 select a row from table a and try to copy it to table b and error 1008 rises: Row has been modified since cached...
- Catch the exception and show a corresponding message. Try again. Same error.

Is it possible to flush the cache so the error condition it's cleared and User 2 can complete his operation ?

Hope I make myself clear...

Thanks

Sergio

sergioarc


Try refreshing the table. That should result in the flagged rows no longer being shown.

Roy Lambert [Team Elevate]