Creates a SQL command to retrieve a delivery note incl. positions
Get-DeliverySql [[-deliveryId] <Int32>] [[-deliveryNo] <Int32>] [<CommonParameters>]
Generates two SQL commands that are returned as an array of strings. One is a query of a delivery note header and the other is a query of the corresponding positions. The delivery note is found via the ID or its delivery note number.
EXAMPLE 1:Creates an SQL query to retrieve a delivery bill including its attached line items #
[int]$deliveryNo = 430220 [string]$sql= Get-DeliverySql -deliveryNo $deliveryNo [System.Object]$data = Get-DataFromSql -sql $sql -conn $script:conn
Creates a string array with two SQL queries and a link relationship, which is required in
Get-DataFromSql if it is a set from Master / Detail. In the
Get-DataFromSql function, a retrieval with the second SQL query is then performed for each delivery bill.
The delivery note is searched for by its ID.
Type: Int32 Parameter Sets: (All) Aliases: Required: False Position: 0 Default value: 0 Accept pipeline input: False Accept wildcard characters: False
The delivery note is found via its delivery note number.
Type: Int32 Parameter Sets: (All) Aliases: Required: False Position: 1 Default value: 0 Accept pipeline input: False Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.