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
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.