I'm trying to create a simple macro that reads data from a database table column into an array using the ColumnAsArray function. Here is what I've got so far:
Code: Select all
DBContext=createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource=DBContext.getByName("MyDB")
ConnectToDB=DataSource.GetConnection ("","")
DBTables=ConnectToDB.tables
WordTable=DBTables.getByName("Wordlist")
TableColumns=WordTable.columns
WordColumn=TableColumns.getByName("Word")
Words=ColumnAsArray("MyDB", "Wordlist", "Word")
Thank you!
Kind regards,
Dmitri