Dear Experts,

I found the bug! The culprit was another SQL statement executing in the background which got the value of the main CA's WhereClause! This 'background' sql was supposed to get the total number of records at every refresh.

Thank you so much to everyone who has spared the time and effort in helping solve thru this!

Love live the Fox!

Dennis