From: Jorg J. <jj...@us...> - 2004-09-28 05:30:42
|
Update of /cvsroot/compiere/db/database/Create In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11019/database/Create Modified Files: Sequences.sql Log Message: . Index: Sequences.sql =================================================================== RCS file: /cvsroot/compiere/db/database/Create/Sequences.sql,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** Sequences.sql 2 May 2004 01:52:22 -0000 1.9 --- Sequences.sql 28 Sep 2004 05:30:30 -0000 1.10 *************** *** 60,89 **** INCREMENT BY 1 / - - /** - * Allocation No - */ - DROP SEQUENCE C_Allocation_Seq - / - /*ORACLE>*/ - DECLARE - No NUMBER(10) := 1; - Cmd VARCHAR2(255); - BEGIN - -- Get Start No - SELECT NVL(MAX(AllocationNo),0) + 1 - INTO No - FROM C_Allocation; - -- - Cmd := 'CREATE SEQUENCE C_Allocation_Seq START WITH ' - || No - || ' INCREMENT BY 1'; - DBMS_OUTPUT.PUT_LINE(Cmd); - EXECUTE IMMEDIATE Cmd; - END; - /*<ORACLE*/ - /*POSTGRESQL> - CREATE SEQUENCE C_Allocation_Seq START 100 INCREMENT 1 - <POSTGRESQL*/ - / - --- 60,61 ---- |