BASE not allowing DELETE FROM

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

[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

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