Rique Gresham wrote:
Hi All,
What I'm trying to do is query a mssql database using a SELECT statement to
get the last
report number from a table, increment that number by 1 and have it display
in a INPUT box.
The data will not INSERT into the database as a new record until one presses
the SUBMIT
Rique,
With almost any SQL database you can "select max(column) + 1 " (or some
such) to get the next available number, but if you plan to have more than
one user on the database at the same time, what will you use to prevent them
both from getting the same number and attempting to save over each o
2 matches
Mail list logo
