InteractionHandler = createUnoService(".InteractionHandler")ĬonnectToDatabase = DataSource.ConnectWithCompletion(InteractionHandler) If Not DataSource.IsPasswordRequired ThenĬonnectToDatabase = DataSource.GetConnection("","")
Is there anything in Basic-Calc like this? I’ve looked all over and haven't come across anything.ĭim RowSetObj As Object, ConnectToDatabase As ObjectĭATABASE_NAME = "file:///home/jod/Documents/test.odb"ĭBContext=createUnoService(".DatabaseContext")ĭataSource=DBContext.getByName(DATABASE_NAME) In VB I was able to loop through the recordset and dump it into a Range like so, “ActiveWorkbook.Sheets(1).Range("A5").CopyFromRecordset rs”. The code below pulls a SP from MySql, and does exactly what I want, except for the While loop. I’m new to Calc and I use to be able to do something similar to this in Excel / VB.
0 kommentar(er)
