I would very much appreciate some help so I can continue to make progress on my project.
I’m working in Ubuntu 13.04. I’ve created a DB using MariaDB and successfully connect to it and can access and create tables in it using LibreOffice BaseEXCEPT I can’t figure out how to modify a table using a macro.
When I search the web I keep coming up with the following code:
Dim Context Dim DB Dim Conn Dim Stmt
Dim Result Dim strSQL As String
strSQL=“INSERT INTO _
My problem is, I haven’t been able to get past
I keep getting the error message:
BASIC runtime error. An exception
“MikesTest” is the registered name of the DB in LO. That doesn’t work. Nor does a full path to the DB. Nor does just the DB name without the full path.
So what is the trick here? I’m sure it is obvious to the initiated.
Thanks for any help on the frustrating stalemate.