Generating Sequential and Unique Values
When inserting data or updating a database, sometimes you might need to create "on-the-fly" sequential or unique values for those database fields which do not have any input from the mapped source. For such cases, use the following built-in MapForce library functions:
•auto-number (available in the "core | generator functions" library). This function is generally used to generate primary key values for a numeric field.
•create-guid (available in the "lang | generator functions" library). This function creates a globally-unique identifier (as a hex-encoded string) for the specific field.
Note that values for database fields can also be written using database-generated values. This option is available on the Database Table actions dialog box (see Database Table Actions Settings) and is particularly useful when generating primary keys.