Tim

><< As long as it doesn't do it in the real world its not to important. >>
>
>You'll see the behavior if you use a mix of SQL.Text:='..... ' combined
>with SQL.Assign(....

Don't think I've ever done that. SQL.Text := and SQL.Add yes

><< But that raises the question in my mind of when does the view have to be
>refreshed? >>
>
>When does it have to be refreshed by the user/developer, or when does it
>have to be refreshed by EDB ?

I was thinking more ElevateDB than user/developer since you're not in charge of the latter

Roy Lambert [Team Elevate]

Roy,

<< I was thinking more ElevateDB than user/developer since you're not in
charge of the latter >>

It has to be refreshed whenever EDB detects that it has been changed.  The
change detection process for views is the same as for tables - if EDB has to
read any part of the table from disk, it checks for changes and then dumps
its local cache for that table if it finds any changes.  With views, the
change detection check involves all tables in the view, as opposed to just
one table.

--
Tim Young
Elevate Software
www.elevatesoft.com