「Libroffice BASIC」:修訂間差異
跳至導覽
跳至搜尋
無編輯摘要 |
|||
| 第9行: | 第9行: | ||
MsgBox Names(I) | MsgBox Names(I) | ||
Next I | Next I | ||
*使用指定之資料庫名稱 | |||
Dim DatabaseContext As Object | |||
Dim DataSource As Object | |||
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext") | |||
DataSource = DatabaseContext.getByName("Customers") | |||
==相關連結== | ==相關連結== | ||
[https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide OpenOffice.org BASIC Programming Guide] | [https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide OpenOffice.org BASIC Programming Guide] | ||
於 2015年2月2日 (一) 09:12 的修訂
程式碼
- 取得現有資料庫名稱
Dim DatabaseContext As Object
Dim Names
Dim I As Integer
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
Names = DatabaseContext.getElementNames()
For I = 0 To UBound(Names())
MsgBox Names(I)
Next I
- 使用指定之資料庫名稱
Dim DatabaseContext As Object
Dim DataSource As Object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName("Customers")