On Wed, 2012-01-18 at 13:38 -0900, Tim Johnson wrote:
> * Dan Lewis <[email protected]> [120118 13:15]:
> > On Wed, 2012-01-18 at 11:46 -0900, Tim Johnson wrote:
> > > * Dan Lewis <[email protected]> [120118 07:03]:
> > > > On Tue, 2012-01-17 at 16:53 -0900, Tim Johnson wrote:
> > > >
> > > > There are two types of data sources that Base accesses which are
> > > > read only: text files, and spreadsheets. CSV is a text file format.
> > > > To accomplish what you want, open the CSV file in Calc. Then use
> > > > Save As to save the data in dBase format. First create a folder to hold
> > > > the file. Now access the dBase file with Base. Create the form as you
> > > > did before. You will be able to add, modify, or delete data in this
> > > > form.
> > > Thank you Dan.
> > > I found that I could paste directly in the Base pane for a new
> > > database. That got me working.
> > >
> > > I have tried your method and it works more simply.
> > >
> > > Is it possible to add a column to this new dbf-derived table?
> > >
> > > thanks again
> > > --
> > > Tim
> >
> > Yes, you can add another column to the table. You can also create
> > one or more tables with as many columns (fields) as you want.
> Sorry Dan. I didn't ask that questions correctly. What I should
> have said "How can I add a autoincrement primary key" :)
> Right clicking on the table icon does show me the feature to add a
> 'row', but I don't see anything like an autoincrement datatype.
> And I'm not sure if I will need it in this case... but would be
> handy.
> --
> Tim
There are two ways to do this. One is to create a new empty
database. Then open the database with the dbf-derived table in it. Copy
and paste this table into the empty database. When you do so, the Copy
Table wizards. In the first page of the wizard make sure "Definition and
data" is selected. Also check "Create primary key". Suggested name for
the primary key is "ID". You can change this name if you want to do so.
Then work your way through the wizard to create the dbf-derived table in
this new database. (The directions on copying tables are found in the
Getting Started with Base chapter of the Getting Started Guide.) Now you
should have the table you want with a primary key. You will want to edit
this table in Design View (also described in the above chapter). There
set the AutoValue to Yes, save the table changes and close the dialog.
Be absolutely certain to save the database after you save the table
changes. Otherwise, the changes to the table will not written to the new
database file!
--Dan
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
