Add(DS_SQLite,5980612,1218,595) { Name="working" link(onOpen,4346609:doQuery,[]) link(FileName,9965442:Var2,[]) } Add(LineBreak,15950049,84,196) { Type=1 Primary=[6335097,1134,329] } Add(DS_SQLite,7350899,1218,679) { Name="archive" link(onOpen,7511876:doQuery,[]) link(FileName,1563383:Var,[]) } Add(DSC_Query,12791067,1820,644) { SQL="SELECT F, C FROM table1" DSManager="export" link(onQuery,1283899:doStr,[(1941,650)(1941,608)]) } Add(FileTools,6184941,1470,602) { link(onEnd,3669303:doEvent1,[]) link(FileName,16421952:FString,[(1476,548)(1406,548)]) link(NewFileName,5307685:Var2,[]) } Add(DS_SQLite,1385547,1610,658) { Name="export" link(FileName,6566066:Var2,[]) } Add(GetDataEx,5307685,1477,567) { link(Data,13894209:FString,[(1483,548)(1532,548)]) } Add(FormatStr,16297205,1631,609) { DataCount=4 Mask="attach database "%1" as export;\r\nINSERT INTO table1 %2;\r\nINSERT INTO User SELECT * FROM export.User;\r\nCREATE TABLE number (num int, work char, archive char);\r\nINSERT INTO number VALUES (1, '%3', '%4');\r\nDETACH DATABASE export;" link(onFString,4765571:doExec,[]) link(Str1,9965442:Var3,[(1637,558)]) link(Str2,13034599:Value,[]) link(Str3,5554987:Var,[(1651,583)(1700,583)]) link(Str4,2658117:Var,[(1658,593)(1714,593)]) } Add(GetDataEx,9965442,1218,553) { link(Data,6335097:Var,[]) } Add(GetDataEx,6566066,1610,567) { Angle=3 link(Data,5307685:Var3,[]) } Add(LineBreak,2377153,1526,665) { link(Out,1385547:doClose,[]) Primary=[12991325,952,-210] } Add(GetDataEx,11114007,1492,519) { Angle=3 link(Data,8454155:Part,[(1455,524)]) } Add(DSC_Query,4346609,1267,595) { SQL="Select MAX(C) From table1" DSManager="working" link(onQuery,16333012:doValue,[]) } Add(DSC_Query,7511876,1267,679) { SQL="Select MAX(C) From table1" DSManager="archive" link(onQuery,2341802:doValue,[]) } Add(Memory,16333012,1316,595) { link(onData,7350899:doOpen,[(1362,601)(1362,640)(1206,640)(1206,685)]) } Add(LineBreak,11578850,1316,651) { Caption="кол записей" Type=1 link(Data,16333012:Value,[]) Primary=[5554987,378,-126] } Add(Memory,2341802,1316,679) { link(onData,16421952:doString,[(1374,685)(1374,482)]) } Add(LineBreak,1419937,1316,735) { Caption="кол записей в архиве" Type=1 link(Data,2341802:Value,[]) Primary=[2658117,392,-189] } Add(DSC_Exec,4765571,1680,609) { DSManager="export" link(onExec,9917359:doEvent1,[]) } Add(LineBreak,1710721,441,210) { Type=1 Primary=[1563383,777,441] } Add(MT_String,1283899,1960,602) { Delimeter="; " link(onResult,324804:doSplit,[]) } Add(StrPart,324804,2016,602) { Char=";" Point(Left) Point(Right) link(onSplit,1667564:doStrCat,[(2059,608)(2059,643)(2004,643)(2004,664)]) } Add(StrCat,1667564,2016,658) { link(onStrCat,10866889:doString,[]) link(Str1,324804:Left,[]) link(Str2,324804:Right,[]) } Add(DSC_Query,16042555,2163,658) { DSManager="working" link(onQuery,11119259:doData,[]) } Add(FormatStr,10866889,2072,658) { Mask="SELECT B FROM %1 WHERE B=1" link(onFString,5701976:doEvent1,[]) link(Str1,16365977:Var1,[(2078,650)(2064,650)]) } Add(DSC_Exec,13690203,2443,721) { DSManager="export" link(onExec,14519742:doWork1,[(2505,727)]) link(onError,14519742:doWork2,[]) link(SQL,13975434:Text,[]) } Add(DSC_Query,395695,1820,609) { SQL="Select COUNT(C>0) From table1" DSManager="export" link(onQuery,5094291:doOperation,[]) } Add(Hub,9917359,1785,609) { link(onEvent1,395695:doQuery,[]) link(onEvent2,12791067:doQuery,[(1809,622)(1809,650)]) } Add(Math,5094291,1876,609) { OpType=1 Op2=1 link(onResult,2617716:doMax,[(1925,615)(1925,720)]) } Add(Hub,3669303,1512,602) { link(onEvent1,1385547:doOpen,[(1560,608)(1560,664)]) link(onEvent2,16297205:doString,[]) } Add(Message,58000,2527,728) { } Add(StrList,4821496,2310,588) { } Add(CounterEx,2617716,2275,707) { Point(doMax) Point(onThroughMax) link(onThroughMax,2285179:doEnum,[]) } Add(ArrayEnum,2285179,2324,714) { link(onItem,5554688:doString,[]) link(onEndEnum,13690203:doExec,[]) link(Array,4821496:Array,[]) } Add(DoData,11119259,2219,658) { link(onEventData,4821496:doAdd,[(2282,664)(2282,594)]) link(Data,16365977:Var3,[(2225,646)(2208,646)(2208,706)]) } Add(GetDataEx,16365977,2058,701) { Angle=3 link(Data,1667564:Result,[(2022,706)]) } Add(Hub,5701976,2114,658) { link(onEvent1,16042555:doQuery,[]) link(onEvent2,2617716:doNext,[(2142,671)(2142,713)]) } Add(FormatStr,5554688,2380,714) { DataCount=1 Mask="CREATE TABLE %1 (A int, B int, C int, D char, E char, F char, G char, H char, I char, J char, K char, L char, M char, N char, O char, P char, Q char, R char, S char, T char, U char, V char, W char, X char, Y char, Z char);" link(onFString,13975434:doAdd,[(2428,720)(2428,657)]) link(Str1,2285179:Item,[(2386,702)(2368,702)(2368,760)(2330,760)]) } Add(HubEx,14519742,2501,728) { Angle=1 link(onEvent,58000:doMessage,[(2505,734)]) } Add(StrList,13975434,2443,651) { } Add(FormatStr,16421952,1400,476) { Mask="%1clear DB\clear.db" Point(FString) link(onFString,8454155:doPart,[]) } Add(FilePartElm,8454155,1449,476) { Mode=2 Point(Part) link(onPart,13894209:doString,[]) link(FileName,5886260:Var,[]) } Add(Dir,8685002,1400,420) { } Add(LineBreak,9077005,1176,455) { Type=1 Primary=[5886260,273,-14] } Add(FormatStr,13894209,1526,476) { Mask="%1%2.db" Point(FString) link(onFString,2707037:doReplace,[]) link(Str2,11114007:Var1,[(1539,456)(1498,456)]) } Add(Replace,2707037,1589,476) { SubStr="table1" DestStr="export.table1" link(onReplace,13034599:doValue,[]) link(Str,10636982:Var,[]) } Add(LineBreak,15202877,980,616) { Caption="запрос" Type=1 Primary=[10636982,609,-182] } Add(Memory,13034599,1638,476) { link(onData,6184941:doCopy,[(1681,482)(1681,563)(1453,563)(1453,615)]) }