I have 2 Databases, one of them is only used in a thread and therefore in locking mode exclusive. No problem here.
the 2nd is used by main thread and thread: the thread writes a integer value (1 or 2), the mainthread requests this value.
the thread and mainthread have their own tables to use, the table in mainthread is set to "read only"
both databases are set Options.Direct := True; Options.UseUnicode := True; Options.ReadUncommitted := False;
The table is closed in Mainthread.
To read the value I do:
Code: Select all
TbSwitch.Open; TbSwitch.Refresh; case TbSwitchSwitch.AsInteger of ...
No Changes are registered.