Re: Storing of Serial Number

Art S. Kagel wrote: > > You can view it through the SMI/sysmaster interface: But never USE this in application code Guido! Never let application code do this. If you are making application code that needs to know "the next value of a serial" then you are going down a very slippery path, and you will fall over very soon. It's only sensible to use this kind of thing in administration activities, typically when transporting data where there might have been row deletions in the table, yet you want to maintain the current max value when you move the data to a new table or engine.