Budgeting Application Views
| View | Description |
|---|---|
| xls27.xl_automatic_handlers | This view selects handlers to disable saving values in log fields. |
| xls27.xl_online_help_handlers | This view selects handlers to show Online Help menu items in the Actions menu. |
| xls27.xl_query_list_admin | This view selects database objects to administer the application. |
| xls27.xl_query_list_setup | This view selects database objects to customize the application. |
xls27.xl_automatic_handlers
This view selects handlers to disable saving values in log fields.
Source tables: dbo27.member_permissions, dbo27.members, dbo27.users
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | Database object schema |
| TABLE_NAME | nvarchar(128) | Database object name |
| COLUMN_NAME | nvarchar(128) | created_by, created_on, modified_by, or modified_on |
| EVENT_NAME | varchar(12) | DoNotSave |
| HANDLER_SCHEMA | nvarchar(30) | NULL |
| HANDLER_NAME | nvarchar(30) | NULL |
| HANDLER_TYPE | varchar(9) | ATTRIBUTE |
| HANDLER_CODE | nvarchar(30) | NULL |
| TARGET_WORKSHEET | nvarchar(30) | NULL |
| MENU_ORDER | int | NULL |
| EDIT_PARAMETERS | bit | NULL |
This view must conform with the handler configuration rules of the SaveToDB add-in, and DBEdit and ODataDB applications.
xls27.xl_online_help_handlers
This view selects handlers to show Online Help menu items in the Actions menu.
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | Database object schema |
| TABLE_NAME | nvarchar(128) | Database object name |
| COLUMN_NAME | nvarchar(128) | NULL |
| EVENT_NAME | varchar(7) | Actions |
| HANDLER_SCHEMA | nvarchar(128) | Database object schema |
| HANDLER_NAME | nvarchar(280) | Online Database Help - <schema>.<name> |
| HANDLER_TYPE | varchar(13) | HTTP or MENUSEPARATOR |
| HANDLER_CODE | nvarchar(4000) | Online help hyperlink |
| TARGET_WORKSHEET | nvarchar(30) | NULL |
| MENU_ORDER | int | Handler order in the context menu (90, 91) |
| EDIT_PARAMETERS | bit | NULL |
This view must conform with the handler configuration rules of the SaveToDB add-in, and DBEdit and ODataDB applications.
xls27.xl_query_list_admin
This view selects database objects to administer the application.
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | Database object schema |
| TABLE_NAME | nvarchar(128) | Database object name |
| TABLE_TYPE | varchar(9) | Database object type (TABLE, VIEW, PROCEDURE, CODE) |
| TABLE_CODE | nvarchar(max) | Custom SQL code |
| INSERT_PROCEDURE | nvarchar(max) | An object or code used to insert records |
| UPDATE_PROCEDURE | nvarchar(max) | An object or code used to update records |
| DELETE_PROCEDURE | nvarchar(max) | An object or code used to delete records |
| PROCEDURE_TYPE | nvarchar(50) | Empty |
The SaveToDB add-in and DBEdit allow using it in the connection wizards and ribbon query lists.
See also Configuring Query Lists.
xls27.xl_query_list_setup
This view selects database objects to customize the application.
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | Database object schema |
| TABLE_NAME | nvarchar(128) | Database object name |
| TABLE_TYPE | varchar(9) | Database object type (TABLE, VIEW, PROCEDURE, CODE) |
| TABLE_CODE | nvarchar(max) | Custom SQL code |
| INSERT_PROCEDURE | nvarchar(max) | An object or code used to insert records |
| UPDATE_PROCEDURE | nvarchar(max) | An object or code used to update records |
| DELETE_PROCEDURE | nvarchar(max) | An object or code used to delete records |
| PROCEDURE_TYPE | nvarchar(50) | Empty |
The SaveToDB add-in and DBEdit allow using it in the connection wizards and ribbon query lists.
See also Configuring Query Lists.