Hi everyone, I have Domino 8.5.1 running on Win 2003 SRV, domino is DB2 enabled, DB2 is 9.1.2.
I have two DB2 enabled databases, both dbs have a DAV.
In one db I built a QueryView joining data from the two DB2 VIEWS (the views created by DAVs).
Everything works fine, the Notes QueryView is populated,
BUT i cannot access the document:
the error is “DOCUMENT HAS BEEN DELETED”.
I can see the documents in the view but i cannot access them.
Via LotusScript, a View.getAllEntries, can get the entries, but not the document:
NotesVECollection = View.GetAllEntries → the collection is properly populated.
NEntry = NotesVECollection.getfirstEntry
NotesDocument = NEntry.Document
→ NEntry is fine
→ NotesDocument is NOTHING…
I really don’t understand this behaviour…
also i’m not 100% sure i can join data from DAV on two differents dbs.
P.S.:
I’m successfully using this Notes Query View to display data on an Xpage in a View Control…
Please any help will be much much helpful!
Thanks
Marco