Zeoslib Portal

Hello everybody,

first of all, excuse my very very bad English (I'm French and frenchies don't speak english very well ).
Special thanks to the dev team of these fabulous components.

If i'm posting here it's because I have a problem with tzquery's 'OldValue' and 'NewValue' functions : values are the same even if they are different...
And I have tried a lot of things... unsuccessfully.

Hello,

Nobody has tried this ?

What I would like to do is rebuild the query of the UpdateSQL object in order to insert/update only the fields which were modified, according to the differents tables of the view on which I work.

OldValue will store the original value of the field when the record is retreived for first time from the server. it stores the original value and not a value after a modification. So it functions for already existing records and not for newer ones

fduenas wrote:OldValue will store the original value of the field when the record is retreived for first time from the server. it stores the original value and not a value after a modification. So it functions for already existing records and not for newer ones

Ok, but in "beforepost", for a modified field or record, oldvalue and newvalue are always the same ! newvalue will only change after commiting the modifications ?

I have found a solution using datasource's "OnDataChange" !
I'm making an array with modified field names,
and in the tzquery's "BeforePost" method I'm modifying query's of tzupdate
object.

Thank you !