Ask Your Question
0

How to fix :“Not Enough Stack Memory” when trying to load() with OfficeDatabaseDocument UNO service

asked 2019-08-13 15:48:32 +0200

Ekiza gravatar image

updated 2019-08-15 16:47:02 +0200

EasyTrieve gravatar image

I try to familiarize myself with the usage of Macro and UNO API on LibreOffice Base, i tried to open my .odb file with the UNO OfficeDatabaseDocument (DOC here : https://api.libreoffice.org/docs/idl/... ) to play with UNO and learn to use them.

Function MyClubOfficeDatabaseDocument()
  Dim MyClubURL(0) As New com.sun.star.beans.PropertyValue
  MyClubURL(0).Name = "Chemin d'accès vers la base de donnée MyClub"
  MyClubURL(0).Value = "/Users/faisalsalhi/Desktop/MyClub/MyClub.odb"

  MyClubOfficeDatabaseDocument = CreateUnoService("com.sun.star.sdb.OfficeDatabaseDocument")
  MyClubOfficeDatabaseDocument.load(MyClubURL)
End Function

I tried to execute this macro inside my odb file.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-15 03:18:09 +0200

Ratslinger gravatar image

Hello,

In past have only used com.sun.star.sdb.OfficeDatabaseDocument for verification of document type looked at.

A much simpler manner to open a document:

TargetURL = convertToURL(fileLocation)
TestDoc = StarDesktop.loadComponentFromURL(TargetURL, "_blank", 0, Array())

where fileLocation is your file such as:

fileLocation = "/Users/faisalsalhi/Desktop/MyClub/MyClub.odb"
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-13 15:48:32 +0200

Seen: 30 times

Last updated: Aug 15