On 14 May 2003 at 10:39, Regina Phandu wrote:

>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?

Wrong. FB supports updatable views. You just must write triggers
for doing the real job.

> 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?

Well. Correct me if I'm wrong: you want to insert anything into
view, but not to change anything. If you don't want to change
anything - why to insert anything?
But jokes apart. If you want to insert anything into result set and
see it in this result set but don't want to see these changes in
"real" tables in DB, I'd suggest a client-side temp table. In Delphi
it can be done with MemoryTable (BDE), MemoryData (RX, JVCL) or
ClientDataSet. In FoxPro exists something like 'SELECT .... INTO
CURSOR ...' or 'INTO TABLE'.

SY, Dimitry Sibiryakov.