Kbase P18023: Are SQL92 VIEWS static?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Are SQL92 VIEWS static?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
NO. Progress SQL92 VIEWS are not static. SQL92 VIEWS are created using existing tables or views. Information being displayed via a SQL92 VIEW is updated to reflect changes within the referenced table or view. Since SQL92 VIEWS are created using the CREATE VIEW SQL92 syntax, data can be inserted, updated or deleted from them.