The DataCommandQuery type exposes the following members.
Back to Top
Properties
| Name | Description | |
|---|---|---|
 | AddExecutionData |
Gets or sets the option to Add Execution Data to the Data Command Query Result Outputs.
(Inherited from DataQuery.) |
| AlwaysClose | (Inherited from DataSourceConnection.) |
| AsyncRead | (Inherited from EngineDataClassBase.) |
| BOF | (Inherited from EngineDataClassBase.) |
| Builder | (Inherited from DataConnection.) |
| Cancelled |
Returns True if Execution was Cancelled.
|
| ClassType | (Inherited from EngineClassBase.) |
| CommandEncrypted |
Gets or sets the Encrypted Option for the Data Command Text or File.
(Inherited from DataQuery.) |
| CommandFile |
Gets or sets the Location of the Data Command File.
(Inherited from DataQuery.) |
| CommandSource |
Gets or sets the Command Source for the Data Command Query.
(Inherited from DataQuery.) |
| CommandText |
Gets or sets the Data Command Text.
(Inherited from DataQuery.) |
| CommandTimeout | (Inherited from DataSourceConnection.) |
| ConnectionState |
Property returns the Connection State of the Data Source. Read-only.
|
| ConnectionString |
Gets or sets the Data Connection String.
(Inherited from DataSourceBase.) |
| ConnectionTime |
Property returns the Connection Time of the Data Source.
|
| CreatedBy |
Gets or sets the User Name of the Creator.
(Inherited from DataSourceBase.) |
| CreatedDate |
Gets or sets the Date the Item was Created.
(Inherited from DataSourceBase.) |
 | DataAccessLayer | (Inherited from EngineDataClassBase.) |
| DataAdapter | (Inherited from EngineDataClassBase.) |
| DatabaseName | (Inherited from DataConnection.) |
| DataDestinationConnectionGUID |
Gets or sets the Data Destination GUID to be used for the Data Migration.
(Inherited from DataQuery.) |
| DataDestinationConnectionString |
Gets or sets the Data Destination Connection String.
(Inherited from DataQuery.) |
| DataDestinationInstance |
Gets or sets Data Destination Instance for Migration.
(Inherited from DataQuery.) |
| DataDestinationTableName |
Gets or sets the Data Table Name used for mapping the Result Data in the Migration.
(Inherited from DataQuery.) |
| DataDestinationType |
Gets or sets the Data Destination Type.
(Inherited from DataQuery.) |
| DataDistincts |
Gets or sets the Data Distinct options for the Result Data.
(Inherited from DataQuery.) |
| DataFile | (Inherited from EngineDataClassBase.) |
| DataFilters |
Gets or sets the Data Filter for Filtering and Sorting Result Data.
(Inherited from DataQuery.) |
| DataFiltersEnabled |
Gets or sets the Option to Enable the Data Filters for Filtering and Sorting Result Data.
(Inherited from DataQuery.) |
| DataFiltersFile |
Gets or sets the Location of the Data Filters File.
(Inherited from DataQuery.) |
| DataFiltersSource |
Gets or sets the Source for the Data Filters.
(Inherited from DataQuery.) |
| DataFolderGUID |
Gets or sets the Data Folder GUID of the Item.
(Inherited from DataSourceBase.) |
| DataLinkType |
Returns the Location of the Data Source as either a Connection String or Data Raw. Read-only.
|
| DataMapping |
Gets or sets the Data Mapping for the Data Command Query.
(Inherited from DataQuery.) |
| DataMigrationEnabled |
Gets or sets the option to Enable Migration of Result Data to another Data Source.
(Inherited from DataQuery.) |
| DataName | (Inherited from EngineDataClassBase.) |
| DataOutputItems | (Inherited from DataQuery.) |
| DataPrefix | (Inherited from EngineDataClassBase.) |
| DataRaw |
Gets or sets the Raw Data for the Data Command Query.
|
| DataReportGUID |
Gets or sets the Data Report ID to be used for the Data Command.
(Inherited from DataQuery.) |
| DataRow | (Inherited from EngineDataClassBase.) |
| DataSchedule |
Gets or sets the Data Schedule for the Data Command Query.
(Inherited from DataQuery.) |
| DataScript |
Gets or sets the Data Script for the Data Command Query.
(Inherited from DataQuery.) |
| DataServerName | (Inherited from DataConnection.) |
| DataSet | (Inherited from EngineDataClassBase.) |
| DataSource | (Inherited from EngineDataClassBase.) |
| DataSourceConnection | |
| DataSourceConnectionGUID |
Gets or sets the Data Connection GUID to be used for the Data Command.
(Inherited from DataQuery.) |
| DataSourceConnectionText | (Inherited from DataConnection.) |
| DataSourceInstance |
Gets or sets the Data Source Connection Instance to be used for the Data Command Query.
(Inherited from DataQuery.) |
| DataSourceName | (Inherited from DataConnection.) |
| DataSourceType | (Inherited from DataConnection.) |
| DataTable | (Inherited from EngineDataClassBase.) |
| DataTruncate | (Inherited from DataSourceConnection.) |
| DataType | (Inherited from EngineDataClassBase.) |
| DataURI | (Inherited from EngineDataClassBase.) |
| DBCommand | (Inherited from EngineDataClassBase.) |
| DBConnection | (Inherited from EngineDataClassBase.) |
| DefaultSelectCommand | (Inherited from EngineDataClassBase.) |
| DefaultSortOrder | (Inherited from EngineDataClassBase.) |
| Description |
Gets or sets the Description for the Data Command Query.
(Inherited from DataQuery.) |
| DestinationConnectionText |
Gets or sets the Data Destination Connection String.
(Inherited from DataQuery.) |
| DisableExecution |
Gets or sets the option to Disable Execution of the Data Command Query.
(Inherited from DataQuery.) |
| Disposed | (Inherited from EngineClassBase.) |
| DistinctSelectCommand | (Inherited from EngineDataClassBase.) |
| ElapsedTime |
Gets the Execution Elapsed Time of the Data Command Query. Read-only
|
| EnableAutoExecute |
Gets or sets the option to Automatically Execute the Data Command Query on Selection.
(Inherited from DataQuery.) |
| EnableDataMigrationLog |
Gets or sets the option to Enable the Data Execution Log for the Data Migration.
(Inherited from DataQuery.) |
| EnableDataMigrationWarning |
Gets or sets the option to display a Warning Dialog before attempting Data Migration.
(Inherited from DataQuery.) |
| EnableEvents | (Inherited from EngineDataClassBase.) |
| EnableFilterExpressionPrompt |
Gets or sets the Option to display a Select Filter Expression prompt to apply additional Filtering to the Result Data upon Execution.
(Inherited from DataQuery.) |
| EnableHTMLReport |
Gets or sets the Option to Enable the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| EnableLog |
Gets or sets the Option to Log the Executed Data Command.
(Inherited from DataQuery.) |
| EnableRSSReport |
Gets or sets the Option to Enable the RSS Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| EnableSecurity |
Gets or sets the option to Enable the Security options for the User Manager Security Module.
(Inherited from DataQuery.) |
| EnableSnapshot |
Gets or sets the Option to Snapshot the Executed Data Command and Result Data in XML format.
(Inherited from DataQuery.) |
| EncryptConnectionString | (Inherited from DataConnection.) |
| EncryptDataDestinationConnectionString |
Gets or sets the option to Encrypt the Data Destination Connection String for Security.
(Inherited from DataQuery.) |
| EOF | (Inherited from EngineDataClassBase.) |
| ExecutedCount |
Gets or sets the Executed Count.
(Inherited from DataQuery.) |
| ExecuteError |
Returns the last Execute Error Message.
|
| ExecuteScript |
Gets or sets the option to Execute a Script or Process.
(Inherited from DataQuery.) |
| ExecuteState | |
| FinishTime |
Gets the Execution Finish Time of the Data Command Query. Read-only
|
| GetRowDataOption | (Inherited from EngineDataClassBase.) |
| GUID |
Gets or sets the GUID of the Data Command Query.
(Inherited from DataQuery.) |
| GUIDColumnName | (Inherited from EngineDataClassBase.) |
| GUIDOn | (Inherited from EngineDataClassBase.) |
| HandleExceptions | (Inherited from EngineClassBase.) |
| HasError |
Returns True if there was an Execution Error.
|
| HasExecuted |
Flag Indicates if the Data Command Query has Executed.
|
| HasIndex | (Inherited from EngineDataClassBase.) |
| HasResultXSD |
Returns True if the Result Data has a Schema XSD.
|
| HasRows | (Inherited from EngineDataClassBase.) |
| HasSchema | (Inherited from EngineDataClassBase.) |
| HasWarning |
Returns True if there was an Execution Warning.
|
| HasXSD | (Inherited from EngineDataClassBase.) |
| HTMLReportFile |
Gets or sets the Location of the Report File to be used for the Data Command Query.
(Inherited from DataQuery.) |
| HTMLReportOption |
Gets or sets the HTML Report Option for the Data Command.
(Inherited from DataQuery.) |
| HTMLReportText |
Gets or sets the Report Embedded Text RDL XML or XSLT to be used for the Data Command Query.
(Inherited from DataQuery.) |
| ID |
Gets or sets the ID of the Data Command Query.
(Inherited from DataQuery.) |
| IDColumnName | (Inherited from EngineDataClassBase.) |
| IncludeData |
Gets or sets the option to include the Data Results in a Data Execution Plan.
|
| IsAdded | (Inherited from EngineDataClassBase.) |
| IsBusy |
Property returns True if the Data Command Query is Busy.
|
| IsChanged | (Inherited from EngineClassBase.) |
| IsDataBase | (Inherited from EngineDataClassBase.) |
| IsDataFile | (Inherited from EngineDataClassBase.) |
| IsDeleted | (Inherited from EngineDataClassBase.) |
| IsDirty | (Inherited from EngineClassBase.) |
| IsEmpty | (Inherited from EngineDataClassBase.) |
| IsExecuting |
Property returns True if the Data Command Query is Executing.
|
| IsHidden |
Gets or sets the option to Hide the Data Command Query from the User View.
(Inherited from DataQuery.) |
| IsInitialized | (Inherited from EngineDataClassBase.) |
| IsJetProvider | (Inherited from EngineDataClassBase.) |
| IsLoaded | (Inherited from EngineDataClassBase.) |
| IsMSDASQLProvider | (Inherited from EngineDataClassBase.) |
| IsSaved | (Inherited from EngineDataClassBase.) |
| IsSQLProvider | (Inherited from EngineDataClassBase.) |
| IsSynchronized | (Inherited from EngineDataClassBase.) |
| IsValid | (Inherited from DataConnection.) |
| ItemKey | (Inherited from EngineClassBase.) |
| LastErrDescription | (Inherited from EngineClassBase.) |
| LastErrNumber | (Inherited from EngineClassBase.) |
| LastErrSource | (Inherited from EngineClassBase.) |
| LastException | (Inherited from EngineClassBase.) |
| LastExecutedBy |
Gets or sets the Last Executor.
(Inherited from DataQuery.) |
| LastExecutedDate |
Gets or sets the Last Executed Date.
(Inherited from DataQuery.) |
| ModifiedBy |
Gets or sets the User Name of the Modifier.
(Inherited from DataSourceBase.) |
| ModifiedDate |
Gets or sets the Date the Item was Modified.
(Inherited from DataSourceBase.) |
| NamespacePrefix |
Gets or sets the Namespace Prefix for the Data Command Query.
(Inherited from DataQuery.) |
| NamespaceURI |
Gets or sets the Namespace URI for the Data Command Query.
(Inherited from DataQuery.) |
| NoMatch | (Inherited from EngineDataClassBase.) |
| Notes |
Gets or sets the Notes for the Data Command Query.
(Inherited from DataQuery.) |
| OmitXMLDeclaration |
Gets or sets the Option to Omit the XML Declaration from the Result XML Output.
(Inherited from DataQuery.) |
| OnDirtyEvent | (Inherited from EngineClassBase.) |
| PageCount | (Inherited from EngineDataClassBase.) |
| PageIndex | (Inherited from EngineDataClassBase.) |
| PageSize | (Inherited from EngineDataClassBase.) |
| Properties | (Inherited from EngineClassBase.) |
| PythonDataOption |
Gets or sets the Python Data Option.
(Inherited from DataQuery.) |
| PythonEnabled |
Gets or sets the Enabled Option for the Python Script Text or File.
(Inherited from DataQuery.) |
| PythonEncrypted |
Gets or sets the Encrypted Option for the Python Script Text or File.
(Inherited from DataQuery.) |
| PythonExecuteWhen |
Gets or sets When to Execute the Python Script either After or Before the XQuery / XSLT.
(Inherited from DataQuery.) |
| PythonFile |
Gets or sets the Location of the Python Script File.
(Inherited from DataQuery.) |
| PythonSchemaOption |
Gets or sets the Python Schema Option.
(Inherited from DataQuery.) |
| PythonSource |
Gets or sets the Python Source.
(Inherited from DataQuery.) |
| PythonText |
Gets or sets the Python Script Text.
(Inherited from DataQuery.) |
| QueryName |
Gets or sets the Data Command Query Name.
(Inherited from DataQuery.) |
| RaiseError | (Inherited from EngineClassBase.) |
| Reference |
Gets or sets the Reference for the Data Command Query.
(Inherited from DataQuery.) |
| RemoveXMLNamespace |
Gets or sets the Option to Remove the XML Namespace from the Result XML Output.
(Inherited from DataQuery.) |
| ReportFile |
Gets or sets the Location to the Report File.
(Inherited from DataQuery.) |
| ReportInstance |
Gets or sets the Data Report Instance to be used for the Data Command.
(Inherited from DataQuery.) |
| ReportType |
Gets or sets the Report Type.
(Inherited from DataQuery.) |
| ResultConnection | |
| ResultCSV |
Property returns CSV Data if any for the Data Class.
|
| ResultCSVSeparator |
Gets or sets the CSV Separator for the Result Data.
(Inherited from DataQuery.) |
| ResultCSVTabDelimited |
Gets or sets the CSV Result Data with a Tab Delimiter.
(Inherited from DataQuery.) |
| ResultCSVTextQualifier |
Gets or sets the Result CSV Text Qualifier for the Result Data.
(Inherited from DataQuery.) |
| ResultCSVWithHeader |
Gets or sets the Option to Enable the Column Header on the Data Results CSV.
(Inherited from DataQuery.) |
| ResultData |
The Data Results of the Data Command Query either as a Dataset or an XML Document.
|
| ResultDataName |
Gets or sets the Data Name for the Result Data.
(Inherited from DataQuery.) |
| ResultDataType |
Returns the Result Data Source Type. Read-only.
|
| ResultJSon |
Property returns JSon Data if any for the Data Class.
|
| ResultRows |
Property returns the Row Count of the Result Data. Read-only.
|
| ResultSource |
The Data Source of the Data Command Query.
|
| ResultTableName |
Gets or sets the Table Name for the Result Data.
(Inherited from DataQuery.) |
| ResultXML |
The Result XML for the Data Command Query.
|
| ResultXMLType |
Gets or sets the the Result XML Data Type.
|
| ResultXSD |
The Result XSD for the Data Command Query.
|
| RowCount | (Inherited from EngineDataClassBase.) |
| RowIndex | (Inherited from EngineDataClassBase.) |
| RowLimit | (Inherited from EngineDataClassBase.) |
| RowLock | (Inherited from EngineDataClassBase.) |
| RowsAffected | (Inherited from EngineDataClassBase.) |
| RowsRead | (Inherited from EngineDataClassBase.) |
| SaveHTMLReport |
Gets or sets the Option to Save the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveHTMLReportLocation |
Gets or sets the Location to the File Name or Path to Save the HTML Report of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveHTMLReportOption |
Gets or sets the Save HTML Report Option to Save with a fixed File Name or to a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveHTMLReportToPDF |
Gets or sets the Option to Save a PDF copy of the HTML Report for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveResultCSV |
Gets or sets the Option to Save the Data Query Result Data to a CSV File.
(Inherited from DataQuery.) |
| SaveResultCSVLocation |
Gets or sets the Location of the File Name or Path to Save the CSV / XLSX Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultCSVOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a CSV File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultJSon |
Gets or sets the Option to Save the Data Query Result Data to a JSon File.
(Inherited from DataQuery.) |
| SaveResultJSonLocation |
Gets or sets the Location of the File Name or Path to Save the JSon Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultJSonOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a JSon File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultXLSX |
Gets or sets the Option to Save the Data Query Result Data to a XLSX File.
(Inherited from DataQuery.) |
| SaveResultXML |
Gets or sets the Option to Save the Data Query Result Data to an XML File.
(Inherited from DataQuery.) |
| SaveResultXMLLocation |
Gets or sets the Location of the File Name or Path to Save the XML Result Data of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveResultXMLOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a XML File with a fixed File Name or a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveResultXSD |
Gets or sets the Option to Save the Data Query Result Data Schema to an XSD File.
(Inherited from DataQuery.) |
| SaveRSSFeed |
Gets or sets the Option to Save an RSS Feed for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| SaveRSSFeedLocation |
Gets or sets the Location to the File Name or Path to Save the RSS Feed of the Executed Data Command Query.
(Inherited from DataQuery.) |
| SaveRSSFeedOption |
Gets or sets the Save RSS Feed Option to Save with a fixed File Name or to a Directory with Auto File Name.
(Inherited from DataQuery.) |
| SaveRSSFeedWithXSLT |
Gets or sets the Option to Save the RSS Feed with a default XSL Transform thus formatting the Feed.
(Inherited from DataQuery.) |
| ScriptArguments |
Gets or sets the Script or Process Arguments.
(Inherited from DataQuery.) |
| ScriptFile |
Gets or sets the Location of the Script or Process File to Execute.
(Inherited from DataQuery.) |
| ScriptWait |
Gets or sets the option to Wait until the Script or Process has finished Executing.
(Inherited from DataQuery.) |
| StartTime |
Gets the Execution Start Time of the Data Command Query. Read-only.
|
| StatusIcon |
Gets or sets the Status Icon of the Data Command Query.
|
| StatusMessage |
Gets the Status Message of the Data Command Query. Read-only.
|
| StatusText |
Gets or sets the Status Text of the Data Command Query.
|
| TableName | (Inherited from EngineDataClassBase.) |
| TablePrefix | (Inherited from DataSourceConnection.) |
| Tag | (Inherited from EngineClassBase.) |
| TypeClassName | (Inherited from EngineClassBase.) |
| UserID | (Inherited from DataConnection.) |
| UserPassword | (Inherited from DataConnection.) |
| XQueryEnabled |
Gets or sets the Enabled Option for the Data XQuery Text or File.
(Inherited from DataQuery.) |
| XQueryEncrypted |
Gets or sets the Encrypted Option for the Data XQuery Text or File.
(Inherited from DataQuery.) |
| XQueryEngine |
Gets or sets the XQuery Engine to be used for the Data Command Query.
(Inherited from DataQuery.) |
| XQueryFile |
Gets or sets the Location of the Data XQuery File.
(Inherited from DataQuery.) |
| XQuerySchemaOption |
Gets or sets the XQuery Schema Option for the Data Command Query.
(Inherited from DataQuery.) |
| XQuerySource |
Gets or sets the XQuery Source for the Data XQuery.
(Inherited from DataQuery.) |
| XQueryText |
Gets or sets the Data XQuery Text.
(Inherited from DataQuery.) |
| XSLTEnabled |
Gets or sets the Option to Enable the XSLT for the Executed Data Command Result Data.
(Inherited from DataQuery.) |
| XSLTEncrypted |
Gets or sets the XSLT is Encrypted.
(Inherited from DataQuery.) |
| XSLTExecuteWhen |
Gets or sets When to Execute the Data XSLT.
(Inherited from DataQuery.) |
| XSLTFile |
Gets or sets the Location of the XSLT File to be used for the Data Command Query.
(Inherited from DataQuery.) |
| XSLTSource |
Gets or sets the XSLT Source for the Data Command.
(Inherited from DataQuery.) |
| XSLTText |
Gets or sets the Embedded Text XSLT to be used for the Data Command Query.
(Inherited from DataQuery.) |
See Also
(C). 2001 - 2021 AJE Software (http://www.ajecomponents.co.uk/copyright.shtml)