[Issue 119313] SQLITE database access via ODBC problems in 3.4 RC

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=119313

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org

--- Comment #3 from damjan@apache.org ---
Confirming in latest SVN.

It appears that both char and varchar primary key columns have empty fields in
the table view window. This happens in both 32 and 64 bit.

Interestingly if the query is done through the following macro, the correct
results are returned. So the database driver works. It must be a bug in a
higher layer, such as the rowset or the table view window.


        Dim DatabaseContext As Object
        Dim DataSource As Object
        Dim Connection As Object
        Dim InteractionHandler as Object
        Dim Statement As Object
        Dim ResultSet As Object

        DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
        DataSource = DatabaseContext.getByName("ex1")

        If Not DataSource.IsPasswordRequired Then
          Connection = DataSource.GetConnection("","")
        Else
          InteractionHandler =
createUnoService("com.sun.star.sdb.InteractionHandler")
          Connection = DataSource.ConnectWithCompletion(InteractionHandler)
        End If

        Statement = Connection.createStatement()
        ResultSet = Statement.executeQuery("SELECT * FROM ""Table2""") 

        If Not IsNull(ResultSet) Then
          While ResultSet.next
            MsgBox ResultSet.getString(1)
            MsgBox ResultSet.getInt(2)
          Wend
        End If

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.