[RBG7-L] - Re: Views and selects

[Doug Hamilton]

Preceed your SELECT statement with "CREATE VIEW <viewname> AS"
As a command file:

--Create a view

--Housekeeping
SET ERROR MESSAGES 677 OFF
DROP VIEW <viewname>
SET ERROR MESSAGES 677 ON

CREATE VIEW <viewname> AS +
SELECT <columns> +
FROM <tablename> +
WHERE <whereclause>

RETURN

That's a pretty straight forward SELECT.  You can do subselects, unions etc
in the definition.

Doug

Jan Johansen wrote:
  
  
 
  
 
    
  I'm pretty sure that I read this on this forum but
can't  locate.
 
   
 
  If I understand correctly a view is kind of a super
select. If  I look at the definition fo a view it starts with SELECT so 
 
  I'm kind of right.
 
   
 
  But the syntax must not be quite the same. If I go
to the view  designer and copy the definition to the R: prompt; 
 
  I get various error messages.
 
   
 
  This is really for my own education but how would I
translate  a view into a command?
 
   
 
  Jan