Contents Diagrams Roles Schemas Tables Views Procedures Functions

Gartle Budgeting
Part III. Views

Version 2.0, July 20, 2020

Views

ViewDescription
xls27.xl_automatic_handlersThis view selects handlers to disable saving values in log fields.
xls27.xl_online_help_handlersThis view selects handlers to show Online Help menu items in the Actions menu.
xls27.xl_query_list_adminThis view selects database objects to administer the application.
xls27.xl_query_list_setupThis 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

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)Database object schema
TABLE_NAMEnvarchar(128)Database object name
COLUMN_NAMEnvarchar(128)created_by, created_on, modified_by, or modified_on
EVENT_NAMEvarchar(12)DoNotSave
HANDLER_SCHEMAnvarchar(30)NULL
HANDLER_NAMEnvarchar(30)NULL
HANDLER_TYPEvarchar(9)ATTRIBUTE
HANDLER_CODEnvarchar(30)NULL
TARGET_WORKSHEETnvarchar(30)NULL
MENU_ORDERintNULL
EDIT_PARAMETERSbitNULL

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.

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)Database object schema
TABLE_NAMEnvarchar(128)Database object name
COLUMN_NAMEnvarchar(128)NULL
EVENT_NAMEvarchar(7)Actions
HANDLER_SCHEMAnvarchar(128)Database object schema
HANDLER_NAMEnvarchar(280)Online Database Help - <schema>.<name>
HANDLER_TYPEvarchar(13)HTTP or MENUSEPARATOR
HANDLER_CODEnvarchar(4000)Online help hyperlink
TARGET_WORKSHEETnvarchar(30)NULL
MENU_ORDERintHandler order in the context menu (90, 91)
EDIT_PARAMETERSbitNULL

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.

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)Database object schema
TABLE_NAMEnvarchar(128)Database object name
TABLE_TYPEvarchar(9)Database object type (TABLE, VIEW, PROCEDURE, CODE)
TABLE_CODEnvarchar(max)Custom SQL code
INSERT_PROCEDUREnvarchar(max)An object or code used to insert records
UPDATE_PROCEDUREnvarchar(max)An object or code used to update records
DELETE_PROCEDUREnvarchar(max)An object or code used to delete records
PROCEDURE_TYPEnvarchar(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.

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)Database object schema
TABLE_NAMEnvarchar(128)Database object name
TABLE_TYPEvarchar(9)Database object type (TABLE, VIEW, PROCEDURE, CODE)
TABLE_CODEnvarchar(max)Custom SQL code
INSERT_PROCEDUREnvarchar(max)An object or code used to insert records
UPDATE_PROCEDUREnvarchar(max)An object or code used to update records
DELETE_PROCEDUREnvarchar(max)An object or code used to delete records
PROCEDURE_TYPEnvarchar(50)Empty

The SaveToDB add-in and DBEdit allow using it in the connection wizards and ribbon query lists.

See also Configuring Query Lists.

Contents

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK