Re: Last ID Problem

> Why not first get the current value from the
> sequence, use it for your
> INSERT statement, and then have it handy for the
> rest of the script?

i hate to revisit this old topic, however, i just want
to make sure i'm avoiding future problems.

if i pull nextval then insert it into the id column
where i pulled it from, will the counter ever get "off
track" since i'm doing manual inserts?

can nextval ever become a value that's unexpected?  in
practice, this method is working very well, but i'm
paranoid.  ;-)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com