MAX(iChair)
right ?CREATE CURSOR curTable (cTableNumber c(1), iChair I) INSERT INTO curTable VALUES ('4',6)Agnes
>SELECT cTableNumber, cTableNumber + "." + TRANSFORM(sn) AS cChairNumber ; >FROM curTable ; > JOIN ( ; > SELECT RECNO() AS sn FROM curTable ; > UNION ALL ; > SELECT RECNO() + RECCOUNT() AS sn FROM curTable ) crsNumbers ON curTable.iChair >= crsNumbers.sn >>
>* Create numbers table >lnMaxChairs = 8 >CREATE CURSOR crsNumbers (sn i) >FOR i=1 TO lnMaxChairs > INSERT INTO crsNumbers VALUES(i) >ENDFOR > >SELECT cTableNumber, cTableNumber + "." + TRANSFORM(sn) AS cChairNumber ; >FROM curTable ; > JOIN crsNumbers ON curTable.iChair >= crsNumbers.sn >>