BaseTools

In order to auto load the Library i had to make a little change in your original code.
globalScope.BasicLibraries.LoadLibrary("BaseTools") instead of BasicLibraries.LoadLibrary("BaseTools") .
With globalscope works like a charm and auto loads the library without me having to load it manually every time I open a file.
other than that, Excellent job this Extension, is Very Usefull.

Hi,
Thanks a lot for these tools. Very useful!
I try to use runCmd.openFormDocument("aForm", event, " aFilterString)
This line is in a function onAButtonClick(event)
I get an error message:
Error. Unable to open form document. Active connection not found.
I'm don't sure it is a bug. Perhaps I miss something. Anyway, I fix this problem replacing...

Function openFormDocument(FormName As String,Optional Event As Object,Optional Filter As String, Optional FormToFilter As Integer, Optional GotoRec As Integer) As Object
Dim Conn As Object
If IsMissing(Event) Then
Conn=ActiveConnection()
Else
Conn=ActiveConnection(event)
End If


... by ...


Function openFormDocument(FormName As String,Optional Event As Object,Optional Filter As String, Optional FormToFilter As Integer, Optional GotoRec As Integer) As Object
Dim Conn As Object

If IsMissing(Event) Then
Conn=ActiveConnection()
Else
Conn=getActiveConnection(event)
End If

I'm trying to use RunCmd.ApplyFilter to apply a filter on a subform when an event is called (choosing a new month on a combobox), so here is the code I use:

Sub MonthSelect(oEvent)
... then I get the month number into iMonthNum
sFilter = "Month = " + iMonthNum
RunCmd.ApplyFilter sFilter, "SubForm-WorkItems" (this is the name of the subform)
End Sub

However this does not work since apparently there is a clash between the name of the SubForm, and the type of the parameter expected by the ApplyFilter function, as so:

Function ApplyFilter(Filter As String,Optional FormName As Object) As Boolean

I wouldn't mind trying to change it myself, but apparently the fact that the extension is loaded into OpenOffice.org macros prevents me from modifying it. Help urgently wanted!

Dear Roberto,

I have difficulties to get started with your set of macros for Base.

Th extension is stored in the "macro" subfolder "Meine Makros" (perhaps "my macros" is the translation for that). I can load your library without an error message, but I can not connect to the database. Do you have a simple example to get started?

Thank you very much in advance

Jürgen

PS: I would like to use Base as front-end for a MySQL database. The forms are created but -as I have no experience in Starbasic- I did not achieve to create macros calling the forms...