Table Closes When Returning to Original Page

[rdd1963]

I have an app with two pages, when I switch to the second page, my data is synced with the first page as it should be. However, when I return to the first page using a command button, the table I am using is closed and I have to reopen it manually or add a use field in my activate delegate, but when I do this, it defaults to the first record. I looked through my code and cannot find where the table is closing. Is there a delegate that will keep the table open on my first page so when I return to it, it is still on the same record? Just trying to determine if it is a coding error or lack of understanding of Lianja.

[hmischel@diligentsystems.com]

Hi Rdd,

That sounds unusual.
In the section attributes on your first page, can you check if the database and tablename are showing up correctly.

Herb

[barrymavin]

What type of sections are page1 and page2?

Are you closing the table anywhere in a delegate? If you are you should not be.

Are you querying a table which is bound to a section? If you are you need to wrap that code in:

SAVE DATASESSION
...
RESTORE DATASESSION

Which will maintain the context of the open cursors.

[rdd1963]

I now just have canvas sections on both pages, but you got me looking at a section where I had an unneeded select command for a database that was already in use. Problem solved.