Out SQLiteTable

NAME

Out-SQLiteTable

SYNOPSIS

Creates a <SQLiteTable> from an object

DESCRIPTION

Creates a from an object, Accepts both values from pipe or direct. Works with DataTable and objects.

PARAMETERS

INPUTS

<Object[]> or <DataTable>

OUTPUTS

Success and Error count

EXAMPLES

-------------------------- EXAMPLE 1 --------------------------
C:\PS><Object> | Out-SQLiteTable [-Connection] <SQLiteConnection> [[-Name] <String>]
Inserts Object to table from Pipeline

-------------------------- EXAMPLE 2 --------------------------
C:\PS>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [[-Update] <Column>]
Inserts or ignores records then updates row where -Update <Column> = Row.Value

-------------------------- EXAMPLE 3 --------------------------
C:\PS>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-Replace]
Inserts records or replaces row.

-------------------------- EXAMPLE 4 --------------------------
C:\PS>Import-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-WhatIf]
Shows import query, runs the import but rollsback the changes so no changes are made to database. (debug)

RELATED LINKS

http://www.proxx.nl/