The DataExecutionPlan type exposes the following members.
Back to Top
Properties
| Name | Description | |
|---|---|---|
 | AddExecutionData |
Gets or sets the option to Add Execution Data to the Data Execution Plan Result Outputs.
|
| AsyncRead | (Inherited from EngineDataClassBase.) |
| BOF | (Inherited from EngineDataClassBase.) |
| Cancelled |
Returns True if Execution was Cancelled.
|
| ClassType | (Inherited from EngineClassBase.) |
| CommandText | (Inherited from EngineDataClassBase.) |
| CommandTimeout | (Inherited from EngineDataClassBase.) |
| CreatedBy |
Gets or sets the User Name of the Creator.
|
| CreatedDate |
Gets or sets the Date the Item was Created.
|
 | DataAccessLayer | (Inherited from EngineDataClassBase.) |
| DataAdapter | (Inherited from EngineDataClassBase.) |
| DataCommandQueries | |
| DataDistincts |
Gets or sets the Data Distinct options for the Result Data.
|
| DataFile | (Inherited from EngineDataClassBase.) |
| DataFilters |
Gets or sets the Data Filter for Filtering and Sorting Result Data.
|
| DataFiltersEnabled |
Gets or sets the Option to Enable the Data Filters for Filtering and Sorting Result Data.
|
| DataFiltersFile |
Gets or sets the Location of the Data Filters File.
|
| DataFiltersSource |
Gets or sets the Source for the Data Filters.
|
| DataFolderGUID |
Gets or sets the Data Folder GUID of the Item.
|
| DataMapping |
Gets or sets the Data Mapping for the Data Execution Plan.
|
| DataName | (Inherited from EngineDataClassBase.) |
| DataOutputItems | |
| DataPrefix | (Inherited from EngineDataClassBase.) |
| DataReportGUID |
Gets or sets the Data Report ID to be used for the Data Execution Plan.
|
| DataRow | (Inherited from EngineDataClassBase.) |
| DataSchedule | |
| DataScript | |
| DataSet | (Inherited from EngineDataClassBase.) |
| DataSource | (Inherited from EngineDataClassBase.) |
| DataTable | (Inherited from EngineDataClassBase.) |
| DataTruncate | (Inherited from EngineDataClassBase.) |
| 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 Execution Plan.
|
| DisableExecution |
Gets or sets the option to Disable Execution of the Data Execution Plan.
|
| Disposed | (Inherited from EngineClassBase.) |
| DistinctSelectCommand | (Inherited from EngineDataClassBase.) |
| ElapsedTime |
Gets the Elapsed Time of the Data Execution Plan. Read-only
|
| EnableAutoExecute |
Gets or sets the option to Automatically Execute the Data Execution Plan on Selection.
|
| EnableEvents | (Inherited from EngineDataClassBase.) |
| EnableHTMLReport |
Gets or sets the Option to Enable the HTML Report for the Executed Data Plan.
|
| EnableLog |
Gets or sets the Option to Log the Data Execution Plan.
|
| EnableRSSReport |
Gets or sets the Option to Enable the RSS Report for the Executed Plan Result Data.
|
| EnableSecurity |
Gets or sets the option to Enable the Security options for the User Manager Security Module.
|
| EnableSnapShot |
Gets or sets the Option to Snapshot the Data Execution Plan Commands and Result Data in XML format.
|
| EOF | (Inherited from EngineDataClassBase.) |
| ExecutedCount |
Gets or sets the Executed Count.
|
| ExecuteError |
Returns the last Execute Error Message.
|
| ExecuteScript |
Gets or sets the option to Execute a Script or Process.
|
| ExecuteState | |
| FinishTime |
Gets the Finish Time of the Data Execution Plan. Read-only
|
| GetRowDataOption | (Inherited from EngineDataClassBase.) |
| GUID |
Gets or sets the GUID of the Data Execution Plan.
(Overrides EngineDataClassBaseGUID.) |
| 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 Execution Plan has Executed.
|
| HasIndex | (Inherited from EngineDataClassBase.) |
| 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 Execution Plan.
|
| HTMLReportOption |
Gets or sets the HTML Report Option for the Data Execution Plan.
|
| HTMLReportText |
Gets or sets the Report Embedded Text RDL XML or XSLT to be used for the Data Execution Plan.
|
| ID |
Gets or sets the ID of the Data Execution Plan.
(Overrides EngineDataClassBaseID.) |
| IDColumnName | (Inherited from EngineDataClassBase.) |
| IsAdded | (Inherited from EngineDataClassBase.) |
| IsBusy |
Property returns True if the Data Execution Plan 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 Execution Plan is Running.
|
| IsHidden |
Gets or sets the option to Hide the Data Execution Plan from the User View.
|
| 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.) |
| 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.
|
| LastExecutedDate |
Gets or sets the Last Executed Date.
|
| ModifiedBy |
Gets or sets the User Name of the Modifier.
|
| ModifiedDate |
Gets or sets the Date the Item was Modified.
|
| NoMatch | (Inherited from EngineDataClassBase.) |
| Notes |
Gets or sets the Notes for the Data Execution Plan.
|
| OmitXMLDeclaration |
Gets or sets the Option to Omit the XML Declaration from the Result XML Output.
|
| OnDirtyEvent | (Inherited from EngineClassBase.) |
| PageCount | (Inherited from EngineDataClassBase.) |
| PageIndex | (Inherited from EngineDataClassBase.) |
| PageSize | (Inherited from EngineDataClassBase.) |
| PlanItems | |
| PlanName |
Gets or sets the Data Execution Plan Name.
|
| Progress | |
| Properties | (Inherited from EngineClassBase.) |
| PythonDataOption |
Gets or sets the Python Data Option.
|
| PythonEnabled |
Gets or sets the Enabled Option for the Python Script Text or File.
|
| PythonEncrypted |
Gets or sets the Encrypted Option for the Python Script Text or File.
|
| PythonExecuteWhen |
Gets or sets When to Execute the Python Script either After or Before the XQuery / XSLT.
|
| PythonFile |
Gets or sets the Location of the Python Script File.
|
| PythonSchemaOption |
Gets or sets the Python Schema Option.
|
| PythonSource |
Gets or sets the Python Source.
|
| PythonText |
Gets or sets the Python Script Text.
|
| RaiseError | (Inherited from EngineClassBase.) |
| Reference |
Gets or sets the Reference for the Data Execution Plan.
|
| RemoveXMLNamespace |
Gets or sets the Option to Remove the XML Namespace from the Result XML Output.
|
| ReportFile |
Gets or sets the Location to the Report File.
|
| ReportInstance |
Gets or sets the Data Report Instance to be used for the Data Execution Plan.
|
| ReportType |
Gets or sets the Report Type.
|
| ResultCSV |
Property returns CSV Data if any for the Data Class.
|
| ResultCSVSeparator |
Gets or sets the CSV Separator for the Result Data.
|
| ResultCSVTabDelimited |
Gets or sets the CSV Result Data with a Tab Delimiter.
|
| ResultCSVTextQualifier |
Gets or sets the Result CSV Text Qualifier for the Result Data.
|
| ResultCSVWithHeader |
Gets or sets the Option to Enable the Column Header on the Data Results CSV.
|
| ResultData |
The Data Class of the Data Results including the Result Data Set and Data Table.
|
| ResultDataName |
Gets or sets the Data Name for the Result Data.
|
| ResultJSon |
Property returns JSon Data if any for the Data Class.
|
| ResultTableName |
Gets or sets the Table Name for the Result Data.
|
| ResultXML |
Property returns the Result XML for the Data Execution Plan.
|
| ResultXSD |
The Result XSD for the Data Execution Plan.
|
| 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 Plan.
|
| SaveHTMLReportLocation |
Gets or sets the Location to the File Name or Path to Save the HTML Report of the Executed Data Plan.
|
| SaveHTMLReportOption |
Gets or sets the Save HTML Report Option to Save with a fixed File Name or to a Directory with Auto File Name.
|
| SaveHTMLReportToPDF |
Gets or sets the Option to Save a PDF copy of the HTML Report for the Data Execution Plan Result Data.
|
| SaveResultJSon |
Gets or sets the Option to Save the Data Execution Plan Result Data to a JSon File.
|
| SaveResultJSonLocation |
Gets or sets the Location of the File Name or Path to Save the JSon Result Data of the Data Execution Plan.
|
| SaveResultJSonOption |
Gets or sets the Save Result Option to Save the Data Execution Plan Result Data to a JSon File with a fixed File Name or a Directory with Auto File Name.
|
| SaveResultXLSX |
Gets or sets the Option to Save the Data Query Result Data to a XLSX File.
|
| SaveResultXLSXLocation |
Gets or sets the Location of the File Name or Path to Save the XLSX / XLSX Result Data of the Executed Data Command Query.
|
| SaveResultXLSXOption |
Gets or sets the Save Result Option to Save the Data Query Result Data to a XLSX File with a fixed File Name or a Directory with Auto File Name.
|
| SaveResultXML |
Gets or sets the Option to Save the Data Execution Plan Result Data to an XML File.
|
| SaveResultXMLLocation |
Gets or sets the Location of the File or Path to Save the XML Result Data of the Data Execution Plan.
|
| SaveResultXMLOption |
Gets or sets the Save Result Option to Save the Data Execution Plan Result Data to a XML File with a fixed File Name or a Directory with Auto File Name.
|
| SaveResultXSD |
Gets or sets the Option to Save the Data Execution Plan Result Data Schema to an XSD File.
|
| SaveRSSFeed |
Gets or sets the Option to Save an RSS Feed for the Data Execution Plan Result Data.
|
| SaveRSSFeedLocation |
Gets or sets the Location to the File Name or Path to Save the RSS Feed of the Executed Data Plan.
|
| SaveRSSFeedOption |
Gets or sets the Save RSS Feed Option to Save with a fixed File Name or to a Directory with Auto File Name.
|
| SaveRSSFeedWithXSLT |
Gets or sets the Option to Save the RSS Feed with a default XSL Transform thus formatting the Feed.
|
| ScriptArguments |
Gets or sets the Script or Process Arguments.
|
| ScriptFile |
Gets or sets the Location of the Script or Process File to Execute.
|
| ScriptWait |
Gets or sets the option to Wait until the Script or Process has finished Executing.
|
| StartTime |
Gets the Start Time of the Data Execution Plan. Read-only.
|
| StatusIcon |
Gets or sets the Status Icon of the Data Execution Plan.
|
| StatusMessage |
Gets the Status Message of the Data Execution Plan. Read-only.
|
| StatusText |
Gets or sets the Status Text of the Data Execution Plan.
|
| TableName | (Inherited from EngineDataClassBase.) |
| TablePrefix | (Inherited from EngineDataClassBase.) |
| Tag | (Inherited from EngineClassBase.) |
| TypeClassName | (Inherited from EngineClassBase.) |
| XQueryEnabled |
Gets or sets the Enabled Option for the Data XQuery Text or File.
|
| XQueryEncrypted |
Gets or sets the Encrypted Option for the Data XQuery Text or File.
|
| XQueryFile |
Gets or sets the Location of the Data XQuery File.
|
| XQuerySchemaOption |
Gets or sets the XQuery Schema Option for the Data Execution Plan.
|
| XQuerySource |
Gets or sets the XQuery Source for the Data XQuery.
|
| XQueryText |
Gets or sets the Data XQuery Text.
|
| XSLTEnabled |
Gets or sets the Option to Enable the XSLT for the Executed Plan Result Data.
|
| XSLTEncrypted |
Gets or sets the Option to Encrypt the XSLT.
|
| XSLTExecuteWhen |
Gets or sets When to Execute the Data XSLT.
|
| XSLTFile |
Gets or sets the Location of the XSLT File to be used for the Data Execution Plan.
|
| XSLTSource |
Gets or sets the XSLT Source for the Data Execution Plan.
|
| XSLTText |
Gets or sets the Embedded Text XSLT to be used for the Data Execution Plan.
|
See Also
(C). 2001 - 2021 AJE Software (http://www.ajecomponents.co.uk/copyright.shtml)