wizards/source/access2base/Database.xba |    6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

New commits:
commit 84c02b6d9f2fbe6658b58182f57d60e2bc797016
Author:     Jean-Pierre Ledure <j...@ledure.be>
AuthorDate: Fri Aug 24 16:30:10 2018 +0200
Commit:     Jean-Pierre Ledure <j...@ledure.be>
CommitDate: Fri Aug 24 16:30:10 2018 +0200

    Access2Base - Fix OutputTo of null string
    
    Basic builtin function IsDate
    returns True for a null-length string.
    Intercepted to avoid conversion to date giving "00:00:00"
    
    Change-Id: Ie917574043ea743e43cd79c5d95d023c8ccab38a

diff --git a/wizards/source/access2base/Database.xba 
b/wizards/source/access2base/Database.xba
index cf8617e0b285..72f73cb8daf2 100644
--- a/wizards/source/access2base/Database.xba
+++ b/wizards/source/access2base/Database.xba
@@ -1458,7 +1458,9 @@ Const cstMaxRows = 200
                                        If Not vFieldsBin(i) Then
                                                If bDataArray Then vDataCell = 
pvData(i, j) Else vDataCell = vData(i, j)
                                                If vDataCell Is Nothing Then 
vDataCell = Null           &apos;  Necessary because Null object has not a 
VarType = vbNull
-                                               If IsDate(vDataCell) And 
VarType(vDataCell) = vbString Then vDataCell = CDate(vDataCell)
+                                               If VarType(vDataCell) = 
vbString Then   &apos;  Null string gives IsDate = True !
+                                                       If Len(vDataCell) &gt; 
0 And IsDate(vDataCell) Then vDataCell = CDate(vDataCell)
+                                               End If
                                                Select Case VarType(vDataCell)
                                                        Case vbEmpty, vbNull
                                                                vTdClass() = 
_AddArray(vTdClass, &quot;null&quot;)
@@ -1563,7 +1565,7 @@ Dim i As Integer, l As Long
 
        lCurrentChar = 1
        sOutput = &quot;&quot;
-       
+
        Do While lCurrentChar &lt;= Len(psString)
                &apos;  Where is next closest pattern ?
                lPattern = Len(psString) + 1
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to