summaryrefslogtreecommitdiff
path: root/wizards/source/access2base/Recordset.xba
AgeCommit message (Collapse)Author
2020-08-26Access2Base - tdf#136063 Workaround Basic missing argument handling (2)Jean-Pierre Ledure
Complementary modifs where behaviour described in bug report could happen in the same way. Root cause IMHO is due to Basic error reported in bug#136143 Change-Id: Ib275f74a0c28995e6b05af31a1fd53b6ae069691
2019-07-22Access2Base - FIX GetRows abortJean-Pierre Ledure
https://forum.openoffice.org/en/forum/viewtopic.php? f=47&t=61447&sid=a91a30f8f02fe6dd656b2940a26d8c5c&start=30#p473874 Precise module name in call to _getResult...
2019-07-13Access2Base - Set Parent property in all classesJean-Pierre Ledure
To get faster access to parents from controls Top classes (form, dialog and commandbar) should return Parent = Nothing
2019-06-29Access2Base - Consolidate classes processingJean-Pierre Ledure
Introduce _This property in all classes and _Parent property where relevant Accelerate processing of Item method in Collections Enhance introspection
2019-06-13Access2Base - Robustness changesJean-Pierre Ledure
Addition of _This address in every Basic object Default parameters reviewed when ambiguous Typo's corrections
2018-07-17Access2Base - FIX Empty line on top of each moduleJean-Pierre Ledure
Closing ">" had disappeared in xml headers ?? Force newline after xml headers
2018-06-30Fix missing newlineAndrea Gelmini
To complete previous commit Change-Id: I21f7e530848d022456bda17a86d42bc14a921efd Reviewed-on: https://gerrit.libreoffice.org/53896 Tested-by: Jenkins Reviewed-by: Thorsten Behrens <Thorsten.Behrens@CIB.de>
2018-05-08Access2Base - Remove useless trailing blank linesJean-Pierre Ledure
Keep exactly 1 line feed at the end of each Basic module
2018-03-18Access2Base - FIX EditMode property of Recordset classJean-Pierre Ledure
EditMode must return an integer instead of a boolean
2017-04-27Access2Base - Optimize default value in field classJean-Pierre Ledure
Buffer default value to optimize multiple records insertions Change-Id: Ia339e8f4b4d00419978503d6351b331a0b987826
2017-03-30Access2Base Missing parentheses - tdf#106710Jean-Pierre Ledure
Due to more severe Basic interpreter on final parentheses missing parentheses were revealed Cherry picking https://gerrit.libreoffice.org/#/c/35717/ was not sufficient as they were remaining cases in new LO5.4 code Change-Id: I6a883ceed22ae20bb61cba8e3966c2dc680bdd0c
2017-03-25Fix typosAndrea Gelmini
Change-Id: I80b6d080aa31ff8b9d043b983993f4d26d8dc87c Reviewed-on: https://gerrit.libreoffice.org/35662 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2017-03-25Access2Base Missing parentheses - Bug #106710Jean-Pierre Ledure
Due to more severe Basic interpreter on final parentheses missing parentheses were revealed Change-Id: I779b5e3d299fb9c56ecd807d28a780cc3ab9a1b5
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 - Use Empty() builtin functionJean-Pierre Ledure
... i.o. uninitialized variable Change-Id: I732705df11ea25c2b106d542f9e97f3f32cc9867
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
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-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
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-06-06Access2Base - Correct behaviour of MoveNext, MovePreviousJean-Pierre Ledure
Bug in MoveNext and MovePrevious methods of Recordset class module Reported in https://forum.openoffice.org/en/forum/viewtopic.php?f=47&t=76640 Change-Id: Ib094eb61dbb3c6b8656a098c7de41da40cc20648
2015-01-04Access2Base - New CommandBarControl classJean-Pierre Ledure
Main functionalities: - show/hide toolbar elements - modify tooltip - get/set internal command - execute internal command Change-Id: Ice830009f9eabc199727c7d4b54ebf524b026d40
2014-08-23Access2Base - Removal of Property Set constructionsJean-Pierre Ledure
The workaround to bug https://www.libreoffice.org/bugzilla/show_bug.cgi?id=60752 has been removed. Bug corrected in LO 4.0.2 End of support of Access2Base under LO 4.0.0 and 4.0.1 Change-Id: Ide5046ce4a44096bca42eaf14c4dc96c59958e16
2014-08-23Dispose() method for all objectsJean-Pierre Ledure
An implicit (Terminate_Class) and an explicit (Dispose) method have been created to stimulate better memory management. Change-Id: I240e5117db6bf0d1fcf268e3ddf6d67e0bc1b8eb
2014-05-27Access2Base - setProperty erroneously omittedJean-Pierre Ledure
Change-Id: I5d2a1b37d80137e6b8fd080d8c2d73372ad0512c Reviewed-on: https://gerrit.libreoffice.org/9479 Reviewed-by: Lionel Elie Mamane <lionel@mamane.lu> Tested-by: Lionel Elie Mamane <lionel@mamane.lu>
2014-05-13Access2Base new release - V1.1.0Jean-Pierre Ledure
Access2Base library can be run to access a database defined in any form stored in any AOO/LibO document. Now CurrentDb method may be associated with a form object, not only with the root class.The OpenDatabase method allows any AOO/LibO document to get access to tables stored in any database. RunSQL, OpenSQL, database functions have been extended to be run from a database object, not only as a command. The CopyObject (new) action copies query definitions and/or table definitions and data. Creation of table and fields without SQL with the CreateTableDef, CreateField and Append methods. The Description property of a TableDef is writable. New GetHiddenAttribute and SetHiddenAttribute actions hide or show any AOO/LibO or Base object. SelectObject scope has been extended accordingly. Addition of the SelStart, SelLength and SelText properties for text controls. Change-Id: I163f3bcb0f63dc346e1bd23729356ebe556c6592 Reviewed-on: https://gerrit.libreoffice.org/9303 Reviewed-by: Lionel Elie Mamane <lionel@mamane.lu> Tested-by: Lionel Elie Mamane <lionel@mamane.lu>
2013-10-28Access2Base : Reference to documentation added in every moduleJean-Pierre Ledure
+ workaround for setPosSize issue (LO 4.1) + "Sidebar" argument for RunCommand + Trace dialog layout revisit for cleaner display in Linux Change-Id: I0d5c4da5681ab1649d062a7133d507163163343e Reviewed-on: https://gerrit.libreoffice.org/6449 Reviewed-by: Lionel Elie Mamane <lionel@mamane.lu> Tested-by: Lionel Elie Mamane <lionel@mamane.lu>
2013-10-13Access2Base store (wizards + scp2)Jean-Pierre Ledure
License text modified after gerrit review Change-Id: I193d6d1fd477cca4c2880760f21f8d978643f634 Reviewed-on: https://gerrit.libreoffice.org/6232 Reviewed-by: Lionel Elie Mamane <lionel@mamane.lu> Tested-by: Lionel Elie Mamane <lionel@mamane.lu>