BASE not allowing DELETE FROM

Discuss the database features

BASE not allowing DELETE FROM

Postby mwlovin » Mon Feb 03, 2014 8:29 am

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. :)
Open Office 3.3 Build 9567 on WinXP Pro SP2
mwlovin
 
Posts: 1
Joined: Mon Feb 03, 2014 8:22 am

Re: BASE not allowing DELETE FROM

Postby DACM » Mon Feb 03, 2014 12:23 pm

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:

Create_a_new_database.jpg
LibreOffice 4.2 > Base > New Database > Create a new database
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: BASE not allowing DELETE FROM

Postby Villeroy » Mon Feb 03, 2014 2:34 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27899
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests