Skip to content
Marco van Gaal edited this page Aug 5, 2015 · 12 revisions

.NAME

Read-SQLite

.SYNOPSIS

Excutes SELECT query on the database

.PARAMETERS

 -Connection <SQLiteConnection>
     
     Required?                    true
     Position?                    1
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Query <String>
     
     Required?                    true
     Position?                    2
     Default value                
     Accept pipeline input?       true (ByValue)
     Accept wildcard characters?  false

.INPUTS

<String>

.OUTPUTS

<DataTable>

.NOTES

 Author: Proxx
 Web:    www.Proxx.nl 
 Date:    10-06-2015

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------
 
 PS C:\>Read-SQLite [-Connection] <SQLiteConnection> [-Query] <String>
 
 
 
 Runs the query on database and returns <DataTable> object
 
 
 
 
 
 -------------------------- EXAMPLE 2 --------------------------
 
 PS C:\>"SELECT * FROM sqlite_master WHERE type='table';" | Read-SQLite [-Connection] <SQLiteConnection>
 
 
 
 Runs the query on database and returns <DataTable> object

.RELATED LINKS

http://www.proxx.nl/Wiki/Read-SQLite

Clone this wiki locally