Вверх ↑
Ответов: 16884
Рейтинг: 1239
#1: 2016-10-23 16:34:13 ЛС | профиль | цитата
Цикл (for) в SQLite


Add(MainForm,2953706,84,112)
{
Point(onClose)
link(onCreate,11933428:doOpen,[])
link(onClose,11933428:doClose,[])
}
Add(ComboBox,4205602,266,126)
{
Left=110
Top=14
Height=21
Font=[MS Sans Serif,8,1,0,1]
ReadOnly=0
DropDownCount=33
Point(EditText)
Point(doSelect)
Point(onSelect)
Point(onSetFocus)
}
Add(SQLite_DB,11933428,140,126)
{
FileName=":memory:"
link(onOpen,15352880:doEvent1,[])
}
Add(SQLite_Query,836308,217,126)
{
SQL="WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM cnt WHERE x<100)\r\nSELECT A - x FROM cnt,(SELECT strftime('%Y','now') AS A);\r\n"
link(onQuery,4205602:doAdd,[])
}
Add(Hub,15352880,189,126)
{
link(onEvent1,836308:doQuery,[])
link(onEvent2,6551292:doData,[(209,139)(209,174)])
}
Add(DoData,6551292,217,168)
{
Data=Integer(0)
link(onEventData,4205602:doSelect,[])
}

карма: 25
Немного терпения! Дежурный экстрасенс скоро свяжется с Вами!
0