Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Temporary Tables and Views

Using Forms, Labels and Reports with Temporary Tables/Views

Scroll Prev Top Next More

Not only can forms, reports, and labels be based upon temporary tables/views, the temporary object creation may also be performed dynamically within the form/report/label EEPs and actions.  

 

Forms

For forms, the On Before Start EEP may be used to create a temporary table/view before the form is started. Select the Form Properties button on the Edit toolbar, and then the "EEPs > On Before Start > Edit Custom EEP" menus to define EEP code before the form starts. The form's On Before Design action may also be used to create the same temporary table/view definition, allowing seamless form development. Select "Layout > On Before Design Action..." from the main menu bar to define an action before the form is opened in the designer.

 

Reports/Labels

With reports and labels, the Before Generate action may be used to create a temporary table/view before the report/label is generated. Select the "Report (or Label) > Action > Before Generate" from the main menu bar to define an action before the report/label is generated. The On Before Design action may also be used to create the same temporary table/view definition, allowing seamless report/label development. Select "Report (or Label) > Action > On Before Design..." from the main menu bar to define an action before the report/label is opened in the designer.

 

Aside from forms, reports, and labels, it is also common to predefine temporary tables/views in command files and startup files, or as deemed necessary by an application's logic.