DocBook|Search
Class Reference
%CSP.UI.SQL.QueryPane
    
Server:basexml
Instance:SOAXML
User:UnknownUser
  
-
  [BASEXML] >  [%CSP] >  [UI] >  [SQL] >  [QueryPane]
Private  Storage  

class %CSP.UI.SQL.QueryPane extends %CSP.Util.SQLQueryPane

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.

An AutoPage pane that lets a user enter an SQL query and execute it.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
2 2


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


Parameters

• parameter SHOWSQLINFO = 1;
Should this page display SQL Info
• parameter SHOWSTATISTICS = 1;
Should this page display timing stats

Methods

• method CreateResultSet(ByRef pID As %String, ByRef pRS As %ResultSet) as %Status
This method creates the %ResultSet object that is used for the table pane.
A subclass can override this to customize the table displayed by this pane.
pID is array of page variables...
• method ExecuteResultSet(pRS As %ResultSet, ByRef pID As %String) as %Status
This method performs the actual execution of the ResultSet This can be overridden by subclasses