Kexi/Plugins/Scripts/Database Object Model: Difference between revisions

Revision as of 14:26, 24 July 2017

Note

This page is a draft for database object model in Kexi

Description....

MSA equivalent's name:

Properties:

Name	Type	Description	Read/Write?	MSA name

Methods:

Name	Type	Description	MSA name

When designing the object model, try to harmonize with Predicate's API
Use JavaScript notation as QtScript will be used to implement scripting
Information about MSA equivalent names would be reusable in Kexi Handbook too, chapter "Comparison to MS Access"

@@ Line 35: / Line 35: @@
 ==Notes==
-*'''Scripting makes sense mostly in Qt5-based Kexi.''' Target implementation shall use Qt5's QtScript since it uses the more efficient V8 engine which [https://bugreports.qt-project.org/browse/QTBUG-12503?focusedCommentId=159445&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-159445 will not been used in Qt4]. Qt4's QtScript uses a fork JavaScriptCore and exposes internal APIs of JavaScriptCore. In Qt5 QtScript is a DONE module without (as of 2012) plans for porting to V8. It is too costly to standardize on Qt4 scripting and then porting to Qt5 (with changed API). See also [http://thread.gmane.org/gmane.comp.kde.devel.kwrite/32993/focus=75070 Summary of QtScript problems in Qt5]
 *When designing the object model, try to harmonize with Predicate's API
 *Use JavaScript notation as QtScript will be used to implement scripting
@@ Line 41: / Line 40: @@
 ==Links==
+*[http://www.microsoft.com/en-us/download/details.aspx?id=40326 Office 2013 VBA Documentation] (chm file, accessible using kchmviewer)
+*[https://msdn.microsoft.com/en-us/library/dd361851 VBA Language Specification] (PDF)
+*[http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944%28v=vs.85%29.aspx MS ADO Object Model]
 *http://en.wikipedia.org/wiki/ActiveX_Data_Objects
+*http://www.access2base.com - well documented object model in LO following MSA