%CSP.UI.SQL.BrowseTablePane
class %CSP.UI.SQL.BrowseTablePane extends %CSP.Util.TablePane
Customized TablePane for browsing SQL tables. Added textbox to allow user to enter maximum number of rows to load for Open TableMethod Inventory
- DrawBODY()
- ExecuteResultSet()
- GetOpenTableMaxRows()
- GetPageType()
- GetSearchMask()
- OnDrawFilter()
- OpenTableMaxRowsUpdate()
Parameters
parameter HIDEFILTERWHENEMPTY = 0;
display filter box when there are no results so that user can adjust their mask for tables.
Methods
method DrawBODY(pInstance As %CSP.Util.PageInstance) as %Status
Draw the BODY of the detail pane
method ExecuteResultSet(pRS As %ResultSet, ByRef pID As %String) as %Status
This method performs the actual execution of the ResultSet
pID(3) is the searchMask from user clicking the "Go" rather than user clicking a schema which sets $ID(2).
If it is from Go then it is possible user removed the mask then default to "*".
Otherwise retain the last mask.
classmethod GetOpenTableMaxRows() as %Integer
Returns default OpenTableMaxRows value.
method GetPageType() as %String
This method returns the page type based on PageName
classmethod GetSearchMask() as %String
Generic Method being called from the Routine panes to return search mask.
method OnDrawFilter(pInstance As %CSP.Util.PageInstance) as %Status
This callback draws the search mask within the filter box.
classmethod OpenTableMaxRowsUpdate(OpenTableMaxRows As %Integer)
Called from client to update OpenTableMaxRows
Inherited Members
Inherited Properties
- Actions
- Align
- AutoRefresh
- CheckboxId
- CommandFormClass
- CommandFormObject
- CommandSubmitPage
- Commands
- Conditions
- FrameStyle
- HiddenColumns
- ItemsPerPage
- MaxColumns
- MaxResults
- Name
- Query
- SQLQuery
- ShowCheckboxes
- ShowFilter
- ShowLastUpdate
- ShowRowNumbers
- ShowSearchPage
- ShowZebra
- Sortable
- Styles
- Text
- URL
- bgcolor
- border
- cellpadding
- cellspacing
- enableAutoRefresh
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- CreateDataSet()
- CreateResultSet()
- CreateTempFile()
- DrawCommandForm()
- DrawCommands()
- DrawHEAD()
- DrawLastUpdate()
- DrawSearch()
- DrawStatusError()
- DrawTable()
- FilterTable()
- GenerateCode()
- GetDescriptiveText()
- GetItemsPerPage()
- ItemsPerPageUpdate()
- LocalizeColumnName()
- LocalizeText()
- OnDrawHEADTablePane()
- OnGenerateCode()
- PurgeTempData()
- QuoteCOS()
- RefreshTable()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()