Multiple Database Application with Framesets

HCL Domino Domino Forum
1

I am developing an application using two “back-end” databses (1. accounts & 2. sales activity) which are accessed by a third “front-end” (shell) database.

The shell db contains only framesets and a few pages. The framesets are populated by views from either the accounts database or the sales activity database.

Sporadically, I get “frameset “x” does not exist” error when trying to change from one back-end database to another.

How do you gracefully combine several databases in an application? I’d like to have separate ACL lists to control each aspect of the back-end databases.

2

Subject: Multiple Database Application with Framesets

I had the exact same issue and ended up using documents instead of Pages. The “dummy” documens have embedded views on them that are computed based on a value on the form. This gives me the ability from my main front-end to populate a frame with views from multiple databases all while using the existing ACL fo the respective databases. Heres a sample of the code:

Set db = session.CurrentDatabase

Set uidoc = uiws.CurrentDocument

Set doc = uidoc.Document



'-- get the Server to open

found = getDB(strDB, thatDB)



If found = True Then

	

	Set iDoc = New NotesDocument(thatDB)

	With iDoc

		.form = "dspCategory"

		.dspKey = strKey

		.dspLabel = strLabel

		.dspView = strView

		.dspWindow = strWindow

	End With

	

	Call uiws.SetTargetFrame("DetailView")

	Call iDoc.Save(True, False)

	Set uidoc = uiws.EditDocument(True, iDoc, False, , , )

	

End If