OpenOffice Base - MySql - Native Query

Query builder has an option for you to run direct SQL command
directly. This mode is equivalent to MS Access - Pass-thru Query mode.
This will allow you to use advanced features of NATIVE SQL dialect.
Unfortunately if you choose this option, you can't really use the
query designer very easily - although you can start with Query
designer and then do the following:
View->Switch Design View On/Off
Edit->Run SQL command directly


http://www.postgresonline.com/journal/index.php?/archives/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html

Commenti

Posta un commento

Post popolari in questo blog

Eclipse underscore not visible

Immagine
Problem: Underscore is not Visibile on Ubuntu With: Eclise Luna SR2, Mars 2, Neon 1a on Ubuntu 16.04 LTS After few tests I understand this  is because my Ubuntu has text scaling factor set to 1.05 (from Unity Tweak Tool) Solution #1 text scaling factor set to 1.00, but for me is too small (you need to restart eclipse to see changes when you change Ubuntu text scaling factor) Solution #2 change only the default font in Eclipse with Liberation Mono (text scaling factor set to 1.05 as default) (for me the best solution at the moment, good font, good size, system text scaling factor set to 1.05 is good also for other applications like terminal)
Continua a leggere

Batch Convert CSV to XLSX with LibreOffice (OpenOffice)

Questo comando converte una serie di file .csv in formato Excel utilizzato LibreOffice (oppure OpenOffice). I files convertiti vengono salvati in una sotto-cartella "excel" Il fomato con vengono interpretati i files . csv (ed i numeri decimali) dipende da come e' configurato il Locale di LibreOffice sulla postazione (Italiano o Inglese) libreoffice --headless --convert-to xlsx --outdir excel *.csv Per convertire tutti i files nelle sotto cartelle find . -type d -exec bash -c "cd '{}' && libreoffice --headless --convert-to xlsx --outdir excel *.csv" \;
Continua a leggere