dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteSelectStatement Class / SQLiteSelectStatement Constructor
Example

In This Topic
    SQLiteSelectStatement Constructor
    In This Topic
    Creates a new instance of the SQLiteSelectStatement class.
    Syntax
    'Declaration
     
    Public Function New()
    public SQLiteSelectStatement()
    Example
    The following example demonstrates how to use the SQLiteSelectStatement constructor.
    SQLiteSelectStatement stmt = new SQLiteSelectStatement();
    stmt.Columns.Add(new SelectColumn("JOB"));
    stmt.Tables.Add(new SelectTable("emp"));
    
    stmt.Distinct = true;
    
    //select distinct JOB from emp
    string queryText = stmt.ToString();
    Dim stmt As New SQLiteSelectStatement
    stmt.Columns.Add(New SelectColumn("JOB"))
    stmt.Tables.Add(New SelectTable("emp"))
    stmt.Distinct = True
    
    'select distinct JOB from emp
    Dim queryText As String = stmt.ToString
    See Also