From: wit_no@spam_dba.kiev.ua   
      
   Hello, Mark,   
      
   near 09:11 19-Jul from zzzzzz45@hotmail.com:   
      
   > Hi,   
   >   
   > I'm trying to write a view that returns a historical view of records   
   > as of a certain date. The records come from a live and historical   
   > table and I need to return the records as they were in the live table   
   > on various dates. The SQL to do this is no problem but it requires a   
   > date value in a where clause in an inner select (the sql is below for   
   > reference - the date value that needs to be variable is hardcoded as   
   > '01/01/2001'). Can I somehow pass this into a view or is a view the   
   > correct approach?   
      
   Try to use package variable (or user-defined function) in view. Set the   
   value before using view.   
      
   > Thanks,   
   > Mark   
      
   [...]   
      
   --   
   wbr,   
   Wit.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)