Re: sequence help newbie!!

Robin Boscia wrote:

> I am a newbie
>
> We are doing an export and an import, upgrading from 7.3.4 to 8.1.6, also
> upgrading the O.S. and moving all the data to a new machine.
>
> We have everything up and working, except our sequences.
>
> We can see them and they look the same as on the old machine, however when
> we try to open a new ticket, it does not increment properly. It starts back
> at number 1.
>
> We have over 220 sequences and do not really want to drop and recreate all
> of them.
>
> Is there an easy way to get your sequences "working"? without going thru
> massive amounts of scripts?
> Can you put something in the export or the import file to increment
> properly?
>
> Also when you query your sequences, (we did not build the database or the
> tables), we can see the sequence and it's associated table, but how do you
> know what column that sequence would apply to (for incrementation )?
>
> Thanks
> Robin

No.

And the only way to know how a sequence is being used is to read the code being executed.

Daniel A. Morgan Received on Wed May 09 2001 - 00:32:50 CDT