GetNextSerialValue()

GetNextSerialValue()

Category: Design

Syntax: GetNextSerialValue ( fileName ; fieldName )

Parameters: fileName ”a string or text expression that represents the name of an open file; fieldName ”a string or text expression that represents the name of the field for which to return results.

Description: Returns the next value for a field defined to auto-enter a serialized value.

Examples:

 GetNextSerialValue ("Invoices" ; "InvoiceID") 

might return 5435 .

 GetNextSerialValue ( Get (FileName) ; "Contacts::ContactID") 

might return 84 .

Comments:

It's good practice to use TableOccurrence::FieldName syntax to reference the field in this formula so that it can be evaluated in any context. Without explicitly naming a table occurrence, this function assumes the field can be found in the current context, which may not be the case. Because the auto-entered serial number is defined at the table level, it doesn't matter which of a table's occurrences you reference; they will all return the same result.