Data Integrity in Base and Calc

Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
felix
Posts: 13
Joined: Fri May 25, 2012 1:13 am

Data Integrity in Base and Calc

Post by felix »

The attached file explores how to go about ensuring the consistency of data in an OOo environment. Specifically it examines the issues involved and possible solutions to the question of how to deal with errors that occur during processing of a number of items of interdependant data in applications using Calc and Base before all the items have been processed.

The information presented is based upon what I have been able to deduce about how the OOo environment works and some of my inferences may not be 100% correct. Please correct any of my misconceptions if you detect any and add any further information that may make the picture more complete.
Attachments
Datbase Integrity Tutorial.odt
(32.5 KiB) Downloaded 824 times
OpenOffice 3.3
Windows 7
User avatar
DACM
Volunteer
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Data Integrity in Base and Calc

Post by DACM »

Here's a few thoughts:
Attachments
Database Integrity Tutorial 2.odt
(36.89 KiB) Downloaded 733 times
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
Post Reply