I have two related tables in a database with 90% of the data going into
the database using straight SQL queries. Call the tables "unit" and
"part". Each unit can have many parts.
Now I do a SelectQuery on unit, and then step through the "parts" for
every "unit" in the result. If a new part is added, or an old part is
removed using SQL I don't see this change when I perform the query
again. This is because the parts are in the cache.
How do I invalidate the parts so they get reloaded? Do I need to run
ctxt.invalidateObject on every (cached) part before doing the "unit"
query again? Should I do a query on "part" that returns (and refreshes)
the correct subset of parts for the specific "units"?
Is there an easier way to ensure I get refreshed parts?
This archive was generated by hypermail 2.0.0 : Tue Mar 16 2004 - 19:46:05 EST