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 CreateSqlField

Metodo CreateSqlFunction

Metodo CreateSqlFunctionString

Metodo CreateSqlInQuery

Metodo CreateSqlJoinQuery

Metodo CreateSqlLikeOperator

Metodo CreateSqlLiteral

Metodo CreateSqlSubQuery

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 QSConnectionCreateSqlSubQuery

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

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

Sintassi

C++

Copy

public QSSqlSubQuery CreateSqlSubQuery(
	string fieldName,
	bool notIn,
	QSSelectCommand subCmd
)

Public Function CreateSqlSubQuery ( 
	fieldName As String,
	notIn As Boolean,
	subCmd As QSSelectCommand
) As QSSqlSubQuery

public:
QSSqlSubQuery^ CreateSqlSubQuery(
	String^ fieldName, 
	bool notIn, 
	QSSelectCommand^ subCmd
)

member CreateSqlSubQuery : 
        fieldName : string * 
        notIn : bool * 
        subCmd : QSSelectCommand -> QSSqlSubQuery

Parametri

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

Valore di ritorno

QSSqlSubQuery
Restituisce una espressione sottoquery.

Vedi anche

Documentazione

Classe QSConnection

Namespace QSAdoNet