Error messages in Base files
-
- Posts: 7
- Joined: Tue Nov 11, 2008 9:42 pm
Error messages in Base files
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,
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
Re: Error messages in Base files
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.
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
Hungarian forum co-admin
Re: Error messages in Base files
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.
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
Re: Error messages in Base files
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.
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
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
http://forum.openoffice.org/en/forum/vi ... 83&t=17567
DACM did have made an example what makes it easy to make a database in embedded mode.
Romke
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
http://forum.openoffice.org/en/forum/vi ... 83&t=17567
Edit: and this viewtopic.php?f=83&t=61183 and this is for downloading the example file http://www.mediafire.com/?59iq0esx071zcic |
Romke
Last edited by RPG on Mon Nov 25, 2013 8:26 pm, edited 1 time in total.
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: Error messages in Base files
what exactly means to have the db in embedded mode ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
- Hagar Delest
- Moderator
- Posts: 32661
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Error messages in Base files
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.
Better have your own database and use AOO as a front end.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Error messages in Base files
is that possible ? how ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
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
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 7.1.4.2 on openSUSE Leap 15.2
Re: Error messages in Base files
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
...
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
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Error messages in Base files
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 ?
an existant db, is it possible to split to use this safe way to work ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
Yes. I've added a tutorial and modified the link above with: [Tutorial] Splitting an "embedded database"arfgh wrote:...is it possible to split...an existent [embedded] db ?
...
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
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Error messages in Base files
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.
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
is it also possible to split the forms ?
sometimes when AOO crash, also the forms are affected.
How to split them ?
sometimes when AOO crash, also the forms are affected.
How to split them ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
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
Re: Error messages in Base files
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
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
<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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Error messages in Base files
i have used DACM tutorial to split my database. viewtopic.php?f=83&t=65980
I think that i havent used a file called /bin/runManager.bat
I think that i havent used a file called /bin/runManager.bat
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
[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:
- The Frozen 'Field Property' Workaround (adjusting existing Table structures with Base including AutoValue Primary Keys and Default values)
Upgrade to HSQLDB 2.3.x (a fix for the AutoValue setup issue in Base)
Alternative SQL database managers (free, cross-platform, cross-database, administration tools)
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
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Error messages in Base files
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 ?
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
You are not working with Base. You are working with a database software. It is perfectly well documented in a file guide.pdf.
Run that batch program and see.Villeroy wrote:<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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Error messages in Base files
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.
So i dont have that bat file that you say.
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
Hello
Your problem was:
This can possible be done with the SQL tool in OOo-base.
Romke
Your problem was:
Study in your SQL manual how to alter table and alter you column.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
This can possible be done with the SQL tool in OOo-base.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: Error messages in Base files
explain a bit more, please.
Anyways exist standalone managers to perfomr the same edition that i can do with base ?
Anyways exist standalone managers to perfomr the same edition that i can do with base ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
help
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
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 ... or shorter
You can
to define new columns position in "Table1"
...
HTH R
EDIT: last two commands corrected, thanks to Villeroy.
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
ALTER TABLE "Table1" ALTER COLUMN "Name" VARCHAR(100)
Code: Select all
ALTER TABLE "Table1" ALTER "Name" VARCHAR(100)
Code: Select all
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"
...
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
Re: Error messages in Base files
The column type is mandatory:ALTER TABLE "Table1" ADD COLUMN "Name2"
Code: Select all
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100)
Code: Select all
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) DEFAULT 'My default text'
Code: Select all
ALTER TABLE "Table1" ADD COLUMN "Name2" VARCHAR(100) NOT NULL
Code: Select all
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Error messages in Base files
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.
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Re: Error messages in Base files
RazorSQL ($99.95) features extensive graphical SQL tools for HSQLDB, to include an Alter Table GUI.arfgh wrote:i prefer some gui to perform these operations. Exist someone ?
...
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
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Error messages in Base files
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 ?
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 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version