Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


Hoi Rob,

Rob Westein wrote on 28-02-18 12:58:

readydate = oResult.getTimestamp(2)
werkt niet,

Stukje code met juiste oplossing - vermoed ik:

    For i = 1 To n
      Select Case oMeta.getColumnType(i)
      Case com.sun.star.sdbc.DataType.DATE
        oData2(i) = CStr(UNODateToDate(oResult.getDate(i)))
      Case com.sun.star.sdbc.DataType.TIME
        x = oResult.getTime(i)
        oData2(i) = Format(x.Hours, "00") & ":" & _
            Format(x.Minutes, "00") & ":" & _
            Format(x.Seconds, "00") & "." & x.HundredthSeconds
      Case com.sun.star.sdbc.DataType.TIMESTAMP
        x = oResult.getTimestamp(i)
        oData2(i) = CStr(UNODateToDate(x)) & " " & _
            Format(x.Hours, "00") & ":" & Format(x.Minutes, "00") & _
            ":" & Format(x.Seconds, "00") & "." & x.HundredthSeconds
      Case Else
        oData2(i) = oResult.getString(i)
      End Select
    Next


Vraag 2:
wanneer een client naam een vreemd
karakter bevat zoals de apostrof dan kan deze niet goed worden
weggeschreven in de database.

Drivers die geen UTF-8 ondersteunen? Enfin. Iets met
ASCII/ANSI-conversie naar tekenreeksen (zie Help) ?

Succ6,
Cor

-- 
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- Member The Document Foundation

-- 
Unsubscribe instructions: E-mail to users+unsubscribe@nl.libreoffice.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/nl/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.