Larry,
I agree with you in principal except I like to use VIEWS instead of temporary tables. I am sure that there may be instances where you could only do something with a temporary table but do't discount the use of VIEWS since you can have VIEWS of VIEWS.
One advantage of using a VIEW is that the data is readily available for viewing with BROWSE or in STORED PROCEDURES. You can set the the underlying query buy using F3. With temporary tables your underlying query is hidden in a program somewhere in your application..
If you need a table you could always PROJECT it from the view.
In the years that I have been a member of this list it has been my impression that VIEWS are an underutilized feature of RBase.
Jim Bentley
American Celiac Society
Lawrence Lustig <[EMAIL PROTECTED]> wrote:
I agree with you in principal except I like to use VIEWS instead of temporary tables. I am sure that there may be instances where you could only do something with a temporary table but do't discount the use of VIEWS since you can have VIEWS of VIEWS.
One advantage of using a VIEW is that the data is readily available for viewing with BROWSE or in STORED PROCEDURES. You can set the the underlying query buy using F3. With temporary tables your underlying query is hidden in a program somewhere in your application..
If you need a table you could always PROJECT it from the view.
In the years that I have been a member of this list it has been my impression that VIEWS are an underutilized feature of RBase.
Jim Bentley
American Celiac Society
Lawrence Lustig <[EMAIL PROTECTED]> wrote:
<<
Are there any other work arounds?
>>
Dan: I have started trying to avoid putting any calculation logic at all in reports. Instead, I generate the data into a temporary table and make a "simple" report off of that. I do it because:
- I have more power available for the calculations (the full R:Base language, not just report expressions).
- Once I generate the table I can "present" the information in many different ways (different report formats, charts, browse, export, etc).
- I hate having to hunt for program logic in too many places.
So my suggestion is that replace all your report logic with code to get the data you want in a temp table and then just use the report writer to format it.
--
Larry
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
