The DataQuery 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.
|
| AlwaysClose | (Inherited from DataSourceConnection.) |
| AsyncRead | (Inherited from EngineDataClassBase.) |
| BOF | (Inherited from EngineDataClassBase.) |
| Builder | (Inherited from DataConnection.) |
| Cancelled | (Inherited from EngineDataClassBase.) |
| ClassType | (Inherited from EngineClassBase.) |
| CommandEncrypted |
Gets or sets the Encrypted Option for the Data Command Text or File.
|
| CommandFile |
Gets or sets the Location of the Data Command File.
|
| CommandSource |
Gets or sets the Command Source for the Data Command Query.
|
| CommandText |
Gets or sets the Data Command Text.
(Overrides EngineDataClassBaseCommandText.) |
| CommandTimeout | (Inherited from DataSourceConnection.) |
| ConnectionString |
Gets or sets the Data Connection String.
(Inherited from DataSourceBase.) |
| 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.
|
| DataDestinationConnectionString |
Gets or sets the Data Destination Connection String.
|
| DataDestinationInstance |
Gets or sets Data Destination Instance for Migration.
|
| DataDestinationTableName |
Gets or sets the Data Table Name used for mapping the Result Data in the Migration.
|
| DataDestinationType |
Gets or sets the Data Destination Type.
|
| 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.
(Inherited from DataSourceBase.) |
| DataMapping |
Gets or sets the Data Mapping for the Data Command Query.
|
| DataMigrationEnabled |
Gets or sets the option to Enable Migration of Result Data to another Data Source.
|
| DataName | (Inherited from EngineDataClassBase.) |
| DataOutputItems | |
| DataPrefix | (Inherited from EngineDataClassBase.) |
| DataReportGUID |
Gets or sets the Data Report ID to be used for the Data Command.
|
| DataRow | (Inherited from EngineDataClassBase.) |
| DataSchedule |
Gets or sets the Data Schedule for the Data Command Query.
|
| DataScript |
Gets or sets the Data Script for the Data Command Query.
|
| DataServerName | (Inherited from DataConnection.) |
| DataSet | (Inherited from EngineDataClassBase.) |
| DataSource | (Inherited from EngineDataClassBase.) |
| DataSourceConnectionGUID |
Gets or sets the Data Connection GUID to be used for the Data Command.
|
| DataSourceConnectionText | (Inherited from DataConnection.) |
| DataSourceInstance |
Gets or sets the Data Source Connection Instance to be used for the Data Command Query.
|
| 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.
(Overrides DataSourceBase Description.) |
| DestinationConnectionText |
Gets or sets the Data Destination Connection String.
|
| DisableExecution |
Gets or sets the option to Disable Execution of the Data Command Query.
|
| Disposed | (Inherited from EngineClassBase.) |
| DistinctSelectCommand | (Inherited from EngineDataClassBase.) |
| EnableAutoExecute |
Gets or sets the option to Automatically Execute the Data Command Query on Selection.
|
| EnableDataMigrationLog |
Gets or sets the option to Enable the Data Execution Log for the Data Migration.
|
| EnableDataMigrationWarning |
Gets or sets the option to display a Warning Dialog before attempting Data Migration.
|
| 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.
|
| EnableHTMLReport |
Gets or sets the Option to Enable the HTML Report for the Executed Data Command Result Data.
|
| EnableLog |
Gets or sets the Option to Log the Executed Data Command.
|
| EnableRSSReport |
Gets or sets the Option to Enable the RSS Report for the Executed Data Command 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 Executed Data Command and Result Data in XML format.
|
| EncryptConnectionString | (Inherited from DataConnection.) |
| EncryptDataDestinationConnectionString |
Gets or sets the option to Encrypt the Data Destination Connection String for Security.
|
| EOF | (Inherited from EngineDataClassBase.) |
| ExecutedCount |
Gets or sets the Executed Count.
|
| ExecuteScript |
Gets or sets the option to Execute a Script or Process.
|
| GetRowDataOption | (Inherited from EngineDataClassBase.) |
| GUID |
Gets or sets the GUID of the Data Command Query.
(Overrides EngineDataClassBaseGUID.) |
| GUIDColumnName | (Inherited from EngineDataClassBase.) |
| GUIDOn | (Inherited from EngineDataClassBase.) |
| HandleExceptions | (Inherited from EngineClassBase.) |
| HasIndex | (Inherited from EngineDataClassBase.) |
| HasRows | (Inherited from EngineDataClassBase.) |
| HasSchema | (Inherited from EngineDataClassBase.) |
| HasXSD | (Inherited from EngineDataClassBase.) |
| HTMLReportFile |
Gets or sets the Location of the Report File to be used for the Data Command Query.
|
| HTMLReportOption |
Gets or sets the HTML Report Option for the Data Command.
|
| HTMLReportText |
Gets or sets the Report Embedded Text RDL XML or XSLT to be used for the Data Command Query.
|
| ID |
Gets or sets the ID of the Data Command Query.
(Overrides EngineDataClassBaseID.) |
| IDColumnName | (Inherited from EngineDataClassBase.) |
| IsAdded | (Inherited from EngineDataClassBase.) |
| IsChanged | (Inherited from EngineClassBase.) |
| IsDataBase | (Inherited from EngineDataClassBase.) |
| IsDataFile | (Inherited from EngineDataClassBase.) |
| IsDeleted | (Inherited from EngineDataClassBase.) |
| IsDirty | (Inherited from EngineClassBase.) |
| IsEmpty | (Inherited from EngineDataClassBase.) |
| IsHidden |
Gets or sets the option to Hide the Data Command Query 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.) |
| 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.
|
| LastExecutedDate |
Gets or sets the Last Executed Date.
|
| 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.
|
| NamespaceURI |
Gets or sets the Namespace URI for the Data Command Query.
|
| NoMatch | (Inherited from EngineDataClassBase.) |
| Notes |
Gets or sets the Notes for the Data Command Query.
(Overrides DataSourceBase Notes.) |
| 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.) |
| 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.
|
| QueryName |
Gets or sets the Data Command Query Name.
|
| RaiseError | (Inherited from EngineClassBase.) |
| Reference |
Gets or sets the Reference for the Data Command Query.
(Overrides DataSourceBase Reference.) |
| 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 Command.
|
| ReportType |
Gets or sets the Report Type.
|
| 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.
|
| ResultDataName |
Gets or sets the Data Name for the Result Data.
|
| ResultTableName |
Gets or sets the Table Name for the Result Data.
|
| 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.
|
| SaveHTMLReportLocation |
Gets or sets the Location to the File Name or Path to Save the HTML Report of the Executed Data Command Query.
|
| 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 Executed Data Command Result Data.
|
| SaveResultCSV |
Gets or sets the Option to Save the Data Query Result Data to a CSV File.
|
| 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.
|
| 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.
|
| SaveResultJSon |
Gets or sets the Option to Save the Data Query 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 Executed Data Command Query.
|
| 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.
|
| SaveResultXLSX |
Gets or sets the Option to Save the Data Query Result Data to a XLSX File.
|
| SaveResultXML |
Gets or sets the Option to Save the Data Query Result Data to an XML File.
|
| SaveResultXMLLocation |
Gets or sets the Location of the File Name or Path to Save the XML Result Data of the Executed Data Command Query.
|
| 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.
|
| SaveResultXSD |
Gets or sets the Option to Save the Data Query Result Data Schema to an XSD File.
|
| SaveRSSFeed |
Gets or sets the Option to Save an RSS Feed for the Executed Data Command Result Data.
|
| SaveRSSFeedLocation |
Gets or sets the Location to the File Name or Path to Save the RSS Feed of the Executed Data Command Query.
|
| 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.
|
| 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.
|
| XQueryEncrypted |
Gets or sets the Encrypted Option for the Data XQuery Text or File.
|
| XQueryEngine |
Gets or sets the XQuery Engine to be used for the Data Command Query.
|
| XQueryFile |
Gets or sets the Location of the Data XQuery File.
|
| XQuerySchemaOption |
Gets or sets the XQuery Schema Option for the Data Command Query.
|
| 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 Data Command Result Data.
|
| XSLTEncrypted |
Gets or sets the XSLT is Encrypted.
|
| 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 Command Query.
|
| XSLTSource |
Gets or sets the XSLT Source for the Data Command.
|
| XSLTText |
Gets or sets the Embedded Text XSLT to be used for the Data Command Query.
|
See Also
(C). 2001 - 2021 AJE Software (http://www.ajecomponents.co.uk/copyright.shtml)