Re: Counter field??

From: tredmond@jacobsolutions.com
Category: Category 1
Date: 30 Nov 1998
Time: 11:30:51
Remote Name: 208.230.128.17

Comments

The technique we use at JSI is to create a document called a "ControlRecord" in the database. Create the counter field on this document and place the document in its own hidden view. Keep the last number used as the data item on the document. Access this number whenever you want to assign a new number. You can get the number using the @DBLOOKUP function add 1 to it and update the field using the @SetDocField function. (Note: Put the Document Unique ID in the view, so you'll have it to use in the @SetDocField argument). This technique works better than using a profile document, because the profile document doesn't get updated often enough in a multi-user environment, thus causing duplicate "sequential" numbers to occur.