The LIME Pro Bar is a convenient way to add functionality and shortcuts to the user. The LIME Pro Bar is a HTML-view that can display a web page to the user. Normally this is used as a menu with additional commands and shortcuts.
Sample from Excel
Start with making a reference to the object Lundalogik Data Engine Library (Tools>References in the Visual Basic Editor).
Enter the following code:
Sub Import()
Dim Sheet As Excel.Worksheet
Dim Db As New LDE.Database
Dim Record As LDE.Record
Dim Records As New LDE.Records
Dim Row As Long
Dim Index As LongDb.Open ””, ”TheDatabaseName”, ”user_name”, ”password”, ”sv”, lkOpenExclusive
Records.Open Db.Classes(”Persons”), , Array(”Name”, ”Phone”, ”Mobile”) Set Sheet = Application.ActiveWorkbook.ActiveSheet
Dim Sheet As Excel.Worksheet
Dim Db As New LDE.Database
Dim Record As LDE.Record
Dim Records As New LDE.Records
Dim Row As Long
Dim Index As LongDb.Open ””, ”TheDatabaseName”, ”user_name”, ”password”, ”sv”, lkOpenExclusive
Records.Open Db.Classes(”Persons”), , Array(”Name”, ”Phone”, ”Mobile”) Set Sheet = Application.ActiveWorkbook.ActiveSheet
For Row = 1 To Records.Count
For Index = 1 To Records.Fields.Count
Sheet.Cells(Row, Index) = Records(Row).Value(Index).Text
Next Index
Next Row
End Sub
Lists Records from the Table Persons
By using the objects Database, Record and Records the name, phone and mobile of all persons in LIME Pro are listed in a sheet in Excel.
