Only some data saving in forms

Discuss the database features

Only some data saving in forms

Postby astepnitz » Thu Feb 08, 2018 9:40 pm

I am brand new to Base. I am trying to build a database in which to track human rights violations for a non-profit. I have made a table and a form into which the data can be entered. The data is a combination of text fields, tick boxes, option buttons and combo boxes. When I make an entry into a record it only saves the data in the text fields and the tick boxes. Everything I enter in the option buttons or combo boxes will be lost as soon as a navigate to the next record.

I have made a fake entry in the database and taken screen shots to show what is happening.

Picture 1 is what it looks like once I've filled in the various parts of the form - you can see I have chosen some of the tick boxes and entries from the drop down boxes as well.

Picture 2 is what it looks like when I move forward to the next record - the sheet is blank, ready for a new entry - great.

Picture 3 is what then happens if I navigate back to record 1. The client name and ID stay, as do the selected tick boxes, but the drop down choices are gone. I don't think this is related to saving the entry because half of the data are saved every time.

Any help here would be very much appreciated.

Picture 3.png
PICTURE 3 - Half the data are lost on record 1
Picture 2.png
PICTURE 2- Blank form for record 2
Picture 1.png
PICTURE 1 - Data as entered on the form for record 1
OpenOffice 4.1.5 on Mac OS Sierra 10.12.16
Posts: 1
Joined: Thu Feb 08, 2018 9:18 pm

Re: Only some data saving in forms

Postby LilZebra » Fri Feb 09, 2018 5:12 am

Converting your database to a standalone type will help with data integrity.

The "Embedded HSQLDB" that you are most likely using eventually corrupts the data file. What happens quite often is that someone spends a lot of time entering data into the Embedded HSQLDB database table and then finds, like you, that the data didn't get saved.

Embedded means make the database resident in RAM and then when it's closed, then Save it. Non-embedded means everytime you do something to the database - adding a record, deleting a record, altering a table schema it will save it to disk.

I've converted my databases since December and it's more stable now.
LibreOffice 6.0.1-1 (Linux Fedora 24 on x86_64) with 'Notebookbar' since 2002-12. LibreOffice user since 2013-current.
User avatar
Posts: 29
Joined: Sun Mar 06, 2016 4:27 pm
Location: Canada

Re: Only some data saving in forms

Postby UnklDonald418 » Fri Feb 09, 2018 7:07 am

The term "drop down boxes" doesn't tell us enough about the form controls and without knowing your table structure it would be difficult to offer any specific help.
You have either List Boxes or Combo Boxes on your form. While they look the same on the form they work differently. A Combo Box stores the selection in a text field while a List Box stores the selection in an integer field.
For details see Combo vs List Box
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
Posts: 654
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Only some data saving in forms

Postby Nocton » Sun Feb 11, 2018 1:58 pm

You do mention that the drop down boxes are combo boxes. The combo box should get its list data from a table, query or SQL statement but in order to save what is selected its data field must be assigned to a field in a table associated with the form.
OpenOffice 4.2.0 on Windows 10
Posts: 472
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests