Home > Class Reference > ENSLIB namespace > %CSP.Util.SQLQueryPane


class %CSP.Util.SQLQueryPane extends %CSP.Util.TablePane

This class is used internally by Caché. You should not make direct use of it within your applications. There is no guarantee made about either the behavior or future operation of this class.

This pane displays the results of an SQL query within an HTML table.


Parameters Properties Methods Queries Indices ForeignKeys Triggers
2 1 4


Actions Align AutoRefresh CheckboxId
CommandFormClass CommandFormObject CommandSubmitPage Commands
Conditions FrameStyle HiddenColumns ItemsPerPage
LocalizeColumns MaxColumns MaxResults Name
Query SQLQuery ShowCheckboxes ShowFilter
ShowLastUpdate ShowRowNumbers ShowSearchPage ShowZebra
Sortable Styles Text URL
bgcolor border cellpadding cellspacing
%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 DrawBODY
DrawCommandForm DrawCommands DrawHEAD DrawLastUpdate
DrawSearch DrawStatusError DrawTable ExecuteResultSet
FilterTable GenerateCode GetColorByColumn GetDescriptiveText
GetItemsPerPage ItemsPerPageUpdate LocalizeColumnName LocalizeText
OnDrawFilter OnDrawHEADTablePane OnGenerateCode PurgeTempData
QuoteCOS RefreshTable XMLDTD XMLExport
XMLExportToStream XMLExportToString XMLNew XMLSchema
XMLSchemaNamespace XMLSchemaType
%CSP.UI.SQL.OpenPane %CSP.UI.SQL.QueryPane


parameter COLUMNDOMAIN = "%UtilityColumns";
Default localization domain used for column headers
parameter COLUMNHELPDOMAIN = "%UtilityColumnHelp";
Default localization domain used for column headers help messages


property LocalizeColumns as %Boolean [ InitialExpression = 1 ];
If true (default) run column name through localization


method DrawBODY(pInstance As PageInstance) as %Status
Draw the BODY of the detail pane
method GetColorByColumn() as %String
Subclass can override this to specify the name of column used to distinctly color rows
classmethod LocalizeColumnName(pName As %String, Output pHelpMsg) as %String
Lookup a column name in the localization global and return localized version if present
method OnDrawHEADTablePane(pInstance As %CSP.Util.PageInstance) as %Status