Code: Select all
Month_days_lookup := RELATION {
TUPLE { sort sort# ( 00 ), name ID ( "" ), days N31Z ( 0 ), prior_days N366Z ( 0 ) },
TUPLE { sort sort# ( 01 ), name ID ( "January" ), days N31Z ( 31 ), prior_days N366Z ( 0 ) },
TUPLE { sort sort# ( 02 ), name ID ( "February" ), days N31Z ( 28 ), prior_days N366Z ( 31 ) },
TUPLE { sort sort# ( 03 ), name ID ( "March" ), days N31Z ( 31 ), prior_days N366Z ( 60 ) },
TUPLE { sort sort# ( 04 ), name ID ( "April" ), days N31Z ( 30 ), prior_days N366Z ( 91 )},
TUPLE { sort sort# ( 05 ), name ID ( "May" ), days N31Z ( 31 ), prior_days N366Z ( 121 ) },
TUPLE { sort sort# ( 06 ), name ID ( "June" ), days N31Z ( 30 ), prior_days N366Z ( 152 ) },
TUPLE { sort sort# ( 07 ), name ID ( "July" ), days N31Z ( 31 ), prior_days N366Z ( 182 ) },
TUPLE { sort sort# ( 8 ), name ID ( "August" ), days N31Z ( 31 ), prior_days N366Z ( 213 ) },
TUPLE { sort sort# ( 9 ), name ID ( "September" ), days N31Z ( 30 ), prior_days N366Z ( 244 ) } };
Code: Select all
Month_days_lookup := RELATION {
TUPLE { sort sort# ( 08 ), name ID ( "August" ), days N31Z ( 31 ), prior_days N366Z ( 213 ) } };
Month_days_lookup := RELATION {
TUPLE { sort sort# ( 09 ), name ID ( "September" ), days N31Z ( 30 ), prior_days N366Z ( 244 ) } };
Code: Select all
ERROR: Encountered "8" at line 2, column 25.
ERROR: Encountered "9" at line 2, column 25.
Code: Select all
TYPE sort# POSSREP { VALUE INTEGER CONSTRAINT VALUE >= 0 };