Bug Hunting Session
Bug 112715 - Table listboxes entries aren't shown in form with external Firebird3 database over ODBC on Windows
Summary: Table listboxes entries aren't shown in form with external Firebird3 database...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2017-09-28 10:34 UTC by Alberto
Modified: 2018-11-07 21:30 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
odb file and db source (365.56 KB, application/x-zip-compressed)
2017-09-28 12:45 UTC, Alberto
Details
DB file, dlls and models (7.82 MB, application/x-zip-compressed)
2017-10-23 07:58 UTC, Alberto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alberto 2017-09-28 10:34:50 UTC
I've noticed that whan I have a form with a table control with two listboxes column I'm not able to read the item text but I can read only the value of the field of the query records.
It regullary works when I've use only one listbox column.

Thanks for your help
Comment 1 Xisco Faulí 2017-09-28 10:45:06 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 Alberto 2017-09-28 12:45:39 UTC
Created attachment 136583 [details]
odb file and db source

If you try to modify the form esempi/qa_preventivi_da_approvare_professionista when you change between edit and execute (in italian I use the "modo struttura" button) the listbox is displayed sometimes correctly and other times it shows only the value of the field of the query  record.

I've noticed a similar behaviour with the form "pagina_iniziale" in the table "tabellaPreventiviDaApprovare" of the subform "formPreventiviDaApprovare"

Thanks a lot

Alberto
Comment 3 Julien Nabet 2017-10-21 22:21:14 UTC
it's an odbc database, could you provide connection parameters?
Comment 4 Robert Großkopf 2017-10-22 15:00:42 UTC
The forms couldn't be opened for editing or input without any connection to the database.

Please try to reproduce the explained buggy behavior with a small example with internal HSQLDB and without macro code.

If it is a special problem with macro code please add only this code to the example database.
Comment 5 Alberto 2017-10-23 07:58:36 UTC
Created attachment 137227 [details]
DB file, dlls and models

the odbc parameter are:

DSN: contabilita

database: [path of DB file]\CONTABILITA_FB3.FDB
client DLL: [path of DB file]\fbclient.dll
user: PIPPO
password: PIPPO

the other parameters are the default

Thanks

Alberto
Comment 6 Alberto 2017-10-23 08:03:42 UTC
(In reply to robert from comment #4)
> The forms couldn't be opened for editing or input without any connection to
> the database.
> 
> Please try to reproduce the explained buggy behavior with a small example
> with internal HSQLDB and without macro code.
> 
> If it is a special problem with macro code please add only this code to the
> example database.

I'll try to reproduce the bug also with internal dB, but I fear it will take me a lot of time.

Alberto
Comment 7 Alex Thurgood 2017-10-23 13:08:50 UTC
Changed title to reflect findings with information given so far
Comment 8 Alex Thurgood 2017-10-23 13:16:23 UTC
@Alberto : please also indicate :

- bit type of your Windows OS (32 or 64);
- bit type, name and version number of your ODBC driver ;
- bit type of LibreOffice version (32 or 64bit)

Thanks
Comment 9 Alberto 2017-10-26 13:18:26 UTC
(In reply to Alex Thurgood from comment #8)
> @Alberto : please also indicate :
> 
> - bit type of your Windows OS (32 or 64);
> - bit type, name and version number of your ODBC driver ;
> - bit type of LibreOffice version (32 or 64bit)
> 
> Thanks

WINDOWS 10 64bit
LIBREOFFICE 64bit
ODBC 2.00.04.155
Comment 10 ribotb 2018-10-01 21:37:02 UTC
I installed database CONTABILITA_FB3.FDB on my Firebird3 server and I created the ODBC connection. Connection is OK, I can connect database conti_sviluppo.odb to CONTABILITA_FB3.FDB.

BUT I don't understand where is the problem :-)  
Give us, please, the detailed steps to reproduce.

Bernard
Comment 11 Drew Jensen 2018-11-03 22:15:01 UTC
(In reply to ribotb from comment #10)
> I installed database CONTABILITA_FB3.FDB on my Firebird3 server and I
> created the ODBC connection. Connection is OK, I can connect database
> conti_sviluppo.odb to CONTABILITA_FB3.FDB.
> 


(In reply to Alberto from comment #6)
> 
> I'll try to reproduce the bug also with internal dB, but I fear it will take
> me a lot of time.
> 
> Alberto

@Alberto Hopefully you are not still having the problem.

Reading what you have commented on the issue seems all about listboxes and ODBC isn't really a factor, so I took some time to look at the database with a slightly different setup. OS here is Ubuntu 18.04 and using LibreOffice 6.2Alpha1 then I switched the connection type in your ODB file to sdbc:Firebird_file connected (in single user mode) to the datafile CONTABILITA_FB3.FDB.

Everything (most things, there is a couple of basic errors I hit) seem to work as I would expect including at the listbox behavior as far as I can tell. Looking at a few of the forms you referenced I had a hard time funding data grids with multiple listboxes (but I don't think I understand fully how to work those forms, so they are likely in the grid which seems to need questions answered to activate) 

I did find multiple listboxes on form CLIENTI_FORNITORI_REFERENTI and did then with another added a couple here.

As I say, in those cases the controls are acting as I would expect.

I do have one question, just though, when you said in the first comment 'I'm not able to read the item text' do you possibly mean from within a macro. I didn't dig into it, but one of the errors the basic routines looked like it was trying to do that - so if that is it I'll take time to test that.

Changing status to needs info for the moment.
Comment 12 Alberto 2018-11-07 21:20:44 UTC
Thank you Drew Jensen,
thank you Ribotb,

I'm sorry I'm replying so late, but I haven't read the mail until today.
It was a bit I wasn't working with the db and today I've tried to use it with the last release of libreoffice (6.1.3): now the listboxes in the table work fine.

Thank you for your work and helpfulness


Alberto
Comment 13 Drew Jensen 2018-11-07 21:30:52 UTC
(In reply to Alberto from comment #12)
> Thank you Drew Jensen,
> thank you Ribotb,
> 
> I'm sorry I'm replying so late, but I haven't read the mail until today.
> It was a bit I wasn't working with the db and today I've tried to use it
> with the last release of libreoffice (6.1.3): now the listboxes in the table
> work fine.
> 
> Thank you for your work and helpfulness
> 
> 
> Alberto

Thanks for getting back in touch.

Change the status then.