https://bz.apache.org/ooo/show_bug.cgi?id=119313
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from [email protected] --- 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.
