Query Question

[jchollo]

I have a table with a field called Status of Action which has the choices to choose Active, Completed, Closed.

Once an item is closed, how do I go about placing this entry in a closed table. Do I have to set up another table named Closed. How would I write the code to put an entry once closed in another table.

tks

 

[SkipVought]

Hi,

What would the PURPOSE be for putting closed rows in a separate table? Are we talking about millions of rows?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Slippenos]

Doing so will violate the relational database rules. You can't pull it out of that table. Use a query.

 

[Golom]

The usual mechanism is

INSERT INTO myClosedTable
Select * From myOtherTable Where Status = 'CLOSED'

followed by

DELETE * From myOtherTable Where Status = 'CLOSED'

As the others have said though, unless performance is a big issue for the table, you are making an attribute of the data (i.e. CLOSED or NOT CLOSED) dependent on data location. Given that it is a data attribute, it should be a field in the table and all data should be in the same table.

 

[jchollo]

ok - I see. I guess I was thinking when an item is closed, I wanted it not to appear in the table. But creating a query for the active items would do the trick.

tks for enlighten me.