Get-NewNumberFromSeries #

SYNOPSIS #

Generates a new number for a specific series.

SYNTAX #

Get-NewNumberFromSeries [[-seriesName] <String>] [[-conn] <Object>] [[-udl] <String>] [[-connStr] <String>]
 [-ProgressAction <ActionPreference>] [<CommonParameters>]

DESCRIPTION #

The Get-NewNumberFromSeries function generates a new number for a specific series in a database using an ADODB connection. The function uses the “cn_NumGetNext” stored procedure and executes it with the series name to get the next available number.

The function takes the series name as a parameter, and it is expected to be one of the following:

EXAMPLES #

Example 1: Next Number of series name ‘KrAuftrag’ #

PS C:\> $i = Get-NewNumberFromSeries -seriesName 'KrAuftrag' -udl 'C:\temp\EULANDA_1 JohnDow.udl'

In this example, a new number for the ‘KrAuftrag’ (Wholesale Order) series is generated using a UDL file to establish the ADODB connection.

PARAMETERS #

-conn #

The connection can be established via an existing ADO object of the type ‘ADODB.Connection’. If the connection is already open, it remains open even after the function has been executed. If it was closed, it will be closed again after the function has been executed.

Type: Object
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-connStr #

A ConnectionString can be specified here, with which a database can be opened.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-seriesName #

Specifies the name of the series for which a new number is to be generated. The value must be one of the series listed in the description.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 0
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-udl #

Alternatively to a connection, a string to a UDL file can be specified. In this case an ADO object is created and closed again at the end of the function.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters #

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS #

None #

OUTPUTS #

System.Object #

NOTES #

Please ensure that the necessary resources such as the “cn_NumGetNext” stored procedure and ADODB connection are available and configured correctly.

RELATED LINKS #