Pulling data from notes using vb but it's caching for some reason

HCL Domino Domino Forum
1

Hello,

I’m pulling data from a Lotus Notes database, this works fine but when I change the data and pull it again, it doesn’t take the changes, a restart solves this so it must be getting cached somewhere, how do I prevent it?

Here’s my code:

Public Class Form1

Private Sub BtnTransMuk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnTransMuk.Click

    ListBox1.Items.Clear()

    Dim db As Object

    Dim NotesSession As Object

    Dim view As Object

    Dim doc As New Object

    NotesSession = CreateObject("Notes.NotesSession")

    db = NotesSession.GetDatabase("", "TestDatabase.nsf", False)

    If Not db Is Nothing Then

        view = db.GetView("All")

        doc = view.GetFirstDocument

        While Not (doc Is Nothing)

            ListBox1.Items.Add(doc.GetFirstItem("Status").text)

            doc = view.GetNextDocument(doc)

        End While



    Else

        MsgBox("Failed to find Database")

    End If

End Sub

End Class

2

Subject: Delete the NotesDocument object when you’re done with it…

The cache is probably occurring in the Notes end of things, and you need to forcibly delete the object to remove it from cache.