RE: [plum] How to Add a New Table

[Jeff Fleitz]

This is a known bug I reported a couple months ago.  You are supposed to be able to create a table manually, without using synchronize,  You can actually do this, but the validation messages make it painful.  The trick is to create the table, click off on another node, come back and right click to add a new column, click off again. click on the table and add the NewColumn field as the primary key.  Once you do this, you should be able to avoid error messages and rename the column to whatever your primary key field is.  Then you can add additional columns, relations etc. fine after that.

 

It's ugly to do, but doable.  I am sure this will be on the list for 1.1 fixes.

 

 

Jeff

 

 

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Blankenship
Sent: Monday, May 16, 2005 1:07 PM
To: plum@mail.productivityenhancement.com
Subject: Re: [plum] How to Add a New Table

I agree. Maybe send Adam/David a request to clirify the documentation about adding tables.

On 5/16/05, Dan <[EMAIL PROTECTED] > wrote:

That's exactly what I ended up doing.  But the Plum Help docs sure don't seem to make that clear.  In re-reading the Help on New Table it does say "…adds a new table to your project…"  So I would guess then that project in this sentence means your *.Plum project and NOT your "what you are working on as is commonly referred to as a project"

 

Assuming that this is in fact the case, I would recommend that the Help docs at this point state (something like) "Before selecting New Table from the Database node you must first have added/created the table in your database.  The database node Right-Click menu ONLY adds an existing database table to your Plum project file."

 

 

Dan

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tim Blankenship
Sent: Monday, May 16, 2005 12:50 PM
To: plum@mail.productivityenhancement.com
Subject: Re: [plum] How to Add a New Table

 

I don't think this feature works as you intend it to. I beleive the table has to exist already in the database.
Create the table/columns etc on the database  and synchronize the db.

On 5/16/05, Dan < [EMAIL PROTECTED] > wrote:

How do you Add a New Table to your database from the Plum IDE?

 

In Plum IDE, I right-click on the Database node

This gives me a NewTable form

I enter the Table Name

The Singular and Plural Labels

 

But then ???

 

There are two boxes for the Primary Key, but are empty.

I righ-click on "New Table" in the nodes tree and select New Column and get

 

"You must choose at least one column for this table's primary key. Click OK to return to the form and correct the erro, or click Cancel to cancel your changes."

 

Don't know how to proceed ??? Can't add anything to the NewTable form and can't Right-Click to add a new column.

 

Can anyone help?

 

 

 

 

Dan Kaufman

 

 

 

An Elephant Never Forgets

[EMAIL PROTECTED]

 

--
Tim Blankenship
[EMAIL PROTECTED]
www.vespri.com

--
Tim Blankenship
[EMAIL PROTECTED]
www.vespri.com