My PowerShell functions do not appear to be used
- by Frank
Hi there,
I have a ps1 script in which I define 2 functions as such:
function Invoke-Sql([string]$query) {
Invoke-Sqlcmd -ServerInstance $Server -Database $DB -User $User -Password $Password -Query $query
}
function Get-Queued {
Invoke-Sql "Select * From Comment where AwaitsModeration = 1"
}
I then call the ps1 file by typing it in (it's in a folder in the path, and autocompletion works)
However, I cannot start using the functions. I am confused, because when I copy / paste the functions into the console, all is fine and they work. I also have a function defined in my profile, and it works. Where am I thinking wrong, why doesn't it work what I'm trying to do?