Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 895 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 895 Rev 973
Line 9... Line 9...
9 
 
 9 
 
Line 10... Line 10...
10 
DELIMITER |
 10 
DELIMITER |
11 
 
 11 
 
12 
CREATE FUNCTION next_ordre( s1 VARCHAR(255) )
 12 
CREATE FUNCTION next_ordre( s1 VARCHAR(255) )
13 
  RETURNS INT
 13 
  RETURNS INT
14 
  NOT DETERMINISTIC
 14 
  READS SQL DATA
15 
  BEGIN
 15 
  BEGIN
16 
        DECLARE c INT;
 16 
        DECLARE c INT;
17 
        SET c = (SELECT MAX(ordre) + 1 FROM `BASEEDIT`.`cel_obs` where ce_utilisateur = s1);
 17 
        SET c = (SELECT MAX(ordre) + 1 FROM `BASEEDIT`.`cel_obs` where ce_utilisateur = s1);