---

Проверяем и добавляем Goods supplier number
try { $cmd = $Connection.CreateCommand()
$cmd.CommandText = "SELECT [Goods supplier number] FROM [$Item] WHERE 1 = 0"

$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Goods supplier number] TEXT(50) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}
Проверяем и добавляем Goods supplier name
try { $cmd = $Connection.CreateCommand()
$cmd.CommandText = "SELECT [Goods supplier name] FROM [$Item] WHERE 1 = 0"

$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Goods supplier name] TEXT(255) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}
Проверяем и добавляем Complete Name
try { $cmd = $Connection.CreateCommand()
$cmd.CommandText = "SELECT [Complete Name] FROM [$Item] WHERE 1 = 0"

$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Complete Name] TEXT(255) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}