Question: I need to create ordered lists for a specific type of genealogy report called a register. In a register, all children are numbered with lower-case Roman numerals, and those with descendants also get an Arabic numeral, like this:

```
First Generation
1. Joe Smith
   2    i. Joe Smith Jr.
       ii. Fred Smith
   3  iii. Mary Smith
       iv. Jane Smith

Second Generation
2. Joe Smith Jr.
       i. Oscar Smith
   4  ii. Amanda Smith
3. Mary Smith
   5   i. Ann Evans 

```

You can see my initial attempt on this fiddle: <https://jsfiddle.net/ericstoltz/gpqf0Ltu/>

The problem is that the Arabic numerals need to be consecutive from generation to generation, that is, over separate ordered lists. When you look at the fiddle, you can see the second generation begins again at 1 for Arabic numerals, but it should begin with 2 because that's the number assigned to that person as the child of 1, and the first of 2's children with descendants should be 4 instead of 5. So the counter is continuing on to the second list in some partial way when I need it to be more consistent.

To clarify: this is not just about sequential numbering. Each person with descendants is identified by a unique number, and that number will appear twice: With that person as a child and with that person as a parent.

The generations need to be separated because of the headings and sometimes there is narrative between them.

I feel I am very close and am just overlooking something to get this to work! 

UPDATE: SOLVED. See fiddle for how I did this with two counters.

Answer: 
The problem is this. The database reads the `;` in your code as an end of the procedure. You probably don't intend it like that :). The `DELIMITER` command takes care of that by changing `;` to something customizable, like `$$`. Try this:

```
DELIMITER $$
CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)
BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW()); 
END$$
DELIMITER ;

```
Try this one

```
DELIMITER //

CREATE PROCEDURE SP_FORM20_POST(
    P_SESSIONID     VARCHAR(256)
)

BEGIN
    INSERT INTO tbForm20
        ( SESSIONID, RegDT)
    VALUES
        ( P_SESSIONID, NOW());

END //

DELIMITER;

```