Write SQLite

NAME

Write-SQLite

SYNOPSIS

Excutes query on the database

DESCRIPTION

PARAMETERS

-Connection

Required?                    true
Position?                    1
Default value                
Accept pipeline input?       false
Accept wildcard characters?  false

-Query

Required?                    true
Position?                    2
Default value                
Accept pipeline input?       true (ByValue)
Accept wildcard characters?  false

-Whatif []

Required?                    false
Position?                    named
Default value                False
Accept pipeline input?       false
Accept wildcard characters?  false

INPUTS

Query in String format

OUTPUTS

EXAMPLES

-------------------------- EXAMPLE 1 --------------------------

C:\PS>Write-SQLite [-Connection] [-Query]

Runs the query on database

-------------------------- EXAMPLE 2 --------------------------

C:\PS>Write-SQLite [-Connection] [-Query] -Whatif

Runs the query on database then rollsback the transaction. WARNING: Whatif only works with "INSERT, UPDATE, and DELETE" commands

-------------------------- EXAMPLE 3 --------------------------

C:\PS>"INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN);" | Write-SQLite [-Connection]

RELATED LINKS

http://www.proxx.nl/