Fai la tua domanda

sscala's profile - attività

2019-05-13 16:40:13 +0200 received badge  Domande famose (source)
2019-03-10 16:21:54 +0200 received badge  Domande famose (source)
2019-03-06 06:58:38 +0200 received badge  Domande famose (source)
2018-11-25 09:52:09 +0200 received badge  Domanda notevole (source)
2018-11-25 09:52:09 +0200 received badge  Domanda gettonata (source)
2018-11-24 20:46:06 +0200 ha accettato una risposta base: extract files (blob)

I have a database for scientific articles, which come as PDF.

I noticed, it is fairly easy to add PDFs to a LO-database by using a form and the image-control.

Apparently, the whole PDF is saved and not just the first page that is displayed in the image-control (I checked BLOB length and it corresponds to respective filelength).

But how can I extract the files saved in the database again or open the PDF in an external viewer? I did not find any functionality in the image-control.

2018-11-24 20:46:04 +0200 ha commentato una risposta base: extract files (blob)

thanks! the problem is that I require remote access, so all data - including large PDFs - has to be stored centrally. t

2018-11-24 19:29:13 +0200 ha posto una domanda base: extract files (blob)

base: extract files (blob) I have a database for scientific articles, which come as PDF. I noticed, it is fairly easy t

2018-11-24 18:26:55 +0200 received badge  Sostenitore (source)
2018-11-24 18:26:50 +0200 ha accettato una risposta LibreOffice base & MySQL - database name

When I add a databse via MySQL, all references to tables (e.g. in forms) include the database name.

It is likely that in a later stage of the project, the database will be moved to a different server and also the name of the database will probably change.

I was thinking of adding a query for each table and referece the tables always via queries within LO forms, macros, etc. That way I'd only have to do some changes to the queries "mirroring" my tables when moving the database.

What is the preferred stragety in order to keep changes after transfer to a minimum?

2018-11-24 18:25:40 +0200 received badge  Domanda notevole (source)
2018-11-22 19:05:49 +0200 received badge  Entusiasta
2018-11-18 06:28:36 +0200 received badge  Buona domanda (source)
2018-11-18 02:13:45 +0200 received badge  Domanda gettonata (source)
2018-11-17 18:26:25 +0200 received badge  Studente (source)
2018-11-17 16:53:25 +0200 ha modificato una domanda LibreOffice base & MySQL - database name

LibreOffice base & MySQL - database name When I add a databse via MySQL, all references to tables (e.g. in forms) in

2018-11-17 16:52:53 +0200 ha modificato una domanda LibreOffice base & MySQL - database name

LibreOffice base & MySQL - database name When I add a databse via MySQL, all references to tables (e.g. in forms) in

2018-11-17 16:52:53 +0200 received badge  Revisore (source)
2018-11-17 16:52:20 +0200 ha modificato una domanda LibreOffice base & MySQL - database name

LibreOffice base & MySQL - database name When I add a databse via MySQL, all references to tables (e.g. in forms) in

2018-11-17 16:51:23 +0200 ha posto una domanda LibreOffice base & MySQL - database name

LibreOffice base & MySQL - database name When I add a databse via MySQL, all references to tables (e.g. in forms) in

2018-11-05 21:08:46 +0200 received badge  Domanda notevole (source)
2018-11-05 21:07:39 +0200 ha commentato una risposta Base: get autovalue data after insert

thanks to all of you for your contributions - it actually works :) I had hoped for a solution that would not go so deep

2018-11-05 20:52:41 +0200 ha accettato una risposta Base: get autovalue data after insert

I have a firebird database (LO 6.1.2.1) with n:m connections.

When adding records in a macro, in order to maintain the n:m table I need to know the ID (=autovalue primary key) of the record I just inserted.

Adding a record works fine vial SQL:

Connection = ThisDatabaseDocument.DataSource.getConnection("","") 
Statement = Connection.createStatement()
SQL = "INSERT INTO ""Sections"" (""Section"") VALUES ('ABC')"
ResultSet = Statement.executeQuery(SQL)

The Firebird documentation says that the most recent ID can be retrieved by adding the RETURNING command:

SQL = "INSERT INTO ""Sections"" (""Section"") VALUES ('Anita') RETURNING ""ID"""

The problem is: this does add the data, but it does not return the ID (at least I can not find in in the returned ResultSet).

2018-11-05 20:52:41 +0200 received badge  Studioso (source)
2018-11-04 22:32:38 +0200 received badge  Domanda gettonata (source)
2018-11-04 17:08:41 +0200 ha posto una domanda Base: get autovalue data after insert

Base: get autovalue data after insert I have a firebird database (LO 6.1.2.1) with n:m connections. When adding records