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/