From db8f7521f190f41bc80b783183a9cff5b98f4c16 Mon Sep 17 00:00:00 2001 From: Jean-Pierre Ledure Date: Sat, 2 Nov 2013 11:30:34 +0100 Subject: Access2Base - Help file Summary description + reference to official doc site 1 entry in index 1 entry in Macros & Programming - Guides Change-Id: I26587292b4daff035779fc197522af7dc600279a Reviewed-on: https://gerrit.libreoffice.org/6522 Tested-by: Lionel Elie Mamane Reviewed-by: Lionel Elie Mamane --- AllLangHelp_sbasic.mk | 1 + source/auxiliary/sbasic.tree | 1 + source/text/sbasic/guide/access2base.xhp | 97 ++++++++++++++++++++++++++++++++ 3 files changed, 99 insertions(+) create mode 100644 source/text/sbasic/guide/access2base.xhp diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index c03b371e8d..156b54210f 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -16,6 +16,7 @@ $(eval $(call gb_AllLangHelp_use_linked_modules,sbasic,\ )) $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ + helpcontent2/source/text/sbasic/guide/access2base \ helpcontent2/source/text/sbasic/guide/control_properties \ helpcontent2/source/text/sbasic/guide/create_dialog \ helpcontent2/source/text/sbasic/guide/insert_control \ diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree index 0e39d323a7..136439b052 100644 --- a/source/auxiliary/sbasic.tree +++ b/source/auxiliary/sbasic.tree @@ -264,6 +264,7 @@ Using Objects Debugging a Basic Program Event-Driven Macros +Access2Base, the API for Base users diff --git a/source/text/sbasic/guide/access2base.xhp b/source/text/sbasic/guide/access2base.xhp new file mode 100644 index 0000000000..135adc5051 --- /dev/null +++ b/source/text/sbasic/guide/access2base.xhp @@ -0,0 +1,97 @@ + + + + + + + + + + + Access2Base + /text/sbasic/guide/access2base.xhp + + Access2Base topic first insertion, by Jean-Pierre Ledure + None + + + + + Access2Base + + Access2Base + What is Access2Base ? + Access2Base is a LibreOffice Basic library of macros for (business or personal) application developers and advanced users. It is one of the libraries stored in "LibreOffice macros and dialogs". + The provided macros implement functionalities, all directly inspired by Microsoft Access. The macros are callable from a LibreOffice Base application only. + The API provided by Access2Base is intended to be more concise, intuitive and easy to learn than the standard UNO API (API = Application Programming Interface). +
+ The library is documented online on http://www.access2base.com + The implemented macros include: + + + a simplified and extensible API for forms, dialogs and controls manipulations similar with the MSAccess object model + + + an API for database access with the table, query, recordset and field objects + + + a number of actions with a syntax identical to their corresponding MSAccess macros/actions + + + the DLookup, DSum, ... database functions + + + the support of the shortcut notations like Forms!myForm!myControl + + + + + + + a consistent errors and exceptions handler + + + facilities for programming form, dialog and control events + + + the support of both embedded forms and standalone (Writer) forms + + + Compare Access2Base with MSAccess VBA + + REM Open a form ... + OpenForm("myForm") + REM Move a form to new left-top coordinates ... + Dim ofForm As Object ' In VBA => Dim ofForm As Form + Set ofForm = Forms("myForm") + ofForm.Move(100, 200) + REM Get the value of a control ... + Dim ocControl As Object + ocControl = ofForm.Controls("myControl") + MsgBox ocControl.Value + REM Hide a control ... + ocControl.Visible = False + REM ... or alternatively ... + setValue("Forms!myForm!myControl.Visible", False) ' Shortcut notation + ' In VBA => Forms!myForm!myControl.Visible = False + + + -- cgit