Base macro: refresh table?

[Dalius]

I have a form with several tables and they use queries to select data. After modifying the data in MySQL server with macros, how do I refresh the tables ?

This refreshes only the first table:

oDisp = createUnoService("com.sun.star.frame.DispatchHelper")
oFrame = ThisComponent.getCurrentController().getFrame()
oDisp.executeDispatch(oFrame, ".uno:Refresh", "", 0, Array())

This doesn’t work at all:

oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDataSource = oBaseContext.getByName(dbName)
oCon = oDataSource.getConnection("", "")
oCon.getTables().refresh()

Please help, I need this done ASAP and I’m really new at LibreOffice Base, can’t figure this out.

[Dalius]

Sub reloadAllTables
    Dim Forms : Forms = ThisComponent.DrawPage.Forms
    Dim i%
    For i = 0 To Forms.getCount()-1
        Forms.getByIndex(i).reload()
    Next
End Sub

[Dalius]

someone please accept this, i’m getting e-mail but can’t accept it myself…