sequence number

[lynn_sai]

Hi,
My code:

oraclequery.sql.add('select myseq.nextval "number"')
oraclequery.slq.add('from dual')

works just fine in Oracle version 7
But when we migrate it into Oracle ver 8, this sequence does not work properly, it keeps giving a value 0 whenever I do insert records........ I wonder what causes this error ???????
Please help

Thanks alot.....

 

[Marco Kalter]

Does it also return 0 if you run this select statement in SQL*Plus?

------------------
Marco Kalter
Allround Automations