Tom Yes you can create views from views but keep in mind this may have an impact on how long it takes to access data in the 2nd view.
To answer your 2nd question you can build your view and then unload the structure for the view. Say you created a view called MyView that includes a column call EmployeeID. And the view is based on EmployeeID = 22 R:> OUT myView.vie R:>UNLOAD STRUCTURE FOR MyView R:> OUT TERM Using RBE or whatever editor you prefer delete all lines before the command CREATE VIEW .. Make sure the word TEMPORARY is between CREATE VIEW DROP VIEW myView Insert SET VAR vEmployeeID INTEGER before CREATE TEMPORARY VIEW. Now change = 22 to = .vEmployeeID Save your file. Now you can just RUN myView.vie from within other code. This will work in a multi user environment because each user can have a different EmployeeID Buddy From: [email protected] [mailto:[email protected]] On Behalf Of tfred Sent: Thursday, June 26, 2014 12:02 AM To: RBASE-L Mailing List Subject: [RBASE-L] - TEMP VIEW Question We have had a problem of multiple machines dropping R:Base in multi-user while creating complicated reports and we are working our way through it. In RBase-l archives, we keep finding suggestions on isolating users. I just changed all our PROJECT commands to TEMP TABLES WHERE LIMIT = 0. Previously used SomeID = 0 which works, but I see how LIMIT can avoid some conflicts which could lead to our problem. Now all REPORTS are being converted to TEMP VIEWS. The smaller reports work great. I am working toward a very large report (15-20 pages) which summarizes a lot of data. It is based on 12 table/views, 7 of which are multi-table views. Several questions: 1. Is it better to create new TEMP VIEW for each individual data table being used (major rewrite needed) or TEMP VIEWS of the existing VIEWS (minimal rewriting)? I assume regular VIEWS are functionally like TABLES. 2. Is there some way to create the TEMP VIEWS with the Query Builder then reload them on the fly using variables or just use QB to build the SQL code that creates the TEMP VIEWS before running the report? I have worked on this before and sometimes the light bulb of understanding just takes a while to come on. Tom Frederick Jacksonville, IL
