Auto Actions: Allocating sequential Entry Numbers and Member numbers

Hi,
We are loading a long running membership system into CB/CBSubs. There are basically two classes of registration (RegisteredVisitors and Members). On initial entry both a RegisteredVisitor and a Member are allocated a sequential Entry Number. A new Member is allocated a sequential Membership Number. The allocated Entry and (fewer) Membership Numbers stay with the user for their lifetime. (Often a RegistedVisitor will become a Member and will then be allocated a Member Number.) We will load our historic records using cbjuice2, CB fields for the existing Entry Numbers and Membership Numbers have been created and will be populated.

For new registrations we think the best method of accessing the next sequential number (for each of Entry and Membership numbers) would be to use Auto Actions and query the MySQL DB for the current highest number allocated Number (Entry or Membership as appropriate) and add one. Is there a better way? Is this feasible?

Can you assist with some code guidance please?

Regards,

Robert

For new registrations we think the best method of accessing the next sequential number (for each of Entry and Membership numbers) would be to use Auto Actions and query the MySQL DB for the current highest number allocated Number (Entry or Membership as appropriate) and add one. Is there a better way? Is this feasible?

That's doable using a Query action on the after registration trigger.

Can you assist with some code guidance please?

We do not provide custom coding assistance here. We only provide simple examples at best of which there are many around the forums. Your query would likely be an update query on _comprofiler setting the value of the field to a subquery. Example as follows.