Libreria query DedNet

QSAdoNet

Classe QSConnection

Metodi di QSConnection

Metodo AdjustParameter

Metodo AdjustParameterQuery

Metodo AdjustWhereParameter

Metodo AdjustWhereParameterQuery

Metodo BeginTransaction

Metodo CloseConnection

Metodo ColumnExists

Metodo CreateAddFieldCommand

Metodo CreateAddTableCommand

Metodo CreateBackupCommand

Metodo CreateConnOpCloser

Metodo CreateConstraintCommand

Metodo CreateDeleteCommand

Metodo CreateDropConstraintCommand

Metodo CreateDropFieldCommand

Metodo CreateDropIndexCommand

Metodo CreateDropTableCommand

Metodo CreateIndexCommand

Metodo CreateInsertCommand

Metodo CreateRebuildIndexCommand

Metodo CreateSelectCommand

Metodo CreateSqlBetweenOperator

Metodo CreateSqlBinaryOperator

Metodo CreateSqlColumnField

Metodo CreateSqlConcatField

Metodo CreateSqlConcatInQuery

Metodo CreateSqlField

Metodo CreateSqlFunction

Metodo CreateSqlFunctionString

Metodo CreateSqlInQuery

Metodo CreateSqlJoinQuery

Metodo CreateSqlLikeOperator

Metodo CreateSqlLiteral

Metodo CreateSqlSubQuery

Metodo CreateSqlSubQueryText

Metodo CreateSqlUnaryOperator

Metodo CreateUpdateCommand

Metodo CreateUpdateFieldCommand

Metodo CreateUpdateInsertCommand

Metodo Dispose

Metodo EndTransaction

Metodo Finalize

Metodo GetBackupTables

Metodo GetIdentityColumnForDboSchema

Metodo GetIndexesInfo

Metodo GetNETType

Metodo GetPrimaryKeyInfo

Metodo GetRowGuidColumns

Metodo GetTableFieldsList

Metodo GetTables

Metodo IndexExist

Metodo IsValidConnection

Metodo MakeFieldList

Metodo MakeFieldValueList

Metodo MakeValueList

Metodo OpenConnection

Metodo PerformDuplicatSchemaTable

Metodo PerformTableBackup

Metodo QuoteIdentifier

Metodo QuoteLikeWildechars

Metodo Select

Metodo SelectTxt

Metodo TableExists

Metodo QSConnectionCreateSqlSubQueryText

Crea una sottoquery in forma: "CAMPO IN (SELECT ....)".

Namespace: QSAdoNet
Assembly: QSAdoNet (in QSAdoNet.dll) Versione: 28.0.0

Sintassi

C++

Copy

public QSSqlSubQueryText CreateSqlSubQueryText(
	string fieldName,
	bool notIn,
	string queryText
)

Public Function CreateSqlSubQueryText ( 
	fieldName As String,
	notIn As Boolean,
	queryText As String
) As QSSqlSubQueryText

public:
QSSqlSubQueryText^ CreateSqlSubQueryText(
	String^ fieldName, 
	bool notIn, 
	String^ queryText
)

member CreateSqlSubQueryText : 
        fieldName : string * 
        notIn : bool * 
        queryText : string -> QSSqlSubQueryText

Parametri

fieldName String: Nome del campo di cui verificare l'esistenza nella sotto-query.
notIn Boolean: Negazione dell'inclusione.
queryText String: Comando select da utilizzare per la sotto-query.

Valore di ritorno

QSSqlSubQueryText
Restituisce una espressione sottoquery.

Vedi anche

Documentazione

Classe QSConnection

Namespace QSAdoNet