OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

SOLVED how to enlarge a database?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
STEVENSMITH100
General User
General User


Joined: 23 Sep 2010
Posts: 45
Location: United States

PostPosted: Mon Apr 23, 2012 11:22 am    Post subject: SOLVED how to enlarge a database? Reply with quote

I have just gotten a request for which my db is not prepared. It is now too small.

What is the save way to a larger db?

Do I build a new db and move the old data with cvs files?

Steven


Last edited by STEVENSMITH100 on Tue May 08, 2012 9:03 am; edited 1 time in total
Back to top
View user's profile Send private message AIM Address
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Mon Apr 23, 2012 11:30 am    Post subject: Reply with quote

Databases can, for all intents and purposes, grow ad infinitum. So could you give us some details such as your database type (flat-file 'text' tables or relational database)? Or otherwise give us some details that have led you to the conclusion that your database is "too small." Do you mean to say that your database type/engine is too limited in terms of built-in features or SQL functions?
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
STEVENSMITH100
General User
General User


Joined: 23 Sep 2010
Posts: 45
Location: United States

PostPosted: Tue Apr 24, 2012 1:10 am    Post subject: Reply with quote

Hello Helpers:

Just so you will know that I am not a complete nut, from '73 to '91 I was a senior programmer. At that time I knew a lot about my field. It has changed..... I got out before PC's or databases files. So I am in a small boat in a vast sea of ignorance, with a long learning curve and a short paddle.

My database file is a “flat-file”. Records are 400 bites long, all fields are char. The file has 250 records, and is a “name/address/birth date/etc. File.

It is my understanding I can't add fields to the end of a record, but this new project request used up my “JIC” (just in case) space. So my problem.

I need to add 12 new fields and some more JIC space

Steven
Back to top
View user's profile Send private message AIM Address
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Tue Apr 24, 2012 11:25 am    Post subject: Reply with quote

I'm sorry but it's still unclear if you're connecting to a CSV file, dBase folder, or SQL database engine.

What do you see in your status bar at the bottom of Base...?


_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
STEVENSMITH100
General User
General User


Joined: 23 Sep 2010
Posts: 45
Location: United States

PostPosted: Tue Apr 24, 2012 4:18 pm    Post subject: type of database in use Reply with quote

It seems I have an "embedded database" and HSQL database engine.

And now I have learned ONE more thing, the list is getting shorter.

Thank You For Your Help

Steven
Back to top
View user's profile Send private message AIM Address
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Tue Apr 24, 2012 11:02 pm    Post subject: Reply with quote

STEVENSMITH100 wrote:
It is my understanding I can't add fields to the end of a record...
I need to add 12 new fields and some more...“JIC” (just in case) space.

Okay, so you're using the default "embedded database" (.odb) file in combination with the built-in HSQLDB 1.8 engine. That's fine as long as you take some precautions as mentioned below (Dropbox or similar folder).

You can use Base to add fields to your table.
See: Add a field to a table.
Perhaps see Maximum Number of Fields for entertainment purposes.

Then see: Protecting 'embedded database' files through an automated 'versioning' folder

Otherwise, there's more robust configurations for your existing database, but it involves some tedious steps (see my signature links below for details).
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group