Posted by DickChristoph on 03/01/06 18:33

Hi

What exactly do you mean by "call the views every time the data change in
the selected table."?

When the data is added/updated/deleted from the underlying table the View is
automatically updated. (It is just a select statement).

Are you concerned about updating the user interface where the View is used
as a source for a datgrid or something. If so you have to find some way to
tell the Client program to requery the database, perhaps using the View.
when a database update occurs.

--
-Dick Christoph
<solidsna2@gmail.com> wrote in message
news:1141226630.058373.30490@e56g2000cwe.googlegroups.com...
> Hi,
>
> I am new to using SQL. I want to be able to exucute a query that I
> place in a view. I want this views to be executed every time a value
> change in one of the table in a particular field. So my guess was to
> use a trigger that will call the views every time the data change in
> the selected table. Is this the proper way of doing thing? Should I
> use other SQL tools to achive this. I search for exemple of trigger
> executing views but did not found anything as of yet. Let's use this
> dummy name for the exemple:
>
> Database: DB1
> Table: Tbl1
> Special field in Tbl1: flag
> Views name: views_01
>
> Thank you.
>
> Philippe
>

[Back to original message]