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

<String>

OUTPUTS

<Boolean>

EXAMPLES

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

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

Runs the query on database and return $true or $false


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

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

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


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

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

RELATED LINKS

http://www.proxx.nl/