Page 1 of 1

BASE not allowing DELETE FROM

Posted: Mon Feb 03, 2014 8:29 am
by mwlovin
As I checked the EDIT - DATABASE - PROPERTIES... is greyed out. WHy?
Seems SQL is always some error in BASE...I am novice so yeah...I am mistake ridden...but why would BASE default to a condition where functionality is limited?
Can some one help me fix this OPEN program, please..
....I am calm now. :)

Re: BASE not allowing DELETE FROM

Posted: Mon Feb 03, 2014 12:23 pm
by DACM
Hi mwlovin,

The Properties are unavailable when using an 'Embedded database." See the bottom status bar in Base. This "embedded" terminology refers to the default file-package (.odb) generated by the "New Database" wizard when selecting "Create a new database." In this case, the Base wizard creates a single zip-archive (.odb) file containing both front-end components (Base forms, queries, reports, macros) and back-end components (HSQL database files). The inclusion of the back-end data files constitutes an "embedded database."

The default database engine is HSQLDB. It's bundled with Base and documented separately here: HSQLDB 1.8 documentation.

BTW, we now have a drop-down selection in LibreOffice 4.2:
LibreOffice 4.2 > Base > New Database > Create a new database
LibreOffice 4.2 > Base > New Database > Create a new database

Re: BASE not allowing DELETE FROM

Posted: Mon Feb 03, 2014 2:34 pm
by Villeroy
And to answer the subject line: Tools>SQL... lets you do anything with the underlying database. What you store in the query section are SELECT statements.