Hello all,
I'm trying to do the following insert statement and can't seem to get it to
work:
INSERT INTO domains (dname, user, pass) VALUES('currval('cust_seq')', bob,
something);
I am getting the error that says it that cust_seq.currval is not defined. I
do have cust_seq defined as a Sequence and am wondering how to reference a
sequence variable in an insert statement.
Any ideas?
Thanks,
Kevin
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com