> -----Original Message-----
> From: news@... [mailto:news@...]On Behalf Of
> Edison
> >With Firebird, when I change any value in a table that is used
> to generate a
> >View, the data in the View is automatically updated. Is it possible to
> >avoid this ? Is it possible to keep the old data in the view
> and to update
> >then only after a specific command do to it ? Thank you Edison Garcia

Edison,
Svein's response (below) may have been what you were looking for, but when
I read your post
I didn't interpret your question the same way he did. I took it to mean
that you think a view in some way
stores data. If I'm wrong and you really meant that you wanted the view to
keep the old data only in the current transaction
(i.e. while the user is still in the app), then his post should set you
straight.
However, as I said, I think you need to read the documentation on what a
view is. In short, it is
nothing more than a canned sql statement. Thus, when you execute the sql
statement, 'select * from someview',
the Firebird server reprocesses and reexecutes the view's definition sql
statement. "View" is actually one of the
best named features in sql - it is exactly what it says it is, a view into a
combination of one or more tables, for
convenience, to prevent you from having to retype complicated sql joins,
unions, etc in multiple places.
As a starting point, I would the "Working with Views" section of this zip
file:
http://www.ibphoenix.com/downloads/60DataDef.zip

HTH,
Brian

> -----Original Message-----
> From: Svein Erling Tysvaer
> [mailto:svein.erling.tysvaer@...]
> Sent: Thursday, December 12, 2002 4:14 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Is it possible to keep a View changing the original
> table?
>
>
> I think this has to do with your transaction isolation. I guess
> that if you
> select from your view using tiConcurrency isolation, you will not see
> changes done in other transactions (your editable transactions probably
> ought to use tiCommitted isolation).
>
> HTH,
> Set
>
> At 01:11 12.12.2002 -0200, you wrote:
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>