I have been playing around with a FilteredRowSet for a while, and found some very strange behavior that puzzles me a lot.
I have a small predicate that only allows names starting with "c" and when I try to insert eg. "klaus" I get a SQLException saying "value is not allowed by the filter" which is what would expect.
However when I try to update a name from "claus" to "Klaus" I'll get nothing , even updateRow() and acceptChanges() does not raise any error even though the value is never written to the db. Is this how it’s supposed to work or?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Understanding FilteredRowSet and Predicate