> Ok, here is my problem.
> I have a complicated query. I can do this with view. But, I want to insert something. I can't do this in view, right? That's why I think I need something like temporary tables.
> I need to insert something to this query/view without affecting the tables itself.
> I was thinking to use store procedure but now since you told me that I can't do this in Firebird, so, anybody has any ideas?

I have a similar problem with a statistical analysis over a
period of time. The 'temporary' table for the results is
simply another table in the database which in my case gets
emptied after the report is generated. Other people have an
ID field in their 'temporary' tables, and just delete the
section that relates to that ID.

Cuts the time to create a table and clear it down
afterwards, which is one of the reasons we have not been in
a panic to provide an 'on the fly' method of possibly
corupting the metadata <g>

If the table is linked to the view with the query in, then
the 'extra' fields can be managed easily, I think.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services