How are SPS-generated primary keys configured for the SPS Content Administrator?
To configure an SPS-generated primary key, simply change the method to “SPS” and omit the description of the primary key from the set of NAME=Contacts … PRIMARY_KEY=contactId DB_TABLE_NAME=Contacts PRIMARY_KEY_GENERATE=SPS INDEX_SQL=SELECT contactId, lastName FROM Contacts ORDER BY lastName …
The Contacts table will automatically generate a new, invisible identifier for each contact; this will allow users to enter multiple contacts with the same name. Since the primary key is automatically generated, there is no need to create a
To configure an SPS-generated primary key, simply change the method to “SPS” and omit the description of the primary key from the set of NAME=Contacts … PRIMARY_KEY=contactId DB_TABLE_NAME=Contacts PRIMARY_KEY_GENERATE=SPS INDEX_SQL=SELECT contactId, lastName FROM Contacts ORDER BY lastName …
The Contacts table will automatically generate a new, invisible identifier for each contact; this will allow users to enter multiple contacts with the same name. Since the primary key is automatically generated, there is no need to create a
