Log On

Please enter your username and your password. (Note: If you registered on or after May 19, 2010 your email address is your username.)

If you've forgotten your password or your username, click here.

Don't have a login? Register now! It only takes a moment, and it's free (although most articles do required a paid subscription).

Account Information

Username:

Password:

Remember me:

If you check this option you will be automatically logged in the next time you come back to this site. Your Username and password will not be remembered. If you want the Username and Password fields filled in automatically the next time you log in, please use your browser's "Remember login" feature.

Clarion Roadmap

Try the roadmap (beta)

Search ClarionMag

Advanced search

From the archives

Multi-User Primary Keys: A Solution

4/7/2006 12:00:00 AM

The easiest way of generating primary key values is to use Clarion's autoincrement feature. But when multiple users access the same table/form simultaneously, this can cause problems. Rhys Daniell shows how to take control of primary IDs in MS SQL using a specialized table, two stored procedures, and some Clarion code.

Links

Download PDFs

Clarion Magazine has moved!