SQL syntax help

Hi everyone,

I have two SQL query statements like this:

SELECT ID FROM ID_TABLE set variable id = ID in Java code

UPDATE ID_TABLE SET ID= "+ (id+1) + " WHERE ID=" + (id);

Is there a safe way to do this so that it will succeed

for all callers? It is supposed to return a unique,

increasing number every time it's called. Received on Fri Mar 17 2000 - 16:57:05 CST