summaryrefslogtreecommitdiff
path: root/wizards/source/access2base
AgeCommit message (Collapse)Author
2017-01-13Access2Base - Review size limits of VARCHAR fieldsJean-Pierre Ledure
- Basic has no practical limit anymore for string variables - LONGVARCHAR fields can vary a lot in size across RDBMS's (f.i. Sqlite < 64K) This forces an overflow check when setting a field value and no check when getting it Change-Id: I4c9629f63164fbbdb84497e7002fa3186d7c63b7
2017-01-12Access2Base - Improve precision of query typingJean-Pierre Ledure
Change-Id: I6c5246809cb533a2c69978008ea996392e2fbe6a
2017-01-12Access2Base - Use Empty() builtin functionJean-Pierre Ledure
... i.o. uninitialized variable Change-Id: I732705df11ea25c2b106d542f9e97f3f32cc9867
2017-01-12Access2Base - Recognize correctly formatted fieldsJean-Pierre Ledure
New ImplementationName introduced in LO 5.1 Change-Id: Ifa181570575622aca27520397f2e88cbc9742d1e
2017-01-12Access2Base - Addition of Module objectJean-Pierre Ledure
New Module Basic module New AllModules() collection in Application module Extension of regex to backward searches Change-Id: Id58f3b29d08e9f0b73e192cfc0c2a99988e73fcf
2017-01-12Access2Base - Reorder functions in Database moduleJean-Pierre Ledure
Change-Id: I62fb5d0722363fdcd7d464d0490b1f6e890221a4
2017-01-12Access2Base - Review UtilProperty moduleJean-Pierre Ledure
Insert dates and 2-dim arrays in property values Export array or property values to string for file or database temporary storage Reimport from string into array or property values (for later use) Change-Id: I7f2dc2ad6adde6249e68a6cb51b52e2a4dad79b7
2017-01-12Access2Base - Implement regex searchJean-Pierre Ledure
Based on XTextSearch UNO service _CStr also refined Change-Id: Ibeceeeb549511e575c6842e43e5a76c8308db1aa
2017-01-12Access2Base - More accurate CStr functionJean-Pierre Ledure
Includes arrays, distinguishes integers and real numbers Side effects in DebugPrint solved Change-Id: Id84203cea1a93dcbc164f8661fcf2f57778b0df8
2017-01-12Access2Base - Avoid use of outdated routinesJean-Pierre Ledure
in getObject, getValue and setValue functions Change-Id: I98ff54bf62cfb34218d1fdb43fb37ba21846b068
2017-01-12Access2Base - Implement On ... event propertiesJean-Pierre Ledure
Event properties applied to form, subform, control events Controls may belong to forms, subforms, dialogs, grid controls Change-Id: Iaf33adcd03527ac938913675cf0930e317a17f97
2016-11-12Access2Base - 3 typosJean-Pierre Ledure
Change-Id: Ie501bc7190a8eccc2810ccac2dddaec52813f1a2
2016-11-12Access2Base - OutputTo method accepts input from arrayJean-Pierre Ledure
in addition to tables and queries. (only for internal use - arguments not published in documentation) Change-Id: I4c7aff878a4ff1a03dcc32baae740559d034d3ca
2016-11-11Access2Base - New properties in Database classJean-Pierre Ledure
Name, Connect and Version Change-Id: Ief0da378fd8927df7accdfc0157547670ca203de
2016-11-10Access2Base - Code cleanupJean-Pierre Ledure
Replace double code by function calls (dialog libraries handling) Change-Id: I17fc700e47a258b281214fe29e075bc782fb6acd
2016-11-10Access2Base - Comments reviewJean-Pierre Ledure
Change-Id: If7fb37a3656b55f7820698a59b8f1d8d8b14d594
2016-11-10Access2Base - Call GetLocale() only onceJean-Pierre Ledure
and not for each individual label Change-Id: I7014be30569a275fa20faaa2ba9255d3968b70dd
2016-11-05Access2Base - Remove useless code in Root handlingJean-Pierre Ledure
Change-Id: I6f3a6efd858ac4e52b694cc0046c8f56a558c229
2016-11-05Access2Base - Spanish translationJean-Pierre Ledure
Provided by Iñigo Zuluaga Change-Id: I6ba436e29f7aff35e30a8e614e0c3c3d2c3ac1b4
2016-11-02Access2Base - Simplify CopyObjectJean-Pierre Ledure
Avoid Field object buffering in CopyObject as it is now done in the Recordset class Change-Id: I35ee9e953e27554cb361adbb22baa619e4b73aaf
2016-11-02Access2Base - Buffer field objects in recordsetJean-Pierre Ledure
Field objects are buffered in a _Fields() array, part of a Recordset instance, to improve speed and memory consumption Change-Id: Iac732ab5a1db24341aa30c3c934853a21c76e2e4
2016-10-13Access2Base - CopyObject applied on tables belonging to different databasesJean-Pierre Ledure
So far, only tables belonging to the SAME database could be copied. Copying tables between databases from different sources (HSQLDB 1.8/2.3, MySQL, PostGres, Sqlite) is admitted. Field type conversions are in this case based on empiric rules. A case study based on getMetadatInfo() is available on request. Change-Id: Iae4ea7c4df4799cde3c8f973746513bad56246d8
2016-10-03Fix typosAndrea Gelmini
Change-Id: Iad27d1f87568890180c142774c238a14d022946d Reviewed-on: https://gerrit.libreoffice.org/29441 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2016-05-22Access2Base - Long binary and char fields in database functionsJean-Pierre Ledure
Review of Utils._getResultSetColumnValue() to include LOGVARCHAR and LONGVARBINARY field types Change-Id: Id1bd073a8f7d910377d7e1ecca96d682cd856946
2016-05-16Access2Base - CopyObject method extended to MySql and SqliteJean-Pierre Ledure
Tables must belong to the same database. INSERT SQL statement syntax extended Table- and fieldnames correct surrounding Correction of incident declared in https://ask.libreoffice.org/en/question/69795/access2base-findrecord-only-for-numbers/ Change-Id: Ice148d872cacfc80df421132020ab1717e7c908c
2016-05-10Fix typosAndrea Gelmini
Change-Id: I1c1894fcf533291b34a662b6efb96dcfa75b92b3 Reviewed-on: https://gerrit.libreoffice.org/24760 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Michael Stahl <mstahl@redhat.com>
2016-05-05Access2Base - DLookup function works now correctly with MySql and SqliteJean-Pierre Ledure
Bug revealed on https://ask.libreoffice.org/en/question/68080/access2base-dfunctions-with-mysql/ Root cause: SELECT TOP 1 construction is invalid for MySql. Use LIMIT keyword instead. Change-Id: Idb0bebe1adb8ca1f88dbc8f8ba039f117456337c
2016-03-28Access2Base - add Picture property to Control objectJean-Pierre Ledure
Change-Id: I68713ccc6d8920de6945206285e35320eef5b4ea
2016-03-27Access2Base - GetChunk - tests of BLOB field typeJean-Pierre Ledure
Change-Id: I02f51ff264c64458c99c47ea48d960a50c65cb75
2016-03-12Access2Base - Correct error message and other typo'sJean-Pierre Ledure
Change-Id: Ia046bcd8ca8e90566348b507f18d881030bd64c3
2016-02-03Access2Base - Wider database supportJean-Pierre Ledure
Support of HSQLDB 2.3 and MySql CLOB and BLOB as database field types Schema and catalog names in tables GetChunk and AppendChunk methods for binary fields The Value property returns the correct binary content of binary fields Change-Id: I0aba80134f9add90f438ac4b7951fce9c1d36239
2016-01-10Fix typosAndrea Gelmini
Change-Id: I9a5940027423ff0791fa7da0b79b617412ce6b86 Reviewed-on: https://gerrit.libreoffice.org/21209 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Ashod Nakashian <ashnakash@gmail.com>
2015-12-23Access2Base - Support of Hsqldb 2.3Jean-Pierre Ledure
Addition of CLOB and BLOB datatypes Change-Id: If42c0dbb1862f525d2a0a1abf98bd053543a3d3c
2015-12-13Access2Base - OutputTo action more conciseJean-Pierre Ledure
Simplified use of TableDefs and QueryDefs collections Change-Id: I87c5dcbbb1105c61324a0a89929f13ff86eab4a4
2015-12-13Access2Base - OutputTo action - support encoding in csv filesJean-Pierre Ledure
Change-Id: Icc4a631d67c3d4acf67de1cb38018c37602a16eb
2015-12-12Access2Base - More coherent use of the acUTF8Encoding constantJean-Pierre Ledure
Change-Id: Ibcffe9d8b85d552f53246a3ac751000673705ab3
2015-12-12Access2Base - Add default FilterOptions string in Calc export to csvJean-Pierre Ledure
Design choices: Sseparator = comma except if decimal point is comma in locale setting, then semi-colon Character set = Unicode (UFT-8) Change-Id: I11eb88bf44cedaddfb52d3570f427d9e0d26b4cc
2015-12-08Access2Base - DoCmd.OutputTo applicable to Calc, Excel and Text/csv formatsJean-Pierre Ledure
Database._OutputToCalc uses LO filters to export table and/or query data Change-Id: I69b15e76a490de32ec2cae73661f8ffd5f2b53b2
2015-12-08Access2Base - Dynamic combo list in PromptFormat()Jean-Pierre Ledure
to refelect various list of output formats in DoCmd.OutputTo() action Change-Id: Ibb95020efa2995cde168efbd516f9b1e49d832a3
2015-12-06Access2Base - First steps OutPutTo calc and csvJean-Pierre Ledure
+ bug correction on dlgFormat dialog - check user input Change-Id: I126f99dbc587342772a601df8b9dd03cfe4850ac
2015-12-06Access2Base - Option Explicit in UtilProperty moduleJean-Pierre Ledure
Change-Id: Iab982421be37e670201561b67cc66fb91d30de91
2015-12-05Access2Base - OutputTo binary fields as null fieldsJean-Pierre Ledure
Do not skip temanymore Change-Id: I6a1276959ab940eb44aedeab2f1c9cc7f71a0e1e
2015-12-05Access2Base - OutputTo HTMLJean-Pierre Ledure
Add <span> in the list of acceptable html tags Change-Id: I23c57ad1ef889fd511111f6d969feaafb9d0f5b8
2015-11-29Access2Base - OpenQuery for action queriesJean-Pierre Ledure
Change-Id: I6691c01e8a078b14ca753c916c950c958953671f
2015-11-28Access2Base - OutputTo / html Add suffix default value in file pickerJean-Pierre Ledure
Change-Id: I80d97058221106ce87d696d8142b1e87430513d9
2015-11-22Access2Base - OutputStringToHTML reviewJean-Pierre Ledure
Addition of "<a id= ...>" tag pattern Typos Change-Id: Id03e6224dc91249a9e6246ff94a80427ae76a86e
2015-11-15Access2Base - Return null values correctly in Recordset.GetRows methodJean-Pierre Ledure
Use .wasNull() rather than not trustable .IsNullable() in _getResultSetColumnValue routine Change-Id: I1d1783841414193347cca588209153b5aa9b56cd
2015-11-11Access2Base - Implements OutputTo table/query in HTML formatJean-Pierre Ledure
Functions to export database data contents into an HTML table with - template file - use of classes for CSS styling Change-Id: Ib62b103445ba47e2fe77c45109a62b2e49fcbbc5
2015-10-03Access2Base - new HtmlEncode property of Application objectJean-Pierre Ledure
Change-Id: I6eb68f78d32b1d73969d37f6991ff0ef3e795606
2015-08-30Access2Base - UTF-8 encoding and %-encodingJean-Pierre Ledure
Application to SendMailWithoutAttachment => "mailto: ... " uri Change-Id: I53aa0325c048dca678ff134908d448afab08933d
generated by cgit (git 2.34.1) at 2024-07-19 20:41:18 +0000