Class %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.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
2	1	4

Summary

Properties
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

Methods
%%OIDGet	%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

Subclasses
%CSP.UI.SQL.OpenPane	%CSP.UI.SQL.QueryPane	%CSP.UI.System.AuditPane

Parameters

• parameter COLUMNDOMAIN = "%UtilityColumns";

Default localization domain used for column headers

• parameter COLUMNHELPDOMAIN = "%UtilityColumnHelp";

Default localization domain used for column headers help messages

Properties

• property LocalizeColumns as %Boolean [ InitialExpression = 1 ];

If true (default) run column name through localization

Methods

• 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


[BASEXML] > [%CSP] > [Util] > [SQLQueryPane]		Private Storage