Zeoslib Portal

I search/read this forum, but I can't find any suitable solution to this problem.

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....

Hi try to use the TZUpdateSQL object, it has now a property refreshSQL where you can add this kind of sql, TZUpdateSQL have to be attached to the TZQuery or tztable. try to download at least revision 98 of zeosdbo version, it is now published here and have this property.