Error messages in Base files

Discuss the database features

Error messages in Base files

Postby jazzlunatique » Tue Jan 13, 2009 1:12 am

Welcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.
-----------------------------------------------------------------------------------------------------------

I am a beginner user in Open Office Base. I am trying to update a database table and add a record. I attempt to add and then save the record and I receive an error message that says "Error inserting the new record." I do not know what this means or what this indicates so that I can correct it. Where can I go to find this out or does anyone know what this means and how I can correct the record.

thank you,
OOo 2.4.X on Ms Windows XP
jazzlunatique
 
Posts: 7
Joined: Tue Nov 11, 2008 9:42 pm

Re: Error messages in Base files

Postby r4zoli » Fri Jan 16, 2009 2:58 pm

Error codes for Base and HSQLDB are weak points of OOo Base, not so much information, near to zero, about it.

Your problem can be connected to missing Primary Key in your database, if your file based on connected text, dBase, mdb(without PK) or Calc file, these read only databases. To avoid this create new odb file and copy tables into new file and create during copy process PKs.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Error messages in Base files

Postby wizard » Thu Aug 02, 2012 2:38 am

Not necessarily true. I created a new database, and got the same error message, even tho I did have a primary key(created when I got an error message saying I needed one), when I tried to add a new record.

In addition to the above, I had another problem with this database. I had a numeric field with 8 places, but when I tried to enter 200809, it kept changing the 9 to a 7. When I added 2 more '0's, it registered as 20080900, which is acceptable, but annoying.
OOo 2.4.X on Ms Windows XP
wizard
 
Posts: 2
Joined: Wed Mar 18, 2009 12:54 pm

Re: Error messages in Base files

Postby arfgh » Fri Oct 25, 2013 5:43 pm

I love OO, but it is a know fact that BASE is the OpenOffice weak point.

Even actually with AOO 4.0.1 it is very common to obtain a corrupt .odt database file for unknown causes.
I always have tought that is some issue with the file compression....

Usually when we are on the form editition mode, the .odt file rise so much its own file size, and then... CRAAAAAAASSSSSSSHHHHHH !!!!

... we cant use the database never more. :(
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby RPG » Fri Oct 25, 2013 7:09 pm

Hello

I think it is not good to use the database in embedded mode. The same is working good when you have split the database.

read this
viewtopic.php?f=83&t=17567

 Edit: and this
https://forum.openoffice.org/en/forum/v ... 83&t=61183
and this is for downloading the example file
http://www.mediafire.com/?59iq0esx071zcic 


DACM did have made an example what makes it easy to make a database in embedded mode.

Romke
Last edited by RPG on Mon Nov 25, 2013 8:26 pm, edited 1 time in total.
LibreOffice 6.3.3.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2195
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Error messages in Base files

Postby arfgh » Mon Nov 25, 2013 4:35 pm

what exactly means to have the db in embedded mode ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby Hagar Delest » Mon Nov 25, 2013 5:48 pm

In embedded mode, the db is inside the .odb file, which is dangerous with AOO, according to the Base gurus here.
Better have your own database and use AOO as a front end.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28951
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Error messages in Base files

Postby arfgh » Mon Nov 25, 2013 7:39 pm

is that possible ? how ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby RPG » Mon Nov 25, 2013 8:35 pm

Hello

I have added now two links before this post.

The last link is direct for downloading of an example file of DACM.

I have only one time test the example of DACM. That makes: I find it better then my explanations and for that reason I point to the the post of DACM on the Dutch forum.

Romke
LibreOffice 6.3.3.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2195
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Error messages in Base files

Postby DACM » Mon Nov 25, 2013 9:53 pm

Base is particularly buggy and underdeveloped. Most Base crashes during form or macro development are recoverable, although any unsaved form or macro development work is lost. Saving your front-end development work is apparently a two-step process. You must save the current window followed by the main Base window; in other words you must save the current document followed by saving the Base container file (.odb).

None of this affects your database tables or user-data, unless the associated back-end data files are actively "embedded" within your Base (.odb) file -- otherwise known as an "embedded database." This configuration leads to data-corruption if Base crashes while closing the .odb file. Unfortunately, "embedded databases" are the default in Base.

The user-community offers an alternative to the Base wizards in the form of preset templates, which generate a traditional "split database" for data-safe operation. In this 'split database' configuration, Base can no longer corrupt your data in the event of a crash. You can lose up to 60 seconds of your current session data-input in the event of a Base crash, but the threat of full database corruption has been virtually eliminated. And you can reduce this 60 second timer to zero or a more reasonable 1 second as necessary once you've adopted a split database configuration with Base, but this timer is rarely an issue either way.

You can extract "embedded database" files from your Base (.odb) file for permanent "split database" operation. We have various step-by-step instructions across this forum but here's a tutorial reflecting the latest options/steps:



Here's more information on a possible fix for the Base default through core-development: http://en.libreofficeforum.org/node/6936
...
Last edited by DACM on Wed Nov 27, 2013 8:07 pm, edited 2 times in total.
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: Error messages in Base files

Postby arfgh » Tue Nov 26, 2013 12:14 am

thx so much to explain about that but tell me a thing...
an existant db, is it possible to split to use this safe way to work ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby DACM » Tue Nov 26, 2013 10:05 am

arfgh wrote:...is it possible to split...an existent [embedded] db ?

Yes. I've added a tutorial and modified the link above with: [Tutorial] Splitting an "embedded 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: Error messages in Base files

Postby arfgh » Tue Nov 26, 2013 1:35 pm

DACM thx so much for the info you give, you cant figure the bad moments i have passed off when base crash.
Anyways, why is actually 'base' underfeveloped in a so long way that has OO ? cant understand the reasson because the other parts of OO works amazing all of them.
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby arfgh » Wed Nov 27, 2013 1:17 pm

is it also possible to split the forms ?
sometimes when AOO crash, also the forms are affected.

How to split them ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby MTP » Wed Nov 27, 2013 4:44 pm

You can make standalone forms that are saved independently of the Base file. [Tutorial] Standalone Forms / Switchboard
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Error messages in Base files

Postby arfgh » Sun Dec 01, 2013 3:32 pm

Ok, and another thing that i cant perform with the splitted database.
I need to modify the datafield types, etc. With the splittled database, base doesnt allow me to do that so, how can i do it now ?

thx in advance
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby Villeroy » Sun Dec 01, 2013 4:13 pm

<where you installed HSQL>/bin/runManager.bat
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: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error messages in Base files

Postby arfgh » Sun Dec 01, 2013 4:35 pm

i have used DACM tutorial to split my database. https://forum.openoffice.org/en/forum/v ... 83&t=65980

I think that i havent used a file called /bin/runManager.bat
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby DACM » Mon Dec 02, 2013 5:55 am

[Wizard] Portable 'split' HSQL database template wrote:
    OVERVIEW: ...[blah, blah]...However, the default 'embedded database' solution remains easier during initial table development due to better GUI support in Base. Conversely, with a 'split database' you can utilize the interactive table-creation tools provided by the Base GUI, but after saving the results you'll need to use SQL or a GUI workaround in order to modify existing field properties...

    ...


    LIMITATIONS: While this template attempts to overcome some glaring deficiencies with Base, it scarcely addresses the holes in the Base GUI with respect to DDL tasks (database schema development) when connected through standard ODBC/JDBC drivers. Specifically, the Base Table Designer exhibits an anomaly when connected to HSQLDB in a split-database configuration. The Table Designer can be used to create Tables and Fields in the normal fashion. But after saving the results, existing field-attributes appear frozen in the Table Designer. So existing attributes can't be modified using this tool. The Table Designer also fails to setup Default field values for most data-types. These deficiencies are limited to the table-design phase, when field-attribute modifications are essential but rare. So when modifying existing table-structures with a split-database of any kind, even novice users should resort to SQL, perhaps utilizing the Base SQL console (Tools > SQL...) or an alternative GUI database manager. However, some GUI workarounds do exist:
    Base limitations as a database manager:
Last edited by DACM on Mon Dec 09, 2013 7:33 am, edited 1 time in total.
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: Error messages in Base files

Postby arfgh » Mon Dec 02, 2013 1:09 pm

DACM, i am a bit lost with all that information.
What i have to try in order to edit the splitted database datafield values ? 'alternative GUI database manager' ?

someone of the follow programs ?

Here's some other free, cross-platform, cross-database, SQL front-ends:
SQL Workbench/J
SQirreL SQL
SQL Developer
Execute Query
iSQl-Viewer
and the amazing, but not free RazorSQL
among others
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby Villeroy » Mon Dec 02, 2013 2:08 pm

You are not working with Base. You are working with a database software. It is perfectly well documented in a file guide.pdf.
Villeroy wrote:<where you installed HSQL>/bin/runManager.bat

Run that batch program and see.
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: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error messages in Base files

Postby arfgh » Mon Dec 02, 2013 2:15 pm

Villeroy, i havent installed nothing. I have use the DACM tutorial in order to split my database.

So i dont have that bat file that you say.
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby RPG » Mon Dec 02, 2013 7:22 pm

Hello

Your problem was:
arfgh wrote:Ok, and another thing that i cant perform with the splitted database.
I need to modify the datafield types, etc. With the splittled database, base doesnt allow me to do that so, how can i do it now
Study in your SQL manual how to alter table and alter you column.

This can possible be done with the SQL tool in OOo-base.

Romke
LibreOffice 6.3.3.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2195
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Error messages in Base files

Postby arfgh » Mon Dec 02, 2013 7:27 pm

explain a bit more, please.

Anyways exist standalone managers to perfomr the same edition that i can do with base ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby arfgh » Sun Dec 08, 2013 1:49 pm

help
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby F3K Total » Sun Dec 08, 2013 2:34 pm

As was written to you, you need to use SQL language to modify the database in a split version.
E.g. you want to modify a currently as VARCHAR(50) defined column "Name" in "Table1" to have a lenght of 100 characters, then execute this command via Tools/SQL ...
Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ALTER COLUMN "Name" VARCHAR(100)
or shorter
Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ALTER "Name" VARCHAR(100)

You can
Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ALTER COLUMN "Name" VARCHAR(100)
ALTER TABLE "Table1" DROP COLUMN "Name"
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100)
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) before "Name"
to define new columns position in "Table1"
...
HTH R
EDIT: last two commands corrected, thanks to Villeroy.
Last edited by F3K Total on Sun Dec 08, 2013 3:08 pm, edited 1 time in total.
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 974
Joined: Fri Dec 16, 2011 8:20 pm

Re: Error messages in Base files

Postby Villeroy » Sun Dec 08, 2013 2:44 pm

ALTER TABLE "Table1" ADD COLUMN "Name2"


The column type is mandatory:
Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100)

Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) DEFAULT 'My default text'

Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) NOT NULL

Code: Select all   Expand viewCollapse view
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) DEFAULT 'My default text' NOT NULL
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: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error messages in Base files

Postby arfgh » Mon Dec 09, 2013 11:35 am

i prefer some gui to perform these operations. Exist someone ?

thx in advance


Also, what operations i must perform in order to embed again the splittled database ? Just the reverse operations.
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Re: Error messages in Base files

Postby DACM » Mon Dec 09, 2013 5:29 pm

arfgh wrote:i prefer some gui to perform these operations. Exist someone ?

RazorSQL ($99.95) features extensive graphical SQL tools for HSQLDB, to include an Alter Table GUI.
...
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: Error messages in Base files

Postby arfgh » Mon Dec 09, 2013 6:24 pm

ok DACM

and some free good solution ?
also, i have tried to inverse the way to embed again the files, and for some reasson i cant edit the database files....

why ?
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
arfgh
 
Posts: 522
Joined: Tue Mar 05, 2013 6:44 pm

Next

Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest