At 09:37 PM 4/18/2010, Tom Frederick wrote:
I realize this can be done using TEMP tables, but I really like the benefits of using views. I am also trying very hard to stay consistent in how the database works because I am not the only one doing the programming. Based on the error message, is there some way to declare the variable during the unload /rebuild process so view based variables simply work like they do in PACK and RELOAD?
Tom, Technically, a view is a SELECT command with collection of columns from the available tables. Although you can think of a view as a temporary table, a view does not store data. A view is a stored query. The query specifies the tables, columns, and linking columns that make up the view. Each time you use the view, R:BASE reconstructs it from the query. You can define the conditional dynamic TEMPORARY VIEW with WHERE clause, right before printing the report or label. The same definition can also be stored as "On Before Design Action" while in Report or Label Designer to facilitate the design as compared to pre-defining the required temporary table prior to designing the report or label. It is much faster and totally independent and session specific in a multi-user environment. Having said that, if you wish to keep all your existing DB maintenance routines, etc., and not get those -ERROR- messages related to missing global variables, you can use "ON CONNECT/PACK RUN ... SAVE" command to achieve your goal. For complete details, refer to: HELP | Index | ON CONNECT or HELP | Index | ON CONNECT/PACK Should you require further assistance, feel free to post here. Very Best R:egards, Razzak.
