I have exactly same problem, but I work with Java (so, I think that it's not a languagem problem)...
Atenciosamente, Edson Carlos Ericksson Richter Gerente de Tecnologia ECONET Solu��es Web +55 61 326 5115 -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Em nome de Pavithra Enviada em: segunda-feira, 1 de abril de 2002 06:48 Para: [EMAIL PROTECTED] Assunto: Sequence - Problem Hi, I am having some problem with sequence. This is how i create a sequence. Programming Language - Pro*C ( Linux ) CREATE SEQUENCE TransId_Seq START WITH 1 INCREMENT BY 1 MAXVALUE 100000000 NOCYCLE ; I entered 10 transaction yesterday. If i enter another transaction today ,the sequence TransId_Seq should start from 11. But it is starting from 22 . We haven't entered any transaction in the mean time . We have tested this several times. The number generated by sequence is not continuous. ( We are using TransId_Seq.NextVal to get the Sequence value ) Continuously using sequence does not cause any problem. But if there is a break for 1 or 2 days then we are facing this problem. With Regards, Pavithra.P _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/02 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
