First thing I would do is turn on all levels of logging and see exactly
what SQL is being executed, and when.
-- Curt Springer, Team ND
At 05:11 PM 7/12/99 -0400, Kathleen Hoppe wrote:
>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]
>
_________________________________________________________________________
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]
