Hi Marc,

> One question: If I write a stored procedure which gets the maximum value

of a field and adds 1 (or if it is null set it to 1), do a insert and give
the new number back.

>
> Would that work if more users would use that stored procedure?

If you mean by "getting the max value" is doing a SELECT MAX(...)
then: No. Multi-user/contextswitching problems.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com