3 Replies Latest reply on Mar 4, 2002 4:03 PM by 152901

    CreateDynaset seems to select twice, generating +2 sequence nos.???

      I am using Oracle 8.1.6 and OO40 on NT4SP5

      When I get the .nextval from a sequence using CreateDynaset, I get 2 added to the ID, and not 1. The Sequence cache is set to 0.

      I use :

      sSql = select table_seq.nextval Docid from dual
      Set OD_date=Oradatabase.CreateDynaset(sSql,0)

      I seem to remember something about altering the 'option' parameter.

      Many thanks in advance