Page 1 of 1

TZQuery Filtering oldvalue

Posted: 08.03.2013, 11:22
by nelsonroda
Example
TZquery returns:
ID Value1 Value2
1;1;10
2;1;1
3;2;2
4;2;1

when filtered is not true
for id = 2 the
query.FieldByName('Value2').OldValue gives 1.
If i make query.Filter := 'Value1 = 1';
for id = 2
query.FieldByName('Value2').OldValue gives 10.

How can i fix this.
Thx in advance.
NelsonRoda

Posted: 10.03.2013, 22:13
by mdaems
nelsonroda,

What compiler are you working with? This may have impact here, I think, because here we're looking at TField behaviour which isn't zeoslib code, but vcl/fcl-db code.

Is it possible to demonstrate this issue using a small command line program using our test database (included in the bigger snapshot releases or visible at http://sourceforge.net/p/zeoslib/code-0 ... /database/)
That would make reproducing and debugging a lot easier for me because then it's easily convertible into a test suite test.

Mark