[RBG7-L] - RE: Views and selects

[Sami Aaron]

Jan -   To take Javier's explanation a little further, once the view is saved in your database, you can then issue the SELECT command on your view or base a report or form on the view, rather than on the underlying tables.   A view is not _exactly_ a super SELECT - it's just a saved SELECT statement that you can use over and over again.   Sami   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED]   From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Wednesday, February 23, 2005 10:40 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Views and selects Jan: The easiest way to create a view command is to define the view using the view designer, make sure it is correct and save it, then, right click on the view and select unload. The view definition will be downloaded to a file that you can open with any text editor and cut and paste the command. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Jan Johansen Sent: Wednesday, February 23, 2005 10:32 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Views and selects   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