Hello Friends,
CachedUpdate and Autocommit are two properties very important !
With unigui, we are talking about a hundred users connected at the same time.
In such multi users environement, if your CachedUpdate is False (as by Default with IBDAC /Devart),
any changes by others users, on a UniDBGrid will attack directly your physical DataBase !
And if you are on this record (80% by chance), you will get this error : Conflict Record.
Solution :
Make sure :
__________________
Autocommit := False;
CachedUpdate := True;
__________________
it tooks me 4 hours to track the pb !
Regards