Add(MainForm,2953706,266,98)
{
 Point(onClose)
 link(onCreate,15491498:doOpen,[])
 link(onClose,15491498:doClose,[])
}
Add(SQLite_DB,15491498,350,112)
{
 FileName=":memory:"
 link(onOpen,6853999:doEvent1,[])
}
Add(SQLite_Exec,6838179,511,112)
{
 SQL="CREATE TABLE champ(\r\nid INTEGER PRIMARY KEY,\r\nYears INTEGER);\r\n\r\nINSERT INTO champ (Years) values(2012);\r\nINSERT INTO champ (Years) values(2013); \r\nINSERT INTO champ (Years) values(2014);\r\nINSERT INTO champ (Years) values(2014);\r\nINSERT INTO champ (Years) values(2014);\r\nINSERT INTO champ (Years) values(2015);\r\nINSERT INTO champ (Years) values(2016);\r\nINSERT INTO champ (Years) values(2014);\r\n"
 AddHint(191,-93,143,273,SQL)
}
Add(Hub,6853999,413,112)
{
 link(onEvent1,6838179:doExec,[])
 link(onEvent2,7353169:doEvent1,[(440,125)(440,179)(240,179)(240,237)])
}
Add(FormatStr,4478258,301,231)
{
 Mask="SELECT DISTINCT\r\n"База данных за "||Years||" год."\r\nFROM champ ORDER BY Years;"
 link(onFString,3695854:doQuery,[])
 AddHint(-230,15,161,39,Mask)
}
Add(SQLite_Query,3695854,350,231)
{
 link(onQuery,10109559:doAdd,[])
 link(dbHandle,8569801:Var2,[])
}
Add(FormatStr,6737863,301,280)
{
 Mask="SELECT count(DISTINCT Years)\r\nFROM champ;"
 link(onFString,1106559:doQuery,[])
 AddHint(-230,29,172,26,Mask)
}
Add(SQLite_Query,1106559,385,280)
{
 link(onQuery,11747704:doOperation,[])
 link(dbHandle,8569801:Var3,[(391,201)])
}
Add(UpDown,7958000,497,273)
{
 Left=5
 Top=37
 Width=310
 Color=-16777214
 Kind=0
 Point(doMax)
 link(onPosition,10109559:doSelect,[])
}
Add(ComboBox,10109559,553,231)
{
 Left=5
 Top=7
 Width=310
 Height=21
 Font=[Verdana,14,0,0,204]
 Text=""
 ReadOnly=0
 ItemHeight=25
 Point(doSelect)
 Point(onSelect)
 link(onClick,8163130:doEvent1,[])
 link(onSelect,8163130:doEvent2,[])
}
Add(Math,11747704,441,280)
{
 OpType=1
 Op2=1
 link(onResult,7958000:doMax,[])
}
Add(Hub,7353169,252,231)
{
 link(onEvent1,4478258:doString,[])
 link(onEvent2,6737863:doString,[(284,244)(284,286)])
}
Add(GetDataEx,8569801,350,196)
{
 link(Data,15491498:dbHandle,[])
}
Add(Label,1103554,560,329)
{
 Left=25
 Top=95
 link(Text,10109559:String,[])
}
Add(Hub,8163130,602,238)
{
 InCount=2
 OutCount=1
 link(onEvent1,1103554:doText,[(641,244)(641,300)(548,300)(548,335)])
}

#pas
Add(FormatStr,6737863,490,413)
{
 Mask="SELECT count(DISTINCT Years)\r\nFROM champ;"
 link(onFString,1106559:doQuery,[])
 AddHint(-230,29,172,26,Mask)
}
Add(SQLite_Query,1106559,532,413)
{
 link(onQuery,11747704:doOperation,[])
}
Add(Math,11747704,574,413)
{
 OpType=1
 Op2=1
}

#pas
Add(SQLite_Query,1106559,525,413)
{
 SQL="SELECT (count(DISTINCT Years)-1) FROM champ;"
}