[Libreoffice-bugs] [Bug 128591] New: ODBC/SQL Server/datetimeoffset column breaks form creation wizard

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128591

            Bug ID: 128591
           Summary: ODBC/SQL Server/datetimeoffset column breaks form
                    creation wizard
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bstewart at iname.com

Platform: Windows 10 1803/LibreOffice 6.3.3.2/x64/AdoptOpenJDK 1.8.0_212 x64

I created a Base database that uses an ODBC connection to pull data from a SQL
Server 2012 database. This works without any issues (can view table and create
queries, and these return data without problems). The server table I am
querying contains 2 columns with the 'datetimeoffset' type.

The problem is the 'Use Wizard to Create Form...' tool. I use the following
steps:

1. Click 'Use Wizard to Create Form...'

2. I select my query from the 'Tables or queries' drop-down list

3. I click '>>' to add all columns, then click 'Next >'

4. I don't need any subforms, so I click 'Next >'

5. I choose the second option ("Columnar - Labels on Top") option for the main
form arrangement, then click 'Next >'

6. I select 'This form is to display all data' and select all 3 checkboxes to
prevent data modification, then click 'Next >'

7. Don't care about style; click 'Next >'

8. For the form name, enter whatever name, then click 'Finish'

After clicking 'Finish', the wizard retains focus and no blocking occurs (I can
click '< Back' and 'Next >' buttons, interact with the wizard pages, etc.), but
nothing else happens. The 'Finish' button simply doesn't do anything, and no
columns appear in the underlying form.

If I omit the 2 columns containing the 'datetimeoffset' data type, I can see
the columns appear in the underlying form and I can complete the wizard
successfully.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191104/2cd2724c/attachment.html>