Hi there, ups. I had several problems with transactions in VB using the Begintrans, Committrans and Rollback methods. Maybe there is a general bug that have affects on all three languages (we use ODBC 7.3.0.21 with ADO and RDO connections)
Tilmann SOFTWORK GmbH Help to prevent global warming by writing cool software. -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von Edson Carlos Ericksson Richter Gesendet: Montag, 1. April 2002 17:50 An: [EMAIL PROTECTED] Betreff: RES: Sequence - Problem 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
