Hi,
I am using version 3.13. Here is the problem.
Page 1 shows 3 different lists pertaining to a single ID.
- Each list is a 'Repeated' with it's own Data Object (These are
Retrieving Data Objects).
- Two of the data objects are using ORACLE Views and one a Base Table.
- In the (On Before Data Object....) event, the dynamic criteria of
each data object is cleared and the ID Number is added as
dynamic criteria
- The lists look fine in the initial load of the page - each list is
correct
Page 1 has an ADD ITEM button that takes you to Page 2. After a successful
ADD ITEM, Page 2 loads page 1 (SHOW LISTS) (with 'clear before display' =
true). Now when the page loads, the SQL for each data object is exactly
the same as when it loaded initially, but the results of one list should
now include the added item - but it does not.
Lists 1 and 2 do not refresh properly if an item has been added. List 3 is
ok. When the list involves a view, the only way to see a new item is to
leave the application entirely and to come back in.
This appears to be a caching problem. Maybe because the SQL is the same,
the object is not re-executing???? Another possibility is that the view is
cached and therefore it is not refresed.
Any ideas will be greatly appreciated.
Kathy
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
