Method REFRESH - is VERY bad solution, because it reload all records from server.
I use MYSQL 5. An triggers to calculate some field values before update/insert. But I cant see this values in my client.
In Firebird/interbase access components FibPlus is property - RefreshSql, This SQL is running when method REFRESH is executioned. When I set this method to something like this
"select * from table where ID= :OLD_ID"
only one - current record is loading form server - VERY QUICK. And this show record values - set from triggers....
In case of ZEOSlib I can't use generators to set field values. Or i need refresh all dataset after every post and lose performance....
