Open form function problem

[Lazy-legs]

Hello,

I'm using the following function to open a specified form in a database (borrowed from http://user.services.openoffice.org/en/ ... =20&t=2326):

Code: Select all

Function OpenForm (FormName As String) as Object
Dim Context As Object
Dim DB As Object
Dim Conn As Object
Dim FormDoc As Object
Dim Form AS Object
Dim Args(1) As New com.sun.star.beans.PropertyValue
Context=CreateUnoService("com.sun.star.sdb.DatabaseContext")
DB=Context.getByName("WriterDB")
Database=DB.getConnection("","")
Args(0).Name="ActiveConnection"
Args(0).Value=Database
Args(1).Name="OpenMode"
Args(1).Value="open"
FormDoc=DB.DatabaseDocument.FormDocuments.loadComponentFromURL (FormName,"_blank",0,Args() )
End Function

But here is the problem that really baffles me. When I add a new record or made changes to an existing one using the opened form, all changes are gone as soon I close OpenOffice.org. I have absolutely no idea why this happens.

Kind regards,
Dmitri

[DrewJensen]

Hi Dimitri,

Damn - that is issue 86855 and someone forgot to go back and put up the advanced code needed to open a form for the internal QA staff so they could confirm this.

Anyway - the work around is to open the ODB file first ( hide it if you like ) and then the changes are permanent -

Want an example?

[Lazy-legs]

Hi Drew,

Ah, I see. This is a rather annoying bug, but I think I can figure out how to open a database before I open a form. If I can't, then I get back and beg for your help.

Kind regards,
Dmitri

[DrewJensen]

LOL - no I knew you could..