Adding fields to a database

[Greenhalgh, Alan]

Bruce Writes:-

> ----------
> From:  BRUCE ALLEN[SMTP:ballen@alpsnet.com]
> Sent:  Thursday, 29 January 1998 7:07 pm
> To:  powerh-l@lists.swau.edu
> Subject:  Adding fields to a database
> 
> I sent this message before I was subscirbed to this list server so
> excuse
> me if you have seen this question already.  I have a table that has
> had
> some fields added to it (dBase if that matters.)  How do I add these
> fields
> to the folder and table definition?
> 
> TIA 
> Bruce
> 
-------------------------------------------
Bruce,

I assume you are talking about adding additional table fields into an
Impromptu catalog that already has the table concerned included but
before the new field was entered. It's important to remember that when
new tables are added to Impromptu that by default a new folder with the
came name is added. From that point on the Folder is separate to the
table and you can change or maintain the folders and their items
independently of the tables.

What you need to do is go into the Catalog, Tables menu and re add the
table. This will ensure that the new column is included. Then go into
Catalog, Folders menu and use the Generate button to create a new folder
from a table. This well leave you with a new folder in the catalog which
will have all the fields from the table you just select. 

You can then cut (or copy) the new column and paste it into the
appropriate folder depending on the new items business context. You
would typically then remove the folder containing the other columns you
just added.

Hope this answers your question.

Regards,

Alan Greenhalgh
Cognos