summaryrefslogtreecommitdiff
path: root/wizards/source/access2base/Field.xba
AgeCommit message (Collapse)Author
2018-07-18Access2Base - tdf#118680 Fix VARCHAR_IGNORECASE errorJean-Pierre Ledure
Precision property of com.sun.star.sdbcx.Column service is set to the maximum length for VARCHAR database fields while it remains at 0 for VARCHAR_IGNORECASE fields. Access2Base reported erroneously an overflow error.
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
2017-05-25Access2Base - Value property of DECIMAL fieldsJean-Pierre Ledure
Avoid overflow on CLng function Change-Id: I75dc25299cbfbc1fff9eeac4e2a8d2f3e8ed7d85
2017-05-22Access2Base - Class attribute in <span> tagJean-Pierre Ledure
Replaces the style attribute Change-Id: Id9366fc403fd0d3ab8c32a13d60b6c1c7ae74d43
2017-04-27Access2Base - Optimize default value in field classJean-Pierre Ledure
Buffer default value to optimize multiple records insertions Change-Id: Ia339e8f4b4d00419978503d6351b331a0b987826
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
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-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
2015-12-23Access2Base - Support of Hsqldb 2.3Jean-Pierre Ledure
Addition of CLOB and BLOB datatypes Change-Id: If42c0dbb1862f525d2a0a1abf98bd053543a3d3c
2015-08-29Access2Base - NewLine distinction Windows - Linux+Jean-Pierre Ledure
Change-Id: I09be5a10ae301b42daf446852e6cf8ba3ed2e51e
2014-09-19Access2Base - (Re)capitalize UNO constantsJean-Pierre Ledure
Some UNO constants (integer, double, ...) were lower cased by Basic IDE. Probably due to AutoCorrection options of IDE ? Change-Id: Ib599a8bc9f26d179ba5befbcd7a915d29554f948
2014-09-13Access2Base - PATCH-01 Field.setValueJean-Pierre Ledure
setValue gives erroneously an error message when argument is Null and field is nullable https://forum.openoffice.org/en/forum/viewtopic.php?f=47&t=61447&sid=48e231a12084933d9da1b47e50b186ea#p323714 Change-Id: Ic96e50f4c752f5fa38e8f40e80692f166fd88e4a
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>