> 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