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 QSConnectionSelect

Effettua una query e restituisce il risultato sotto forma di tabella lua

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

Sintassi

C++

Copy

public LuaTable Select(
	string tablename,
	LuaTable fields,
	LuaTable where,
	LuaTable orderby,
	bool desc
)

Public Function Select ( 
	tablename As String,
	fields As LuaTable,
	where As LuaTable,
	orderby As LuaTable,
	desc As Boolean
) As LuaTable

public:
LuaTable^ Select(
	String^ tablename, 
	LuaTable^ fields, 
	LuaTable^ where, 
	LuaTable^ orderby, 
	bool desc
)

member Select : 
        tablename : string * 
        fields : LuaTable * 
        where : LuaTable * 
        orderby : LuaTable * 
        desc : bool -> LuaTable

Parametri

tablename String: Nome della tabella
fields LuaTable: Tabella LUA : {"DEDID","DEDREV",etc...} or null = *
where LuaTable: Tabella LUA : {["DEDID"] = "pippo", ["REV"] = 0} or null
orderby LuaTable: Tabella LUA : {"DEDID","DEDREV"} or null
desc Boolean: true/false

Valore di ritorno

LuaTable

Vedi anche

Documentazione

Classe QSConnection

Namespace QSAdoNet