wizards/source/access2base/Database.xba |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 32cad25f949eabea52e1cf7962ba18a3edd1c647
Author: Jean-Pierre Ledure <j...@ledure.be>
Date:   Sun May 13 15:06:55 2018 +0200

    Access2Base - FIX Sql errors when apostrophe in table names
    
    Correct replacement of square brackets by quoting string

diff --git a/wizards/source/access2base/Database.xba 
b/wizards/source/access2base/Database.xba
index fad41abfbaa2..ebb6ada1bd7f 100644
--- a/wizards/source/access2base/Database.xba
+++ b/wizards/source/access2base/Database.xba
@@ -1851,7 +1851,7 @@ Const cstSingleQuote = &quot;&apos;&quot;
        End If
        vSubStrings() = Split(psSql, cstSingleQuote)
        For i = 0 To UBound(vSubStrings)
-               If (i Mod 2) = 0 Then           &apos;  Only even substrings 
are parsed for square brackets
+               If (i Mod 2) = 0 Or (i = UBound(vSubStrings)) Then              
&apos;  Only even substrings are parsed for square brackets. Last substring is 
parsed anyway
                        vSubStrings(i) = Join(Split(vSubStrings(i), 
&quot;[&quot;), sQuote)
                        vSubStrings(i) = Join(Split(vSubStrings(i), 
&quot;]&quot;), sQuote)
                End If
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to