Hi! is there somebody who can help?
My problem is something like this...

I want to add several records in a table. The table has a field whose value must be system generated but not autogenerated by the database. The value must come from "SELECT max(code) FROM table" statement.

Well, this is quite easy if you're on a standalone environment but my application is on a WAN with quite a large number of users and generating unique code is not easy considering users can ADD SEVERAL NEW RECORDS BEFORE SAVING. That complicates an easy problem.

Now, the question is how can i generate a sequential code on every record I inserted in the table before saving the records?

anybody? With Oracle Developer/2000, it can be accomplished with the Pre-Insert Trigger of a block.

thanks!