Add(MainForm,2953706,91,147)
{
 Width=408
 Height=330
 Position=1
 Point(onClose)
 link(onCreate,8746341:doOpen,[])
 link(onClose,8746341:doClose,[])
}
Add(DS_SQLite,8746341,140,161)
{
 Name="mdb"
 FileName=":memory:"
 link(onOpen,13177177:doExec,[])
}
Add(DSC_Exec,13177177,196,161)
{
 DSManager="mdb"
 link(onError,9314076:doText,[])
 link(SQL,12874717:Text,[])
}
Add(Memo,12874717,196,105)
{
 Left=10
 Top=10
 Width=240
 Height=210
 Strings=#23:CREATE TABLE transport(|23:id INTEGER PRIMARY KEY,|11: number id,|13: series text,|12: model text,|11: type text,|15: provider text,|15: idnumber text,|14: factory text,|18: yeardate integer,|14: chassis text,|11: body text,|13: engine text,|13: regNom text,|29: PRIMARY KEY (id_transport));|
}
Add(Edit,9314076,245,168)
{
 Left=10
 Top=240
 Width=370
 Height=25
 Color=-16777201
 Font=[MS Sans Serif,10,1,255,1]
 Ctl3D=1
 Text=""
}

CREATE TABLE transport(
id INTEGER PRIMARY KEY,
 number text,
 series text,
 model text,
 type text,
 provider text,
 idnumber text,
 factory text,
 yeardate integer,
 chassis text,
 body text,
 engine text,
 regNom text);

CREATE TABLE personal (   
 
  id INTEGER PRIMARY KEY,
  number int,
  rank text,
  name text,
  serial text,
  date integer
);

CREATE TABLE IF NOT EXISTS transport(
 id INTEGER PRIMARY KEY,
 series TEXT,
 marka INTEGER, --id из списка марок 
 model INTEGER, --id из списка моделей
 type INTEGER, --id из списка типов 
 provider INTEGER, --id из списка поставщиков
 factory INTEGER, --id из списка производителей
 dyear INTEGER,
 chassis text,
 body text,
 engine text,
 regNom text,
 prob INTEGER,
 driver INTEGER, --id из таблицы personal 
 status INTEGER -- 0-рабочая, 1-в ремонте, 2-списана 
 );


CREATE TABLE IF NOT EXISTS personal (   
 id INTEGER PRIMARY KEY,
 rank text,
 name text,
 serial text,
 date integer,
 status integer -- 0-служит, 1-уволен 
);

CREATE TABLE IF NOT EXISTS transport(
 id INTEGER PRIMARY KEY,
 series TEXT,
 marka INTEGER, --id из списка марок 
 model INTEGER, --id из списка моделей
 type INTEGER, --id из списка типов 
 provider INTEGER, --id из списка поставщиков
 codvk text, --там и цифры и буквы
 factory INTEGER, --id из списка производителей
 dyear INTEGER,
 chassis text,
 body text,
 engine text,
 regNom text,
 prob INTEGER,
 driver INTEGER, --id из таблицы personal 
 status INTEGER -- 0-рабочая, 1-в ремонте, 2-списана 
 );


CREATE TABLE IF NOT EXISTS personal (   
 id INTEGER PRIMARY KEY,
 rank text,
 name text,
 serial text,
 date integer,
 status integer -- 0-служит, 1-уволен 
);

CREATE TABLE IF NOT EXISTS tov ( 
  id INTEGER PRIMARY KEY,
  date integer,
  nameTO text,
  odometr integer,
  conclusion text
);

CREATE TABLE IF NOT EXISTS tires ( 
id INTEGER PRIMARY KEY,
 factorynumber integer,
 size integer,
 factory text, --производителей очень много и я не всех смогу прописать так как не всех знаю
 date integer,
 instillation integer,
 deletet integer,
 cause text
);

CREATE TABLE IF NOT EXISTS acb ( 
id INTEGER PRIMARY KEY,
number integer,
marka integer, -- марка
factory integer, --завод 
date integer,
work integer,
instillation integer,
datektc integer,
cause text
);

CREATE TABLE IF NOT EXISTS butter ( 
id INTEGER PRIMARY KEY,
datebutter integer,
type integer, -- тип масла
causebatter text,
datefilter integer,
causefilter text
);

CREATE TABLE IF NOT EXISTS cool ( 
id INTEGER PRIMARY KEY,
date integer,
type ineteger, --тип охлаждающей жидкости
cause text
);

CREATE TABLE IF NOT EXISTS brake ( 
id INTEGER PRIMARY KEY,
date integer,
type ineteger, --тип тормозной жидкости
cause text
);

CREATE TABLE IF NOT EXISTS zip ( 
id INTEGER PRIMARY KEY,
name text,
quantity integer,
availability text
);


CREATE TABLE IF NOT EXISTS resource ( 
id INTEGER PRIMARY KEY,
year integer,
jan integer,
feb integer,
march integer,
april integer,
may integer,
june integer,
jule integer,
august integer,
sept integer,
october integer,
november integer,
december integer,
yearnew integer,
start integer,
lastkr integer
);

Add(ChildGroupBox,11784741,849,445)
{
 link(onEvent1,5968126:doEvent10,[(944,451)(944,314)])
}
BEGIN_SDK
  Add(EditMulti,13082838,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=832
   Height=536
   link(doWork1,12209291:doBringToFront,[(28,27)(30,34)(28,111)])
   link(doWork2,13423097:doEvent1,[(119,34)(119,83)])
   link(doWork3,7743094:doText,[(73,41)(73,115)])
  }
  Add(GroupBox,12209291,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Моторесурс"
   Point(doBringToFront)
  }
  Add(StringTableMT,7735608,504,130)
  {
   Left=10
   Top=55
   Width=760
   Height=320
   Columns=#6:Рік=50|10:Січень=100|9:Лютий=100|12:Березень=100|11:Квітень=100|11:Травень=100|11:Червень=100|10:Липень=100|11:Серпень=100|12:Вересень=100|11:Жовтень=100|12:Листопад=100|11:Грудень=100|10:Річний=150|26:З початку експлуатації=250|23:Після останнього КР=250|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,1283587:doRead,[])
  }
  Add(Button,2317060,336,130)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,5922852:doOperation,[])
  }
  Add(Math,5922852,385,130)
  {
   Op2=1
   ResultType=0
   link(onResult,14753751:doEvent1,[])
   link(Op1,7735608:Count,[(391,111)(451,111)(451,194)(510,194)])
  }
  Add(Edit,7743094,126,109)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,13082838:onEvent1,[(506,122)(506,27)])
  }
  Add(Label,14235026,182,109)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,10583734,133,165)
  {
   Name="db"
   link(onOpen,1870618:doEvent1,[])
   link(FileName,7743094:Text,[(139,153)(132,153)])
  }
  Add(DSC_Exec,2633806,196,214)
  {
   SQL="CREATE TABLE IF NOT EXISTS resource ( \r\nid INTEGER PRIMARY KEY,\r\nyear integer,\r\njan integer,\r\nfeb integer,\r\nmarch integer,\r\napril integer,\r\nmay integer,\r\njune integer,\r\njule integer,\r\naugust integer,\r\nsept integer,\r\noctober integer,\r\nnovember integer,\r\ndecember integer,\r\nyearnew integer,\r\nstart integer,\r\nlastkr integer\r\n);\r\n"
   DSManager="db"
  }
  Add(DSC_Exec,16616374,553,74)
  {
   DSManager="db"
  }
  Add(ArrayRW,1283587,636,137)
  {
   link(onRead,8118530:doSplit,[])
   link(Array,16774790:Var3,[(642,121)(586,121)(586,195)])
  }
  Add(Hub,14753751,441,130)
  {
   link(onEvent1,7735608:doAdd,[])
   link(onEvent2,14995619:doString,[(479,143)(479,80)])
  }
  Add(FormatStr,14995619,504,74)
  {
   DataCount=1
   Mask="INSERT INTO resource (id) VALUES (%1)"
   link(onFString,16616374:doExec,[])
  }
  Add(DSC_Query,15192787,301,179)
  {
   SQL="SELECT * FROM resource"
   DSManager="db"
   link(onQuery,7735608:doMT_Add,[(419,185)(419,171)])
  }
  Add(DSC_Exec,10253509,749,270)
  {
   DSManager="db"
  }
  Add(FormatStr,6136212,679,207)
  {
   DataCount=17
   Mask="UPDATE resource SET\r\n year='%2',\r\n jan='%3',\r\n feb='%4',\r\n march='%5',\r\n april='%6',\r\n may='%7',\r\n june='%8',\r\n jule='%9',\r\n august='%10',\r\n sept='%11',\r\n october='%12',\r\n november='%13',\r\n december='%14',\r\n yearnew='%15',\r\n start='%16',\r\n lastkr='%17'\r\nWHERE id=%1"
   link(onFString,10253509:doExec,[(764,213)(764,245)(737,245)(737,276)])
   link(Str1,8118530:Part1,[])
   link(Str2,8118530:Part2,[])
   link(Str3,8118530:Part3,[])
   link(Str4,8118530:Part4,[])
   link(Str5,8118530:Part5,[])
   link(Str6,8118530:Part6,[])
   link(Str7,8118530:Part7,[])
   link(Str8,8118530:Part8,[])
   link(Str9,8118530:Part9,[])
   link(Str10,8118530:Part10,[])
   link(Str11,8118530:Part11,[])
   link(Str12,8118530:Part12,[])
   link(Str13,8118530:Part13,[])
   link(Str14,8118530:Part14,[])
   link(Str15,8118530:Part15,[])
   link(Str16,8118530:Part16,[])
   link(Str17,8118530:Part17,[])
  }
  Add(MultiStrPart,8118530,679,137)
  {
   Char="\9"
   Count=17
   link(onSplit,6136212:doString,[(723,143)(723,178)(667,178)(667,213)])
  }
  Add(Hub,1870618,182,165)
  {
   link(onEvent1,15192787:doQuery,[(248,171)(248,185)])
   link(onEvent2,2633806:doExec,[])
  }
  Add(Button,3984982,322,298)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,1303128:doEvent1,[])
  }
  Add(Hub,1303128,378,298)
  {
   link(onEvent1,8562638:doRead,[])
   link(onEvent2,15559044:doData,[])
  }
  Add(DoData,15559044,420,305)
  {
   link(onEventData,7735608:doDelete,[(478,311)(478,150)])
   link(Data,11617938:Var1,[(426,244)])
  }
  Add(DSC_Exec,11160853,686,298)
  {
   DSManager="db"
  }
  Add(FormatStr,4574577,637,298)
  {
   DataCount=1
   Mask="DELETE FROM resource WHERE id=%1"
   link(onFString,11160853:doExec,[])
   link(Str1,5605138:Part1,[(643,286)(619,286)(619,342)(594,342)])
  }
  Add(ArrayRW,8562638,539,298)
  {
   link(onRead,5605138:doSplit,[])
   link(Array,16774790:Var2,[])
   link(Index,11617938:Var2,[(552,273)(496,273)])
  }
  Add(GetDataEx,16774790,539,190)
  {
   Angle=3
   link(Data,7735608:Strings,[(524,195)])
  }
  Add(GetDataEx,11617938,490,239)
  {
   Angle=1
   link(Data,7735608:Index,[(531,244)])
  }
  Add(MultiStrPart,5605138,588,298)
  {
   Char="\9"
   Count=1
   link(onSplit,4574577:doString,[])
  }
  Add(Hub,13423097,217,77)
  {
   link(onEvent1,7735608:doClear,[(367,83)(367,143)])
   link(onEvent2,10583734:doOpen,[(243,90)(243,130)(121,130)(121,171)])
  }
END_SDK
Add(ChildGroupBox,16594303,847,74)
{
 link(onEvent1,5968126:doEvent2,[(943,80)(943,258)])
}
BEGIN_SDK
  Add(EditMulti,9384139,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=881
   Height=585
   link(doWork1,10546403:doBringToFront,[(28,27)(28,111)])
   link(doWork2,12584059:doEvent1,[(161,34)(161,62)])
   link(doWork3,6924426:doText,[(61,41)(61,136)])
  }
  Add(GroupBox,10546403,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Персонал"
   Point(doBringToFront)
   Point(doSendToBack)
  }
  Add(MultiStrPart,16530701,555,319)
  {
   Char="\9"
   Count=1
   link(onSplit,13977232:doString,[])
  }
  Add(StringTableMT,6451170,471,151)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|20:Військове звання=150|7:ПІБ=200|27:Серія,номер посвідчення=150|20:Дата та № наказу=150|10:Статус=150|0:|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,9248840:doRead,[])
  }
  Add(Button,16355538,303,151)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,11826088:doOperation,[])
  }
  Add(Math,11826088,352,151)
  {
   Op2=1
   ResultType=0
   link(onResult,11892657:doEvent1,[])
   link(Op1,6451170:Count,[(358,132)(418,132)(418,215)(477,215)])
  }
  Add(Edit,6924426,100,130)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,9384139:onEvent1,[(513,143)(513,27)])
  }
  Add(Label,5399162,142,102)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,6261690,100,186)
  {
   Name="db"
   link(onOpen,5124064:doEvent1,[])
   link(FileName,6924426:Text,[])
  }
  Add(DSC_Exec,11620320,163,235)
  {
   SQL="CREATE TABLE IF NOT EXISTS personal (   \r\n id INTEGER PRIMARY KEY,\r\n rank text,\r\n name text,\r\n serial text,\r\n date integer,\r\n status integer -- 0-служит, 1-уволен \r\n);"
   DSManager="db"
  }
  Add(DSC_Exec,8618512,520,95)
  {
   DSManager="db"
  }
  Add(ArrayRW,9248840,603,158)
  {
   link(onRead,4885776:doSplit,[])
   link(Array,12011409:Var3,[(609,142)(553,142)(553,216)])
  }
  Add(Hub,11892657,408,151)
  {
   link(onEvent1,6451170:doAdd,[])
   link(onEvent2,2342500:doString,[(446,164)(446,101)])
  }
  Add(FormatStr,2342500,471,95)
  {
   DataCount=1
   Mask="INSERT INTO personal (id) VALUES (%1)"
   link(onFString,8618512:doExec,[])
  }
  Add(DSC_Query,12224532,268,200)
  {
   SQL="SELECT * FROM personal"
   DSManager="db"
   link(onQuery,6451170:doMT_Add,[(386,206)(386,192)])
  }
  Add(DSC_Exec,3428744,695,228)
  {
   DSManager="db"
  }
  Add(FormatStr,4361700,646,228)
  {
   DataCount=5
   Mask="UPDATE personal SET  rank= '%2', name ='%3', serial = '%4', date ='%5', status= '%6' WHERE id=%1"
   link(onFString,3428744:doExec,[])
   link(Str1,4885776:Part1,[])
   link(Str2,4885776:Part2,[])
   link(Str3,4885776:Part3,[])
   link(Str4,4885776:Part4,[])
   link(Str5,4885776:Part5,[])
  }
  Add(MultiStrPart,4885776,646,158)
  {
   Char="\9"
   Count=5
   link(onSplit,4361700:doString,[(690,164)(690,199)(634,199)(634,234)])
  }
  Add(Hub,5124064,149,186)
  {
   link(onEvent1,12224532:doQuery,[(215,192)(215,206)])
   link(onEvent2,11620320:doExec,[])
  }
  Add(Button,6320311,289,319)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,8987325:doEvent1,[])
  }
  Add(Hub,8987325,345,319)
  {
   link(onEvent1,12390890:doRead,[])
   link(onEvent2,10031616:doData,[])
  }
  Add(DoData,10031616,387,326)
  {
   link(onEventData,6451170:doDelete,[(445,332)(445,171)])
   link(Data,6296645:Var1,[(393,265)])
  }
  Add(DSC_Exec,12949506,653,319)
  {
   DSManager="db"
  }
  Add(FormatStr,13977232,604,319)
  {
   DataCount=1
   Mask="DELETE FROM personal WHERE id=%1"
   link(onFString,12949506:doExec,[])
   link(Str1,16530701:Part1,[(610,307)(586,307)(586,363)(561,363)])
  }
  Add(ArrayRW,12390890,506,319)
  {
   link(onRead,16530701:doSplit,[])
   link(Array,12011409:Var2,[])
   link(Index,6296645:Var2,[(519,294)(463,294)])
  }
  Add(GetDataEx,12011409,506,211)
  {
   Angle=3
   link(Data,6451170:Strings,[(491,216)])
  }
  Add(GetDataEx,6296645,457,260)
  {
   Angle=1
   link(Data,6451170:Index,[(498,265)])
  }
  Add(Hub,12584059,301,56)
  {
   link(onEvent1,6451170:doClear,[(393,62)(393,164)])
   link(onEvent2,6261690:doOpen,[(327,69)(327,131)(88,131)(88,192)])
  }
END_SDK
Add(TabControl,8774474,175,203)
{
 Left=215
 Top=6
 Width=735
 Height=440
 Tabs=#10:Інформація|8:Персонал|2:ТО|4:Шини|3:АКБ|5:Масло|18:Охолоджуюча рідина|15:Тормозна рідина|3:ЗІП|10:Моторесурс|
 Bitmaps=[]
 Buttons=0
 HotTrack=0
 Point(PageTab)
 link(onChange,4412880:doEvent,[(231,220)(340,220)(556,220)(556,258)])
}
Add(ChildGroupBox,13958430,845,158)
{
 link(onEvent1,5968126:doEvent4,[(943,164)(943,272)])
}
BEGIN_SDK
  Add(EditMulti,11052900,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=769
   Height=571
   link(doWork1,7766036:doBringToFront,[(28,27)(28,111)])
   link(doWork2,15083432:doEvent1,[(133,34)(133,76)])
   link(doWork3,2042301:doText,[(64,41)(64,136)])
  }
  Add(GroupBox,7766036,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Шини"
   Point(doBringToFront)
  }
  Add(MultiStrPart,164653,562,319)
  {
   Char="\9"
   Count=1
   link(onSplit,16206179:doString,[])
  }
  Add(StringTableMT,12222526,485,151)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|20:Заводсткий номер=150|10:Розмір=100|18:Завод-виробник=150|21:Дата виготовлення=150|31:Дата встановлення та пробіг=250|25:Дата зняття та пробіг=250|18:Причина зняття=200|0:|0:|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,2912116:doRead,[])
  }
  Add(Button,1627946,317,151)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,11123210:doOperation,[])
  }
  Add(Math,11123210,366,151)
  {
   Op2=1
   ResultType=0
   link(onResult,1709848:doEvent1,[])
   link(Op1,12222526:Count,[(372,132)(432,132)(432,215)(491,215)])
  }
  Add(Edit,2042301,107,130)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,11052900:onEvent1,[(465,143)(465,27)])
  }
  Add(Label,14593757,156,130)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,11438517,114,186)
  {
   Name="db"
   link(onOpen,69171:doEvent1,[])
   link(FileName,2042301:Text,[(120,174)(113,174)])
  }
  Add(DSC_Exec,5760494,177,235)
  {
   SQL="CREATE TABLE IF NOT EXISTS tires ( \r\nid INTEGER PRIMARY KEY,\r\n factorynumber integer,\r\n size integer,\r\n factory text,\r\n date integer,\r\n instillation integer,\r\n deletet integer,\r\n cause text\r\n);"
   DSManager="db"
  }
  Add(DSC_Exec,2306334,534,95)
  {
   DSManager="db"
  }
  Add(ArrayRW,2912116,617,158)
  {
   link(onRead,4873003:doSplit,[])
   link(Array,8100482:Var3,[(623,142)(567,142)(567,216)])
  }
  Add(Hub,1709848,422,151)
  {
   link(onEvent1,12222526:doAdd,[])
   link(onEvent2,13982991:doString,[(460,164)(460,101)])
  }
  Add(FormatStr,13982991,485,95)
  {
   DataCount=1
   Mask="INSERT INTO tires (id) VALUES (%1)"
   link(onFString,2306334:doExec,[])
  }
  Add(DSC_Query,15845815,282,200)
  {
   SQL="SELECT * FROM tires"
   DSManager="db"
   link(onQuery,12222526:doMT_Add,[(400,206)(400,192)])
  }
  Add(DSC_Exec,623392,744,228)
  {
   DSManager="db"
  }
  Add(FormatStr,13284577,660,228)
  {
   DataCount=8
   Mask="UPDATE tires SET\r\n factorynumber= '%2',\r\n size= '%3' ,\r\n factory= '%4'\r\n date= '%5',\r\n instillation= '%6',\r\n deletet= '%7',\r\n cause = '%8' \r\nWHERE id=%1"
   link(onFString,623392:doExec,[])
   link(Str1,4873003:Part1,[])
   link(Str2,4873003:Part2,[])
   link(Str3,4873003:Part3,[])
   link(Str4,4873003:Part4,[])
   link(Str5,4873003:Part5,[])
   link(Str6,4873003:Part6,[])
   link(Str7,4873003:Part7,[])
   link(Str8,4873003:Part8,[])
  }
  Add(MultiStrPart,4873003,660,158)
  {
   Char="\9"
   Count=8
   link(onSplit,13284577:doString,[(731,164)(731,199)(648,199)(648,234)])
  }
  Add(Hub,69171,163,186)
  {
   link(onEvent1,15845815:doQuery,[(229,192)(229,206)])
   link(onEvent2,5760494:doExec,[])
  }
  Add(Button,15015739,303,319)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,5234139:doEvent1,[])
  }
  Add(Hub,5234139,359,319)
  {
   link(onEvent1,8789522:doRead,[])
   link(onEvent2,3503678:doData,[])
  }
  Add(DoData,3503678,401,326)
  {
   link(onEventData,12222526:doDelete,[(459,332)(459,171)])
   link(Data,1425860:Var1,[(407,265)])
  }
  Add(DSC_Exec,16768126,667,319)
  {
   DSManager="db"
  }
  Add(FormatStr,16206179,618,319)
  {
   DataCount=1
   Mask="DELETE FROM tires WHERE id=%1"
   link(onFString,16768126:doExec,[])
   link(Str1,164653:Part1,[(624,307)(600,307)(600,363)(568,363)])
  }
  Add(ArrayRW,8789522,520,319)
  {
   link(onRead,164653:doSplit,[])
   link(Array,8100482:Var2,[])
   link(Index,1425860:Var2,[(533,294)(477,294)])
  }
  Add(GetDataEx,8100482,520,211)
  {
   Angle=3
   link(Data,12222526:Strings,[(505,216)])
  }
  Add(GetDataEx,1425860,471,260)
  {
   Angle=1
   link(Data,12222526:Index,[(512,265)])
  }
  Add(Hub,15083432,245,70)
  {
   link(onEvent1,12222526:doClear,[(372,76)(372,164)])
   link(onEvent2,11438517:doOpen,[(271,83)(271,144)(85,144)(85,192)])
  }
END_SDK
Add(ChildGroupBox,12437118,846,207)
{
 link(onEvent1,5968126:doEvent5,[(943,213)(943,279)])
}
BEGIN_SDK
  Add(EditMulti,2678438,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=797
   Height=599
   link(doWork1,11109616:doBringToFront,[(28,27)(28,111)])
   link(doWork2,2186146:doEvent1,[(126,34)(126,83)])
   link(doWork3,12530325:doText,[(57,41)(57,136)])
  }
  Add(GroupBox,11109616,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="АКБ"
   Point(doBringToFront)
  }
  Add(MultiStrPart,16078728,555,319)
  {
   Char="\9"
   Count=1
   link(onSplit,7767836:doString,[])
  }
  Add(StringTableMT,1489459,471,151)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|13:№ батареї=100|17:Марка батареї=150|18:Завод-виробник=150|21:Дата виготовлення=150|29:Приведення у робочий стан=200|16:Встановлення=150|12:Дата КТЦ=150|26:Дата та причина зняття=250|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,5757406:doRead,[])
  }
  Add(Math,2138464,352,151)
  {
   Op2=1
   ResultType=0
   link(onResult,3796150:doEvent1,[])
   link(Op1,1489459:Count,[(358,132)(418,132)(418,215)(477,215)])
  }
  Add(Edit,12530325,93,130)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,2678438:onEvent1,[(471,143)(471,27)])
  }
  Add(Label,598003,142,130)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,1541997,100,186)
  {
   Name="db"
   link(onOpen,4580828:doEvent1,[])
   link(FileName,12530325:Text,[(106,174)(99,174)])
  }
  Add(DSC_Exec,15987716,177,235)
  {
   SQL="CREATE TABLE IF NOT EXISTS acb ( \r\nid INTEGER PRIMARY KEY,\r\nnumber integer,\r\nmarka integer, -- марка\r\nfactory integer, --завод \r\ndate integer,\r\nwork integer,\r\ninstillation integer,\r\ndatektc integer,\r\ncause text\r\n);\r\n"
   DSManager="db"
  }
  Add(DSC_Exec,16705274,520,95)
  {
   DSManager="db"
  }
  Add(ArrayRW,5757406,603,158)
  {
   link(onRead,11663236:doSplit,[])
   link(Array,12674698:Var3,[(609,142)(553,142)(553,216)])
  }
  Add(Hub,3796150,408,151)
  {
   link(onEvent1,1489459:doAdd,[])
   link(onEvent2,164066:doString,[(446,164)(446,101)])
  }
  Add(FormatStr,164066,471,95)
  {
   DataCount=1
   Mask="INSERT INTO acb (id) VALUES (%1)"
   link(onFString,16705274:doExec,[])
  }
  Add(DSC_Query,3556222,268,200)
  {
   SQL="SELECT * FROM acb"
   DSManager="db"
   link(onQuery,1489459:doMT_Add,[(386,206)(386,192)])
  }
  Add(DSC_Exec,1996129,772,228)
  {
   DSManager="db"
  }
  Add(FormatStr,12564212,646,228)
  {
   DataCount=9
   Mask="UPDATE acb SET\r\n number='%2',\r\n marka='%3'\r\n factory='%4', \r\n date="%5',\r\n work='%6',\r\n instillation='%7',\r\n datektc='%8',\r\n cause='%9'\r\nWHERE id=%1"
   link(onFString,1996129:doExec,[])
   link(Str1,11663236:Part1,[])
   link(Str2,11663236:Part2,[])
   link(Str3,11663236:Part3,[])
   link(Str4,11663236:Part4,[])
   link(Str5,11663236:Part5,[])
   link(Str6,11663236:Part6,[])
   link(Str7,11663236:Part7,[])
   link(Str8,11663236:Part8,[])
   link(Str9,11663236:Part9,[])
  }
  Add(MultiStrPart,11663236,646,158)
  {
   Char="\9"
   Count=9
   link(onSplit,12564212:doString,[(690,164)(690,199)(634,199)(634,234)])
  }
  Add(Hub,4580828,149,186)
  {
   link(onEvent1,3556222:doQuery,[(215,192)(215,206)])
   link(onEvent2,15987716:doExec,[(170,199)(170,241)])
  }
  Add(Button,16054055,289,319)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,6925697:doEvent1,[])
  }
  Add(Hub,6925697,345,319)
  {
   link(onEvent1,3491835:doRead,[])
   link(onEvent2,7449784:doData,[])
  }
  Add(DoData,7449784,387,326)
  {
   link(onEventData,1489459:doDelete,[(445,332)(445,171)])
   link(Data,12358231:Var1,[(393,265)])
  }
  Add(DSC_Exec,7579152,653,319)
  {
   DSManager="db"
  }
  Add(FormatStr,7767836,604,319)
  {
   DataCount=1
   Mask="DELETE FROM acb WHERE id=%1"
   link(onFString,7579152:doExec,[])
   link(Str1,16078728:Part1,[(610,307)(586,307)(586,363)(561,363)])
  }
  Add(ArrayRW,3491835,506,319)
  {
   link(onRead,16078728:doSplit,[])
   link(Array,12674698:Var2,[])
   link(Index,12358231:Var2,[(519,294)(463,294)])
  }
  Add(GetDataEx,12674698,506,211)
  {
   Angle=3
   link(Data,1489459:Strings,[(491,216)])
  }
  Add(GetDataEx,12358231,457,260)
  {
   Angle=1
   link(Data,1489459:Index,[(498,265)])
  }
  Add(Button,8590332,303,151)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,2138464:doOperation,[])
  }
  Add(Hub,2186146,231,77)
  {
   link(onEvent1,1489459:doClear,[(358,83)(358,164)])
   link(onEvent2,1541997:doOpen,[(257,90)(257,141)(88,141)(88,192)])
  }
END_SDK
Add(ChildGroupBox,12602276,846,256)
{
 link(onEvent1,5968126:doEvent6,[(943,262)(943,286)])
}
BEGIN_SDK
  Add(EditMulti,3944223,0,14)
  {
   EventCount=1
   WorkCount=3
   Width=839
   Height=585
   link(doWork1,3695041:doBringToFront,[(7,20)])
   link(doWork2,15457894:doEvent1,[(164,27)(164,62)])
   link(doWork3,13614708:doText,[(43,34)(43,164)])
  }
  Add(GroupBox,3695041,7,112)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Масло"
   Point(doBringToFront)
  }
  Add(MultiStrPart,13327469,548,347)
  {
   Char="\9"
   Count=1
   link(onSplit,11016733:doString,[])
  }
  Add(StringTableMT,12397356,464,179)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|21:Дата заміни масла=200|13:Тип масла=150|24:Причина заміни масла=250|23:Дата заміни фільтру=200|26:Причина заміни фільтру=250|0:|0:|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,2213808:doRead,[])
  }
  Add(Button,2222468,296,179)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,5021796:doOperation,[])
  }
  Add(Math,5021796,345,179)
  {
   Op2=1
   ResultType=0
   link(onResult,11461881:doEvent1,[])
   link(Op1,12397356:Count,[(351,160)(411,160)(411,243)(470,243)])
  }
  Add(Edit,13614708,86,158)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,3944223:onEvent1,[(478,171)(478,20)])
  }
  Add(Label,7069515,135,158)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,4409359,93,214)
  {
   Name="db"
   link(onOpen,9846779:doEvent1,[])
   link(FileName,13614708:Text,[(99,202)(92,202)])
  }
  Add(DSC_Exec,6978250,156,263)
  {
   SQL="CREATE TABLE IF NOT EXISTS butter ( \r\nid INTEGER PRIMARY KEY,\r\ndatebutter integer,\r\ntype integer, -- тип масла\r\ncausebatter text,\r\ndatefilter integer,\r\ncausefilter text\r\n);\r\n"
   DSManager="db"
  }
  Add(DSC_Exec,1493733,513,123)
  {
   DSManager="db"
  }
  Add(ArrayRW,2213808,596,186)
  {
   link(onRead,2571016:doSplit,[])
   link(Array,4410071:Var3,[(602,170)(546,170)(546,244)])
  }
  Add(Hub,11461881,401,179)
  {
   link(onEvent1,12397356:doAdd,[])
   link(onEvent2,2009613:doString,[(439,192)(439,129)])
  }
  Add(FormatStr,2009613,464,123)
  {
   DataCount=1
   Mask="INSERT INTO butter (id) VALUES (%1)"
   link(onFString,1493733:doExec,[])
  }
  Add(DSC_Query,15798435,261,228)
  {
   SQL="SELECT * FROM butter"
   DSManager="db"
   link(onQuery,12397356:doMT_Add,[(379,234)(379,220)])
  }
  Add(DSC_Exec,11379607,772,256)
  {
   DSManager="db"
  }
  Add(FormatStr,15297647,639,256)
  {
   DataCount=6
   Mask="UPDATE butter SET\r\n datebutter='%2',\r\n type integer='%3',\r\n causebatter='%4',\r\n datefilter='%5',\r\n causefilter='%6' \r\nWHERE id=%1"
   link(onFString,11379607:doExec,[])
   link(Str1,2571016:Part1,[])
   link(Str2,2571016:Part2,[])
   link(Str3,2571016:Part3,[])
   link(Str4,2571016:Part4,[])
   link(Str5,2571016:Part5,[])
   link(Str6,2571016:Part6,[])
  }
  Add(MultiStrPart,2571016,639,186)
  {
   Char="\9"
   Count=6
   link(onSplit,15297647:doString,[(683,192)(683,227)(627,227)(627,262)])
  }
  Add(Hub,9846779,142,214)
  {
   link(onEvent1,15798435:doQuery,[(208,220)(208,234)])
   link(onEvent2,6978250:doExec,[])
  }
  Add(Button,7148669,282,347)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,15398364:doEvent1,[])
  }
  Add(Hub,15398364,338,347)
  {
   link(onEvent1,14184427:doRead,[])
   link(onEvent2,13652696:doData,[])
  }
  Add(DoData,13652696,380,354)
  {
   link(onEventData,12397356:doDelete,[(438,360)(438,199)])
   link(Data,8455910:Var1,[(386,293)])
  }
  Add(DSC_Exec,8749688,646,347)
  {
   DSManager="db"
  }
  Add(FormatStr,11016733,597,347)
  {
   DataCount=1
   Mask="DELETE FROM butter WHERE id=%1"
   link(onFString,8749688:doExec,[])
   link(Str1,13327469:Part1,[(603,335)(579,335)(579,391)(554,391)])
  }
  Add(ArrayRW,14184427,499,347)
  {
   link(onRead,13327469:doSplit,[])
   link(Array,4410071:Var2,[])
   link(Index,8455910:Var2,[(512,322)(456,322)])
  }
  Add(GetDataEx,4410071,499,239)
  {
   Angle=3
   link(Data,12397356:Strings,[(484,244)])
  }
  Add(GetDataEx,8455910,450,288)
  {
   Angle=1
   link(Data,12397356:Index,[(491,293)])
  }
  Add(Hub,15457894,329,56)
  {
   link(onEvent1,12397356:doClear,[(403,62)(403,192)])
   link(onEvent2,4409359:doOpen,[(355,69)(355,145)(81,145)(81,220)])
  }
END_SDK
Add(ChildGroupBox,7725053,846,305)
{
 link(onEvent1,5968126:doEvent7,[(943,311)(943,293)])
}
BEGIN_SDK
  Add(EditMulti,3276299,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=797
   Height=585
   link(doWork1,2250338:doBringToFront,[(28,27)(28,111)])
   link(doWork2,6014386:doEvent1,[(151,34)(151,76)])
   link(doWork3,12758551:doText,[(81,41)(81,178)])
  }
  Add(GroupBox,2250338,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Охолоджуюча рідина"
   Point(doBringToFront)
  }
  Add(MultiStrPart,11193971,604,361)
  {
   Char="\9"
   Count=1
   link(onSplit,7187556:doString,[])
  }
  Add(StringTableMT,7261521,520,193)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|22:Дата заміни рідини=150|14:Тип рідини=200|18:Причина заміни=200|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,9813648:doRead,[])
  }
  Add(Button,5857724,352,193)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,15887589:doOperation,[])
  }
  Add(Math,15887589,401,193)
  {
   Op2=1
   ResultType=0
   link(onResult,3341652:doEvent1,[])
   link(Op1,7261521:Count,[(407,174)(467,174)(467,257)(526,257)])
  }
  Add(Edit,12758551,142,172)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,3276299:onEvent1,[(496,185)(496,27)])
  }
  Add(Label,15381254,191,172)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,3823219,149,228)
  {
   Name="db"
   link(onOpen,6688445:doEvent1,[])
   link(FileName,12758551:Text,[(155,216)(148,216)])
  }
  Add(DSC_Exec,1789287,212,277)
  {
   SQL="CREATE TABLECREATE TABLE IF NOT EXISTS cool ( \r\n id INTEGER PRIMARY KEY,\r\n date integer,\r\n type ineteger, --тип охлаждающей жидкости\r\n cause text\r\n);"
   DSManager="db"
  }
  Add(DSC_Exec,12537168,569,137)
  {
   DSManager="db"
  }
  Add(ArrayRW,9813648,652,200)
  {
   link(onRead,1315024:doSplit,[])
   link(Array,16245542:Var3,[(658,184)(602,184)(602,258)])
  }
  Add(Hub,3341652,457,193)
  {
   link(onEvent1,7261521:doAdd,[])
   link(onEvent2,15364540:doString,[(495,206)(495,143)])
  }
  Add(FormatStr,15364540,520,137)
  {
   DataCount=1
   Mask="INSERT INTO cool (id) VALUES (%1)"
   link(onFString,12537168:doExec,[])
  }
  Add(DSC_Query,9317544,317,242)
  {
   SQL="SELECT * FROM cool"
   DSManager="db"
   link(onQuery,7261521:doMT_Add,[(435,248)(435,234)])
  }
  Add(DSC_Exec,7252923,744,270)
  {
   DSManager="db"
  }
  Add(FormatStr,7483739,695,270)
  {
   DataCount=4
   Mask="UPDATE cool SET\r\n date ='%2',\r\n type ='%3'\r\n cause='%4'\r\nWHERE id=%1"
   link(onFString,7252923:doExec,[])
   link(Str1,1315024:Part1,[])
   link(Str2,1315024:Part2,[])
   link(Str3,1315024:Part3,[])
   link(Str4,1315024:Part4,[])
  }
  Add(MultiStrPart,1315024,695,200)
  {
   Char="\9"
   Count=4
   link(onSplit,7483739:doString,[(739,206)(739,241)(683,241)(683,276)])
  }
  Add(Hub,6688445,198,228)
  {
   link(onEvent1,9317544:doQuery,[(264,234)(264,248)])
   link(onEvent2,1789287:doExec,[])
  }
  Add(Button,12564371,338,361)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,4543428:doEvent1,[])
  }
  Add(Hub,4543428,394,361)
  {
   link(onEvent1,13862924:doRead,[])
   link(onEvent2,1966287:doData,[])
  }
  Add(DoData,1966287,436,368)
  {
   link(onEventData,7261521:doDelete,[(494,374)(494,213)])
   link(Data,12472011:Var1,[(442,307)])
  }
  Add(DSC_Exec,11719274,702,361)
  {
   DSManager="db"
  }
  Add(FormatStr,7187556,653,361)
  {
   DataCount=1
   Mask="DELETE FROM cool WHERE id=%1"
   link(onFString,11719274:doExec,[])
   link(Str1,11193971:Part1,[(659,349)(635,349)(635,405)(610,405)])
  }
  Add(ArrayRW,13862924,555,361)
  {
   link(onRead,11193971:doSplit,[])
   link(Array,16245542:Var2,[])
   link(Index,12472011:Var2,[(568,336)(512,336)])
  }
  Add(GetDataEx,16245542,555,253)
  {
   Angle=3
   link(Data,7261521:Strings,[(540,258)])
  }
  Add(GetDataEx,12472011,506,302)
  {
   Angle=1
   link(Data,7261521:Index,[(547,307)])
  }
  Add(Hub,6014386,280,70)
  {
   link(onEvent1,7261521:doClear,[(407,76)(407,206)])
   link(onEvent2,3823219:doOpen,[(306,83)(306,159)(137,159)(137,234)])
  }
END_SDK
Add(ChildGroupBox,6441274,846,347)
{
 link(onEvent1,5968126:doEvent8,[(944,353)(944,300)])
}
BEGIN_SDK
  Add(EditMulti,14658651,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=797
   Height=585
   link(doWork1,9482439:doBringToFront,[(28,27)(28,111)])
   link(doWork2,11786609:doEvent1,[(126,34)(126,132)])
   link(doWork3,9880777:doText,[(57,41)(57,192)])
  }
  Add(GroupBox,9482439,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Тормозна рідина"
   Point(doBringToFront)
  }
  Add(MultiStrPart,11808187,555,375)
  {
   Char="\9"
   Count=1
   link(onSplit,14921085:doString,[])
  }
  Add(StringTableMT,11628349,471,207)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|22:Дата заміни рідини=150|14:Тип рідини=150|25:Причини заміни рідини=200|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,14554881:doRead,[])
  }
  Add(Button,10175587,303,207)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,13477734:doOperation,[])
  }
  Add(Math,13477734,352,207)
  {
   Op2=1
   ResultType=0
   link(onResult,14374679:doEvent1,[])
   link(Op1,11628349:Count,[(358,188)(418,188)(418,271)(477,271)])
  }
  Add(Edit,9880777,93,186)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,14658651:onEvent1,[(471,199)(471,27)])
  }
  Add(Label,626523,142,186)
  {
   Left=10
   Top=14
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,11676265,100,242)
  {
   Name="db"
   link(onOpen,5852984:doEvent1,[])
   link(FileName,9880777:Text,[(106,230)(99,230)])
  }
  Add(DSC_Exec,6635697,163,291)
  {
   SQL="CREATE TABLE IF NOT EXISTS brake ( \r\nid INTEGER PRIMARY KEY,\r\ndate integer,\r\ntype ineteger, --тип тормозной жидкости\r\ncause text\r\n);"
   DSManager="db"
  }
  Add(DSC_Exec,13306669,520,151)
  {
   DSManager="db"
  }
  Add(ArrayRW,14554881,603,214)
  {
   link(onRead,1415404:doSplit,[])
   link(Array,9121665:Var3,[(609,198)(553,198)(553,272)])
  }
  Add(Hub,14374679,408,207)
  {
   link(onEvent1,11628349:doAdd,[])
   link(onEvent2,1146953:doString,[(446,220)(446,157)])
  }
  Add(FormatStr,1146953,471,151)
  {
   DataCount=1
   Mask="INSERT INTO brake (id) VALUES (%1)"
   link(onFString,13306669:doExec,[])
  }
  Add(DSC_Query,10021401,268,256)
  {
   SQL="SELECT * FROM brake"
   DSManager="db"
   link(onQuery,11628349:doMT_Add,[(386,262)(386,248)])
  }
  Add(DSC_Exec,9590347,695,284)
  {
   DSManager="db"
  }
  Add(FormatStr,3525371,646,284)
  {
   DataCount=4
   Mask="UPDATE brake SET\r\n date ='%2',\r\n type ='%3',\r\n cause='%4'\r\nWHERE id=%1"
   link(onFString,9590347:doExec,[])
   link(Str1,1415404:Part1,[])
   link(Str2,1415404:Part2,[])
   link(Str3,1415404:Part3,[])
   link(Str4,1415404:Part4,[])
  }
  Add(MultiStrPart,1415404,646,214)
  {
   Char="\9"
   Count=4
   link(onSplit,3525371:doString,[(690,220)(690,255)(634,255)(634,290)])
  }
  Add(Hub,5852984,149,242)
  {
   link(onEvent1,10021401:doQuery,[(215,248)(215,262)])
   link(onEvent2,6635697:doExec,[])
  }
  Add(Button,13607318,289,375)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,7314400:doEvent1,[])
  }
  Add(Hub,7314400,345,375)
  {
   link(onEvent1,901330:doRead,[])
   link(onEvent2,7677846:doData,[])
  }
  Add(DoData,7677846,387,382)
  {
   link(onEventData,11628349:doDelete,[(445,388)(445,227)])
   link(Data,11513600:Var1,[(393,321)])
  }
  Add(DSC_Exec,15743862,653,375)
  {
   DSManager="db"
  }
  Add(FormatStr,14921085,604,375)
  {
   DataCount=1
   Mask="DELETE FROM brake WHERE id=%1"
   link(onFString,15743862:doExec,[])
   link(Str1,11808187:Part1,[(610,363)(586,363)(586,419)(561,419)])
  }
  Add(ArrayRW,901330,506,375)
  {
   link(onRead,11808187:doSplit,[])
   link(Array,9121665:Var2,[])
   link(Index,11513600:Var2,[(519,350)(463,350)])
  }
  Add(GetDataEx,9121665,506,267)
  {
   Angle=3
   link(Data,11628349:Strings,[(491,272)])
  }
  Add(GetDataEx,11513600,457,316)
  {
   Angle=1
   link(Data,11628349:Index,[(498,321)])
  }
  Add(Hub,11786609,231,126)
  {
   link(onEvent1,11628349:doClear,[(358,132)(358,220)])
   link(onEvent2,11676265:doOpen,[(257,139)(257,193)(88,193)(88,248)])
  }
END_SDK
Add(ChanelToIndex,983114,126,210)
{
 link(onIndex,8774474:PageTab,[])
}
Add(Hub,16008142,91,203)
{
 link(onEvent1,983114:doWork2,[(112,209)(112,223)])
 link(onEvent2,983114:doWork1,[])
}
Add(ChildGroupBox,2049293,846,398)
{
 link(onEvent1,5968126:doEvent9,[(944,404)(944,307)])
}
BEGIN_SDK
  Add(EditMulti,10278234,21,21)
  {
   EventCount=1
   WorkCount=3
   Width=832
   Height=536
   link(doWork1,5492797:doBringToFront,[(28,27)(30,34)(28,111)])
   link(doWork2,15593822:doEvent1,[(105,34)(105,83)])
   link(doWork3,8211285:doText,[(77,41)(77,115)])
  }
  Add(GroupBox,5492797,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="ЗІП"
   Point(doBringToFront)
  }
  Add(StringTableMT,15469714,504,130)
  {
   Left=10
   Top=55
   Width=760
   Height=320
   Columns=#4:№=25|16:Найменування=150|12:Кількість=75|13:Наявність=150|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,4396345:doRead,[])
  }
  Add(Button,12082724,336,130)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,10464164:doOperation,[])
  }
  Add(Math,10464164,385,130)
  {
   Op2=1
   ResultType=0
   link(onResult,14385736:doEvent1,[])
   link(Op1,15469714:Count,[(391,111)(451,111)(451,194)(510,194)])
  }
  Add(Edit,8211285,133,109)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,10278234:onEvent1,[(506,122)(506,27)])
  }
  Add(Label,12175055,175,109)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,8917315,133,165)
  {
   Name="db"
   link(onOpen,8537194:doEvent1,[])
   link(FileName,8211285:Text,[])
  }
  Add(DSC_Exec,6109932,196,214)
  {
   SQL="CREATE TABLE IF NOT EXISTS zip ( \r\nid INTEGER PRIMARY KEY,\r\nname text,\r\nquantity integer,\r\navailability text\r\n);\r\n"
   DSManager="db"
  }
  Add(DSC_Exec,3352109,553,74)
  {
   DSManager="db"
  }
  Add(ArrayRW,4396345,636,137)
  {
   link(onRead,7276389:doSplit,[])
   link(Array,13512207:Var3,[(642,121)(586,121)(586,195)])
  }
  Add(Hub,14385736,441,130)
  {
   link(onEvent1,15469714:doAdd,[])
   link(onEvent2,13810872:doString,[(479,143)(479,80)])
  }
  Add(FormatStr,13810872,504,74)
  {
   DataCount=1
   Mask="INSERT INTO zip (id) VALUES (%1)"
   link(onFString,3352109:doExec,[])
  }
  Add(DSC_Query,11464347,301,179)
  {
   SQL="SELECT * FROM zip"
   DSManager="db"
   link(onQuery,15469714:doMT_Add,[(419,185)(419,171)])
  }
  Add(DSC_Exec,13958286,728,207)
  {
   DSManager="db"
  }
  Add(FormatStr,8698081,679,207)
  {
   DataCount=4
   Mask="UPDATE zip SET\r\n name='%2',\r\n quantity='%3',\r\n availability='%4'\r\nWHERE id=%1"
   link(onFString,13958286:doExec,[])
   link(Str1,7276389:Part1,[])
   link(Str2,7276389:Part2,[])
   link(Str3,7276389:Part3,[])
   link(Str4,7276389:Part4,[])
  }
  Add(MultiStrPart,7276389,679,137)
  {
   Char="\9"
   Count=4
   link(onSplit,8698081:doString,[(723,143)(723,178)(667,178)(667,213)])
  }
  Add(Hub,8537194,182,165)
  {
   link(onEvent1,11464347:doQuery,[(248,171)(248,185)])
   link(onEvent2,6109932:doExec,[])
  }
  Add(Button,838602,322,298)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,3158010:doEvent1,[])
  }
  Add(Hub,3158010,378,298)
  {
   link(onEvent1,12698045:doRead,[])
   link(onEvent2,5386638:doData,[])
  }
  Add(DoData,5386638,420,305)
  {
   link(onEventData,15469714:doDelete,[(478,311)(478,150)])
   link(Data,6121884:Var1,[(426,244)])
  }
  Add(DSC_Exec,14026919,686,298)
  {
   DSManager="db"
  }
  Add(FormatStr,2168871,637,298)
  {
   DataCount=1
   Mask="DELETE FROM zip WHERE id=%1"
   link(onFString,14026919:doExec,[])
   link(Str1,13695267:Part1,[(643,286)(619,286)(619,342)(594,342)])
  }
  Add(ArrayRW,12698045,539,298)
  {
   link(onRead,13695267:doSplit,[])
   link(Array,13512207:Var2,[])
   link(Index,6121884:Var2,[(552,273)(496,273)])
  }
  Add(GetDataEx,13512207,539,190)
  {
   Angle=3
   link(Data,15469714:Strings,[(524,195)])
  }
  Add(GetDataEx,6121884,490,239)
  {
   Angle=1
   link(Data,15469714:Index,[(531,244)])
  }
  Add(MultiStrPart,13695267,588,298)
  {
   Char="\9"
   Count=1
   link(onSplit,2168871:doString,[])
  }
  Add(Hub,15593822,189,77)
  {
   link(onEvent1,15469714:doClear,[(353,83)(353,143)])
   link(onEvent2,8917315:doOpen,[(215,90)(215,130)(121,130)(121,171)])
  }
END_SDK
Add(DoData,1090255,763,32)
{
 link(onEventData,13869979:doWork1,[])
}
Add(DoData,12636495,763,74)
{
 link(onEventData,16594303:doWork1,[])
}
Add(DoData,2973519,763,116)
{
 link(onEventData,3392:doWork1,[])
}
Add(DoData,11432164,761,158)
{
 link(onEventData,13958430:doWork1,[])
}
Add(DoData,12030643,762,207)
{
 link(onEventData,12437118:doWork1,[])
}
Add(DoData,11648305,762,256)
{
 link(onEventData,12602276:doWork1,[])
}
Add(DoData,15919337,762,305)
{
 link(onEventData,7725053:doWork1,[])
}
Add(DoData,3114967,762,347)
{
 link(onEventData,6441274:doWork1,[])
}
Add(DoData,772131,762,398)
{
 link(onEventData,2049293:doWork1,[])
}
Add(IndexToChanel,4412880,672,252)
{
 Count=11
 link(onEvent1,1090255:doData,[(744,258)(744,38)])
 link(onEvent2,12636495:doData,[(744,265)(744,80)])
 link(onEvent3,2973519:doData,[(744,272)(744,122)])
 link(onEvent4,11432164:doData,[(744,279)(744,164)])
 link(onEvent5,12030643:doData,[(744,286)(744,213)])
 link(onEvent6,11648305:doData,[(744,293)(744,262)])
 link(onEvent7,15919337:doData,[(744,300)(744,311)])
 link(onEvent8,3114967:doData,[(744,307)(744,353)])
 link(onEvent9,772131:doData,[(744,314)(744,404)])
 link(onEvent10,14087333:doData,[(744,321)(744,451)])
}
Add(MainForm,5210529,328,105)
{
 Width=1141
 Height=990
 Point(onClose)
 Point(SizeHeader)
 Point(Handle)
 link(onCreate,11302920:doEvent1,[])
}
Add(Hub,5968126,1008,245)
{
 InCount=10
 link(onEvent1,2811278:In,[])
}
Add(Hub,5246273,518,252)
{
 OutCount=10
 link(onEvent1,13869979:doWork2,[(556,258)(556,45)])
 link(onEvent2,16594303:doWork2,[(689,265)(689,87)])
 link(onEvent3,3392:doWork2,[(556,272)(556,129)])
 link(onEvent4,13958430:doWork2,[(556,279)(556,171)])
 link(onEvent5,12437118:doWork2,[(556,286)(556,220)])
 link(onEvent6,12602276:doWork2,[(556,293)(556,269)])
 link(onEvent7,7725053:doWork2,[(556,300)(556,318)])
 link(onEvent8,6441274:doWork2,[(556,307)(556,360)])
 link(onEvent9,2049293:doWork2,[(689,314)(689,411)])
 link(onEvent10,11784741:doWork2,[(556,321)(556,458)])
}
Add(ListBox,5671226,406,238)
{
 Left=5
 Top=30
 Width=200
 Height=920
 DataType=1
 Point(Index)
 Point(onDblClick)
 link(onClick,14170629:doEvent1,[(474,251)(474,146)])
 link(onDblClick,5246273:doEvent1,[])
}
Add(DoData,736780,427,350)
{
 link(onEventData,5671226:doDelete,[(467,356)(467,317)(366,317)(366,258)])
 link(Data,5671226:Index,[])
}
Add(Button,16015661,343,350)
{
 Left=150
 Top=5
 Width=60
 Caption="Удалить"
 link(onClick,736780:doData,[])
}
Add(ODialog,4673223,126,56)
{
 Filter="Текст|*.txt"
 link(onExecute,14485583:doEvent1,[])
}
Add(SDialog,6419896,126,105)
{
 Filter="Текст|*.txt"
 link(onExecute,12522412:doEvent1,[])
}
Add(Menu,7920668,0,77)
{
 Menu=#4:Файл|1:(|5:Новий|8:Відкрити|8:Зберегти|11:Зберегти як|1:-|5:Вихід|1:)|8:Допомога|12:Про програму|
 Point(onSelectNum)
 link(onSelectNum,3934991:doEvent,[])
}
Add(IndexToChanel,3934991,49,84)
{
 Count=11
 link(onEvent3,4673223:doExecute,[(117,104)(117,62)])
 link(onEvent4,5625880:doWork2,[])
 link(onEvent5,5625880:doWork3,[(117,118)])
 link(onEvent10,5210529:doClose,[(201,153)(201,132)])
 link(onEvent11,10924091:doMessage,[])
}
Add(Hub,14485583,182,56)
{
 link(onEvent1,13865704:doWork2,[])
 link(onEvent2,12700761:In,[])
}
Add(Memory,12805926,329,56)
{
}
Add(Message,10924091,126,154)
{
 Message="Привет "
}
Add(HubEx,5625880,113,105)
{
 link(onEvent,6419896:doExecute,[])
}
Add(Hub,12522412,182,105)
{
 link(onEvent1,13865704:doWork3,[(300,111)])
 link(onEvent2,13036038:In,[])
}
Add(HubEx,13865704,296,56)
{
 link(onEvent,12805926:doValue,[])
}
Add(DoData,14087333,763,445)
{
 link(onEventData,11784741:doWork1,[])
}
Add(InfoTip,10612721,828,345)
{
 Info=#0:|26:           Тормозна рідина|
 Width=169
 Height=39
}
Add(InfoTip,13875501,828,303)
{
 Info=#1: |34:                Охолоджуюча рідина|
 Width=169
 Height=39
}
Add(InfoTip,1920936,828,205)
{
 Info=#0:|12:         АКБ|
 Width=169
 Height=39
}
Add(InfoTip,13177498,828,156)
{
 Info=#0:|13:         Шини|
 Width=169
 Height=39
}
Add(InfoTip,12905837,828,114)
{
 Info=#0:|11:         ТО|
 Width=169
 Height=39
}
Add(InfoTip,16183452,485,16)
{
 Info=#18:Сторінки програми |
 Width=561
 Height=487
}
Add(InfoTip,14087171,828,254)
{
 Info=#0:|14:         Масло|
 Width=169
 Height=39
}
Add(InfoTip,9347721,828,394)
{
 Info=#0:|12:         ЗІП|
 Width=169
 Height=39
}
Add(InfoTip,6981593,828,72)
{
 Info=#0:|17:         Персонал|
 Width=169
 Height=39
}
Add(InfoTip,1691909,828,23)
{
 Info=#0:|20:          Информація|
 Width=169
 Height=46
}
Add(InfoTip,10770090,826,441)
{
 Info=#0:|19:         Моторесурс|
 Width=169
 Height=39
}
Add(LineBreak,10422579,259,238)
{
 Caption="Занос данных"
 link(Out,5671226:doAdd,[(375,244)(375,244)])
 Primary=[2811278,812,7]
}
Add(LineBreak,9732947,259,266)
{
 Caption="Открытие"
 link(Out,5671226:doLoad,[])
 Primary=[12700761,-42,-203]
}
Add(LineBreak,14324659,259,287)
{
 Caption="Сохранение "
 link(Out,5671226:doSave,[(371,293)(371,279)])
 Primary=[13036038,-35,-175]
}
Add(ChildGroupBox,13869979,844,32)
{
 link(onEvent3,5968126:doEvent1,[(943,52)(943,251)])
}
BEGIN_SDK
  Add(EditMulti,1093219,-21,14)
  {
   EventCount=3
   WorkCount=3
   Width=895
   Height=599
   link(doWork1,1821971:doBringToFront,[])
   link(doWork2,1054614:doEvent1,[(119,27)(119,69)])
   link(doWork3,12731683:doText2,[])
  }
  Add(GroupBox,1821971,42,14)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="Інформація"
   Point(doBringToFront)
  }
  Add(StringTableMT,3507321,457,165)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|9:Серія=100|19:Марка та модель=100|7:Тип=150|16:Постачальник=150|19:Код ВК 001-2000=250|18:Завод-виробник=200|20:Рік виготовлення=200|8:Шасі=250|10:Кузов№=200|23:Модель та № двигуна-250|14:В/Н машини=200|14:Моторесурс=200|9:Водій=200|10:Стасут=200|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,8097891:doRead,[])
  }
  Add(Button,5227062,289,165)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,5709514:doOperation,[])
  }
  Add(Math,5709514,338,165)
  {
   Op2=1
   ResultType=0
   link(onResult,15254699:doEvent1,[])
   link(Op1,3507321:Count,[(344,146)(404,146)(404,229)(463,229)])
  }
  Add(Edit,12731683,86,21)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onChange,1093219:onEvent2,[])
   link(onEnter,1093219:onEvent3,[])
  }
  Add(Label,15829541,128,39)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,2788739,86,200)
  {
   Name="db"
   link(onOpen,16210215:doEvent1,[])
   link(FileName,12731683:Text,[])
  }
  Add(DSC_Exec,3817980,198,207)
  {
   SQL="CREATE TABLE IF NOT EXISTS transport(\r\n id INTEGER PRIMARY KEY,\r\n series TEXT,\r\n marka INTEGER, --id из списка марок \r\n model INTEGER, --id из списка моделей\r\n type INTEGER, --id из списка типов \r\n provider INTEGER, --id из списка поставщиков\r\n codvk text, --тут и текст и буквы\r\n factory INTEGER, --id из списка производителей\r\n dyear INTEGER,\r\n chassis text,\r\n body text,\r\n engine text,\r\n regNom text,\r\n prob INTEGER,\r\n driver INTEGER, --id из таблицы personal \r\n status INTEGER -- 0-рабочая, 1-в ремонте, 2-списана \r\n );\r\n"
   DSManager="db"
  }
  Add(DSC_Exec,13011596,506,109)
  {
   DSManager="db"
  }
  Add(ArrayRW,8097891,589,172)
  {
   link(onRead,1975636:doSplit,[])
   link(Array,10746862:Var3,[(595,158)(539,158)(539,157)(539,230)])
  }
  Add(Hub,15254699,394,165)
  {
   link(onEvent1,3507321:doAdd,[])
   link(onEvent2,363894:doString,[(432,178)(432,115)])
  }
  Add(FormatStr,363894,457,109)
  {
   DataCount=1
   Mask="INSERT INTO transport (id) VALUES (%1)"
   link(onFString,13011596:doExec,[])
  }
  Add(DSC_Query,5954143,254,200)
  {
   SQL="SELECT * FROM transport"
   DSManager="db"
   link(onQuery,3507321:doMT_Add,[])
  }
  Add(DSC_Exec,8261552,821,305)
  {
   DSManager="db"
  }
  Add(FormatStr,14594587,632,235)
  {
   DataCount=16
   Mask="UPDATE transport SET series = '%2',marka= '%3' model = '%4', type = '%5', provider = '%6', codvk = '%7' , factory = '%8' , dyear = '%9' , chassis = '%10', body ='%11' , engine= '%12', regNom= '%13' , prob= '%14' , diver='%15' , status= '%16' WHERE id=%1"
   link(onFString,8261552:doExec,[(784,241)(784,311)])
   link(Str1,1975636:Part1,[])
   link(Str2,1975636:Part2,[])
   link(Str3,1975636:Part3,[])
   link(Str4,1975636:Part4,[])
   link(Str5,1975636:Part5,[])
   link(Str6,1975636:Part6,[])
   link(Str7,1975636:Part7,[])
   link(Str8,1975636:Part8,[])
   link(Str9,1975636:Part9,[])
   link(Str10,1975636:Part10,[])
   link(Str11,1975636:Part11,[])
   link(Str12,1975636:Part12,[])
   link(Str13,1975636:Part13,[])
   link(Str14,1975636:Part14,[])
   link(Str15,1975636:Part15,[])
   link(Str16,1975636:Part16,[])
  }
  Add(MultiStrPart,1975636,632,172)
  {
   Char="\9"
   Count=16
   link(onSplit,14594587:doString,[(759,178)(759,210)(620,210)(620,241)])
  }
  Add(Hub,16210215,135,200)
  {
   link(onEvent1,5954143:doQuery,[])
   link(onEvent2,3817980:doExec,[])
  }
  Add(Button,9039559,275,333)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,12175230:doEvent1,[])
  }
  Add(Hub,12175230,331,333)
  {
   link(onEvent1,16009664:doRead,[])
   link(onEvent2,14938611:doData,[])
  }
  Add(DoData,14938611,373,340)
  {
   link(onEventData,3507321:doDelete,[(431,346)(431,185)])
   link(Data,13069318:Var1,[(379,279)])
  }
  Add(DSC_Exec,2818224,639,333)
  {
   DSManager="db"
  }
  Add(FormatStr,9911972,590,333)
  {
   DataCount=1
   Mask="DELETE FROM transport WHERE id=%1"
   link(onFString,2818224:doExec,[])
   link(Str1,1062532:Part1,[(596,321)(572,321)(572,377)(541,377)])
  }
  Add(ArrayRW,16009664,492,333)
  {
   link(onRead,1062532:doSplit,[])
   link(Array,10746862:Var2,[])
   link(Index,13069318:Var2,[(505,308)(449,308)])
  }
  Add(GetDataEx,10746862,492,225)
  {
   Angle=3
   link(Data,3507321:Strings,[(477,230)])
  }
  Add(GetDataEx,13069318,443,274)
  {
   Angle=1
   link(Data,3507321:Index,[(484,279)])
  }
  Add(MultiStrPart,1062532,535,333)
  {
   Char="\9"
   Count=1
   link(onSplit,9911972:doString,[])
  }
  Add(Hub,1054614,259,63)
  {
   link(onEvent1,3507321:doClear,[(365,69)(365,178)])
   link(onEvent2,2788739:doOpen,[(285,76)(285,141)(74,141)(74,206)])
  }
END_SDK
Add(MultiElementEx,15470616,325,168)
{
 link(Handle,5210529:SizeHeader,[(331,152)(334,152)])
 link(HeaderSize,5210529:Handle,[(345,152)(341,152)])
}
BEGIN_SDK
  Add(EditMultiEx,192608,21,21)
  {
   WorkCount=#9:doMaxSize|
   EventCount=#7:XxYsize|
   VarCount=#16:WidthVisibleArea|17:HeightVisibleArea|
   DataCount=#6:Handle|10:BorderSize|10:HeaderSize|
   Width=958
   Height=557
   link(doMaxSize,7045888:doEvent1,[(137,27)(137,265)])
   link(WidthVisibleArea,377241:Var2,[(27,420)(629,420)])
   link(HeightVisibleArea,15386201:Var2,[(34,459)(594,459)])
  }
  Add(Screen,7845531,350,189)
  {
   Point(BottomWorkarea)
  }
  Add(SizeWindow,8420958,350,259)
  {
   link(Handle,192608:Handle,[(356,140)(27,140)])
   link(Width,7845531:Width,[(363,245)(356,245)])
   link(Height,7845531:BottomWorkarea,[(370,247)(377,247)])
  }
  Add(Hub,7045888,252,259)
  {
   OutCount=3
   link(onEvent1,8420958:doWidth,[])
   link(onEvent2,8420958:doHeight,[])
   link(onEvent3,10623626:In,[])
  }
  Add(MathParse,15142984,525,231)
  {
   MathStr="%1 - (%2*2)"
   link(onResult,9890621:doValue,[])
   link(X1,8420958:CurrentWidth,[(531,219)(415,219)(415,303)(356,303)])
   link(X2,7021917:Var3,[(538,126)])
  }
  Add(MathParse,9862497,525,308)
  {
   DataCount=3
   MathStr="%1 - %2 - %3"
   link(onResult,12337854:doValue,[])
   link(X1,8420958:CurrentHeight,[(531,297)(363,297)])
   link(X2,7021917:Var2,[(538,219)(440,219)])
   link(X3,192608:HeaderSize,[(545,164)(41,164)])
  }
  Add(Hub,4056530,483,231)
  {
   link(onEvent1,15142984:doCalc,[])
   link(onEvent2,9862497:doCalc,[(515,244)(515,314)])
  }
  Add(LineBreak,13485889,427,231)
  {
   link(Out,4056530:doEvent1,[])
   Primary=[10623626,-112,42]
  }
  Add(GetDataEx,7021917,434,121)
  {
   Angle=3
   link(Data,192608:BorderSize,[(34,126)])
  }
  Add(Memory,9890621,623,231)
  {
  }
  Add(Memory,12337854,588,308)
  {
   link(onData,387831:doStrCatDlm,[(670,314)(670,454)])
  }
  Add(StrCatDelim,387831,721,448)
  {
   Delimiter="x"
   link(onStrCatDlm,192608:XxYsize,[(866,454)(866,27)])
   link(Str1,377241:Var3,[(727,278)])
   link(Str2,15386201:Var3,[(734,369)])
  }
  Add(GetDataEx,377241,623,273)
  {
   link(Data,9890621:Value,[])
  }
  Add(GetDataEx,15386201,588,364)
  {
   link(Data,12337854:Value,[])
  }
END_SDK
Add(Hub,11302920,392,119)
{
 link(onEvent1,16008142:doEvent1,[(418,125)(418,174)(79,174)(79,209)])
 link(onEvent2,15470616:doMaxSize,[(418,132)(418,160)(313,160)(313,174)])
}
Add(DatePicker,6955404,0,21)
{
 Left=1010
 Top=5
 Width=115
 Height=21
}
Add(ChildGroupBox,3392,847,116)
{
 link(onEvent1,5968126:doEvent3,[(943,122)(943,265)])
}
BEGIN_SDK
  Add(EditMulti,594006,-14,14)
  {
   EventCount=1
   WorkCount=3
   Width=783
   Height=585
   link(doWork1,14145463:doBringToFront,[(77,20)(77,111)])
   link(doWork2,7427265:doEvent1,[(91,27)(91,90)])
   link(doWork3,8670019:doText,[(29,34)(29,178)])
  }
  Add(GroupBox,14145463,35,105)
  {
   Left=220
   Top=35
   Width=775
   Height=450
   Caption="ТО"
   Point(doBringToFront)
  }
  Add(MultiStrPart,6596111,534,361)
  {
   Char="\9"
   Count=1
   link(onSplit,12549810:doString,[])
  }
  Add(StringTableMT,10156469,450,193)
  {
   Left=10
   Top=55
   Width=775
   Height=320
   Columns=#4:№=25|19:Дата проведення=150|10:Вид ТО=150|23:Показник спідометру=150|19:Висновок про ТО=200|0:|
   StrDelimiter="\9"
   Redaction=0
   IconsCheck=[]
   MiscIcons=[]
   Icons=[]
   Point(doMT_Add)
   Point(Strings)
   Point(onLineChange)
   Point(Index)
   link(onLineChange,7660174:doRead,[])
  }
  Add(Button,12281969,233,193)
  {
   Left=10
   Top=34
   Width=120
   Caption="Добавить строку"
   link(onClick,7952942:doOperation,[])
  }
  Add(Math,7952942,331,193)
  {
   Op2=1
   ResultType=0
   link(onResult,9388554:doEvent1,[])
   link(Op1,10156469:Count,[(337,174)(397,174)(397,257)(456,257)])
  }
  Add(Label,10005151,121,172)
  {
   Left=10
   Top=13
   Width=48
   Height=17
   Caption="Имя БД:"
  }
  Add(DS_SQLite,9742640,79,228)
  {
   Name="db"
   link(onOpen,12589275:doEvent1,[])
   link(FileName,14551549:Var2,[])
  }
  Add(DSC_Exec,16276188,142,277)
  {
   SQL="CREATE TABLE IF NOT EXISTS tov ( \r\n  id INTEGER PRIMARY KEY,\r\n  date integer,\r\n  nameTO text,\r\n  odometr integer,\r\n  conclusion text\r\n);"
   DSManager="db"
  }
  Add(DSC_Exec,3063644,499,137)
  {
   DSManager="db"
  }
  Add(ArrayRW,7660174,582,200)
  {
   link(onRead,2536623:doSplit,[])
   link(Array,355376:Var3,[(588,184)(532,184)(532,258)])
  }
  Add(Hub,9388554,387,193)
  {
   link(onEvent1,10156469:doAdd,[])
   link(onEvent2,6135054:doString,[(425,206)(425,143)])
  }
  Add(FormatStr,6135054,450,137)
  {
   DataCount=1
   Mask="INSERT INTO tov (id) VALUES (%1)"
   link(onFString,3063644:doExec,[])
  }
  Add(DSC_Query,3811334,247,242)
  {
   SQL="SELECT * FROM tov"
   DSManager="db"
   link(onQuery,10156469:doMT_Add,[(365,248)(365,234)])
  }
  Add(DSC_Exec,13779534,674,270)
  {
   DSManager="db"
  }
  Add(FormatStr,2197243,625,270)
  {
   DataCount=5
   Mask="UPDATE tov \r\nSET date integer,\r\n  nameTO = '%2'\r\n  odometr ='%3',\r\n  conclusion ='%4'  \r\nWHERE id=%1"
   link(onFString,13779534:doExec,[])
   link(Str1,2536623:Part1,[])
   link(Str2,2536623:Part2,[])
   link(Str3,2536623:Part3,[])
   link(Str4,2536623:Part4,[])
   link(Str5,2536623:Part5,[])
  }
  Add(MultiStrPart,2536623,625,200)
  {
   Char="\9"
   Count=5
   link(onSplit,2197243:doString,[(669,206)(669,241)(613,241)(613,276)])
  }
  Add(Hub,12589275,128,228)
  {
   link(onEvent1,3811334:doQuery,[(194,234)(194,248)])
   link(onEvent2,16276188:doExec,[])
  }
  Add(Button,2956267,268,361)
  {
   Left=135
   Top=34
   Width=120
   Caption="Удалить строку"
   link(onClick,6767165:doEvent1,[])
  }
  Add(Hub,6767165,324,361)
  {
   link(onEvent1,12972110:doRead,[])
   link(onEvent2,361708:doData,[])
  }
  Add(DoData,361708,366,368)
  {
   link(onEventData,10156469:doDelete,[(415,374)(415,211)(450,211)])
   link(Data,7895740:Var1,[(372,307)])
  }
  Add(DSC_Exec,12366266,632,361)
  {
   DSManager="db"
  }
  Add(FormatStr,12549810,583,361)
  {
   DataCount=1
   Mask="DELETE FROM tov WHERE id=%1"
   link(onFString,12366266:doExec,[])
   link(Str1,6596111:Part1,[(589,349)(565,349)(565,405)(540,405)])
  }
  Add(ArrayRW,12972110,485,361)
  {
   link(onRead,6596111:doSplit,[])
   link(Array,355376:Var2,[])
   link(Index,7895740:Var2,[(498,336)(442,336)])
  }
  Add(GetDataEx,355376,485,253)
  {
   Angle=3
   link(Data,10156469:Strings,[(470,258)])
  }
  Add(GetDataEx,7895740,436,302)
  {
   Angle=1
   link(Data,10156469:Index,[(477,307)])
  }
  Add(Hub,7427265,196,84)
  {
   OutCount=3
   link(onEvent1,10156469:doClear,[(330,90)(330,206)])
   link(onEvent2,9742640:doOpen,[(222,97)(222,165)(67,165)(67,234)])
  }
  Add(GetDataEx,14551549,79,217)
  {
   link(Data,8670019:Text,[(85,216)(78,216)])
  }
  Add(Edit,8670019,72,172)
  {
   Left=60
   Top=13
   Width=465
   Text=""
   link(onEnter,594006:onEvent1,[(436,185)(436,20)])
  }
END_SDK
Add(Hub,14170629,518,140)
{
 OutCount=10
 link(onEvent1,13869979:doWork3,[(688,146)(688,52)])
 link(onEvent2,16594303:doWork3,[(688,153)(688,94)])
 link(onEvent3,3392:doWork3,[(688,160)(688,136)])
 link(onEvent4,13958430:doWork3,[(688,167)(688,178)])
 link(onEvent5,12437118:doWork3,[(689,174)(689,227)])
 link(onEvent6,12602276:doWork3,[(689,181)(689,276)])
 link(onEvent7,7725053:doWork3,[(689,188)(689,325)])
 link(onEvent8,6441274:doWork3,[(689,195)(689,367)])
 link(onEvent9,2049293:doWork3,[(689,202)(689,418)])
 link(onEvent10,11784741:doWork3,[(690,209)(690,465)])
}

  

Add(MainForm,2953706,84,161)
{
 Width=1196
 Height=546
 Position=1
 Point(onClose)
 link(onCreate,14626366:doOpen,[])
 link(onClose,14626366:doClose,[])
}
Add(DS_SQLite,14626366,133,175)
{
 Name="mdb"
 FileName="mydbTest.db"
 link(onOpen,3663874:doExec,[])
}
Add(DSC_Exec,3663874,175,175)
{
 SQL="CREATE TABLE IF NOT EXISTS transport(\r\n id INTEGER PRIMARY KEY,  -- iдентифiкатор\r\n series TEXT,  -- Серія та №\r\n type INTEGER,  -- Тип\r\n marka INTEGER,   -- Марка\r\n model INTEGER,  -- Модель\r\n factory INTEGER,  -- Завод-виробник\r\n vyear INTEGER,  -- Рік виготовлення\r\n provider INTEGER,  -- Постачальник\r\n idnum TEXT,  -- Код ВК 001-2000\r\n chassis TEXT,  -- Шасі(рама)№\r\n body TEXT,  -- Кузов №\r\n engine TEXT,  -- Модель та № двигуна\r\n regNom TEXT,  --В/Н машини \r\n probig INTEGER, -- Показание одометра на момент регистрации\r\n status INTEGER); --\r\n \r\nCREATE TABLE IF NOT EXISTS marka(\r\n marka TEXT, \r\n id INTEGER PRIMARY KEY);  -- iдентифiкатор\r\n \r\nCREATE TABLE IF NOT EXISTS model(\r\n model TEXT, \r\n id INTEGER PRIMARY KEY,-- iдентифiкатор\r\n id_marka INTEGER,  -- iдентифiкатор Марки\r\n id_type INTEGER ); -- iдентифiкатор type\r\n \r\nCREATE TABLE IF NOT EXISTS type(\r\n type TEXT, \r\n id INTEGER PRIMARY KEY);  -- iдентифiкатор\r\n \r\nCREATE TABLE IF NOT EXISTS factory(\r\n name TEXT, \r\n id INTEGER PRIMARY KEY);  -- iдентифiкатор \r\n\r\nCREATE TABLE IF NOT EXISTS personal (   \r\n id INTEGER PRIMARY KEY,\r\n rank text,\r\n name text,\r\n serial text,\r\n date integer,\r\n status integer -- 0-служит, 1-уволен \r\n); "
 DSManager="mdb"
 link(onExec,16051682:doQuery,[])
}
Add(DSC_Query,16051682,217,175)
{
 SQL="SELECT case WHEN count()=0 then 0 ELSE 1 END FROM type;"
 DSManager="mdb"
 link(onQuery,2460415:doEvent,[])
}
Add(DSC_Exec,3991226,308,175)
{
 SQL="begin;\r\nINSERT INTO type values('Самосвалы',NULL);\r\nINSERT INTO type values('Шасси',NULL);\r\nINSERT INTO type values('Бортовые автомобили',NULL);\r\nINSERT INTO type values('Лесовозы и сортиментовозы',NULL);\r\nINSERT INTO type values('Седельные тягачи',NULL);\r\nINSERT INTO type values('Спецтехника',NULL);\r\n\r\nINSERT into marka values('КрАЗ',NULL);\r\nINSERT into marka values('МАЗ',NULL);\r\nINSERT into marka values('ЗИС',NULL);\r\n-- Самосвалы 1\r\nINSERT into model values('65055',NULL,1,1);\r\nINSERT into model values('6511C4',NULL,1,1);\r\nINSERT into model values('7511C4',NULL,1,1);\r\nINSERT into model values('65032',NULL,1,1);\r\nINSERT into model values('6511C6',NULL,1,1);\r\nINSERT into model values('7133C4',NULL,1,1);\r\nINSERT into model values('6511C4',NULL,1,1);\r\n-- Шасси 2\r\nINSERT into model values('5233Н2',NULL,1,2);\r\nINSERT into model values('5401H2',NULL,1,2);\r\nINSERT into model values('5233НЕ',NULL,1,2);\r\nINSERT into model values('65053',NULL,1,2);\r\nINSERT into model values('6511H4',NULL,1,2);\r\nINSERT into model values('6322',NULL,1,2); \r\nINSERT into model values('63221',NULL,1,2);\r\nINSERT into model values('6511H6',NULL,1,2);\r\nINSERT into model values('7133H4',NULL,1,2);\r\nINSERT into model values('7140Н6',NULL,1,2);\r\nINSERT into model values('7634НE',NULL,1,2);\r\n-- Бортовые автомобили 3\r\nINSERT into model values('5233BE',NULL,1,3);\r\nINSERT into model values('В6.2МEХ',NULL,1,3);\r\nINSERT into model values('65053',NULL,1,3);\r\nINSERT into model values('6322',NULL,1,3);\r\nINSERT into model values('В12.2МЕХ',NULL,1,3);\r\n-- Лесовозы и сортиментовозы 4\r\nINSERT into model values('64372',NULL,1,4);\r\nINSERT into model values('6511M4',NULL,1,4);\r\nINSERT into model values('6233М6',NULL,1,4);\r\n-- Седельные тягачи 5\r\nINSERT into model values('64431',NULL,1,5);\r\nINSERT into model values('6443',NULL,1,5);\r\nINSERT into model values('6446',NULL,1,5);\r\n-- Спецтехника 6\r\nINSERT into model values('6511H4(АЦ-13-70)',NULL,1,6);\r\nINSERT into model values('5401К2',NULL,1,6);\r\nINSERT into model values('5401Н2',NULL,1,6);\r\nINSERT into model values('6511С4',NULL,1,6);\r\n\r\nend;"
 DSManager="mdb"
}
Add(IndexToChanel,2460415,259,175)
{
 link(onEvent1,3991226:doExec,[])
}
Add(MenuEx,8114414,77,224)
{
 EndItemRight=0
 Menu=#9:ДОВIДНИКИ|1:(|4:Типи|5:Марки|6:Моделi|9:Виробники|13:Постачальники|1:)|9:ТРАНСПОРТ|8:ПЕРСОНАЛ|5:ВИХIД|
 Font=[Courier New,12,1,0,204]
 Bitmaps=[]
 link(MenuItemIdx,10394476:doOperation,[])
}
Add(Math,10394476,126,224)
{
 OpType=9
 Op1=1
 link(onResult,13620088:doBits,[])
}
Add(IntToBits,13620088,182,224)
{
 Count=9
 Data_0=Integer(0)
 Data_1=Integer(1)
 link(onBit2,6038767:doWork1,[])
 link(onBit3,6405393:doWork1,[])
 link(onBit4,6811841:doWork1,[])
 link(onBit5,10066168:doWork1,[])
}
Add(ChildGroupBox,6038767,504,231)
{
}
BEGIN_SDK
  Add(EditMulti,13536660,21,21)
  {
   EventCount=1
   WorkCount=1
   Width=671
   Height=256
   link(doWork1,14587823:doWork2,[(28,27)(28,111)])
  }
  Add(GroupBox,9234840,77,105)
  {
   Left=35
   Top=105
   Width=488
   Height=248
   Font=[MS Sans Serif,10,1,255,1]
   Visible=1
   Caption="Т И П И"
   Point(doVisible)
   Point(onShow)
   Point(onHide)
   link(onShow,9234595:doEvent1,[])
   link(onHide,2767807:doWork1,[(116,118)(116,101)(165,101)])
  }
  Add(DSC_Query,14614700,168,112)
  {
   SQL="SELECT * FROM type ORDER BY type;"
   DSManager="parent.mdb"
   link(onQuery,14046847:doAdd,[])
  }
  Add(ListBox,14046847,224,112)
  {
   Left=10
   Top=25
   Width=220
   Height=205
   Font=[Courier New,11,1,0,204]
   Hint="Выделите нужный пункт\r\n и  нажмите ПКМ"
   Point(onMouseDown)
   Point(String)
   Point(Data)
   link(onMouseDown,1785004:doEvent,[])
  }
  Add(Hub,9234595,140,105)
  {
   InCount=2
   link(onEvent1,2767807:doWork2,[])
   link(onEvent2,14614700:doQuery,[])
  }
  Add(IndexToChanel,1785004,273,126)
  {
   link(onEvent2,13922544:doPopupHere,[])
  }
  Add(PopupMenuEx,13922544,322,133)
  {
   Menu=#11:Новий запис|10:Редагуавти|
   Bitmaps=[]
   link(MenuItemIdx,644358:doEvent,[])
  }
  Add(IndexToChanel,644358,371,133)
  {
   link(onEvent1,16292982:doData,[(413,139)(413,97)])
   link(onEvent2,14409768:doString,[])
  }
  Add(Memory,14805937,581,147)
  {
  }
  Add(MT_MultiData,11658963,532,140)
  {
   link(onData1,12885560:doText2,[])
   link(onData2,14805937:doValue,[])
  }
  Add(Edit,12885560,623,133)
  {
   Left=240
   Top=95
   Width=220
   Text=""
  }
  Add(Button,10689557,24,182)
  {
   Left=240
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ВIДМIНИТИ"
   Data=Integer(0)
   link(onClick,14587823:doWork3,[(74,188)])
  }
  Add(Button,11906525,535,203)
  {
   Left=358
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ЗБЕРЕГТИ"
   link(onClick,4139843:doString,[])
  }
  Add(FormatStr,14409768,427,140)
  {
   Mask="SELECT * FROM type WHERE id=%1; "
   link(onFString,13655259:doWork2,[])
   link(Str1,14046847:Data,[(433,129)(419,129)(419,170)(258,170)])
  }
  Add(DoData,16292982,427,91)
  {
   Data=String(SELECT "","NULL";)
   link(onEventData,13655259:doWork1,[(473,97)])
  }
  Add(DSC_Query,7995697,490,140)
  {
   DSManager="parent.mdb"
   link(onQuery,11658963:doSeparateMT,[])
  }
  Add(HubEx,13655259,469,140)
  {
   link(onEvent,7995697:doQuery,[])
  }
  Add(FormatStr,4139843,581,203)
  {
   Mask="INSERT OR REPLACE INTO type VALUES("%2", %1);"
   link(onFString,6503670:doExec,[])
   link(Str1,14805937:Value,[])
   link(Str2,12885560:Text,[(594,184)(629,184)])
  }
  Add(HubEx,14587823,70,105)
  {
   link(onEvent,9234840:doVisible,[])
  }
  Add(HubEx,2767807,161,105)
  {
   link(onEvent,14046847:doClear,[(212,111)(212,125)])
  }
  Add(DSC_Exec,6503670,623,203)
  {
   DSManager="parent.mdb"
   link(onExec,9234595:doEvent2,[(668,209)(668,244)(128,244)(128,118)])
  }
  Add(Label,11038941,238,70)
  {
   Left=240
   Top=78
   Width=220
   Font=[Courier New,10,3,16711680,204]
   Caption="Тип транспортного засобу."
   AutoSize=1
   Alignment=2
  }
END_SDK
Add(ChildGroupBox,6405393,469,238)
{
}
BEGIN_SDK
  Add(EditMulti,9297754,21,21)
  {
   EventCount=1
   WorkCount=1
   Width=671
   Height=256
   link(doWork1,9351585:doWork2,[(28,27)(28,111)])
  }
  Add(GroupBox,10652149,77,105)
  {
   Left=35
   Top=105
   Width=488
   Height=248
   Font=[MS Sans Serif,10,1,255,1]
   Visible=1
   Caption="М А Р К И"
   Point(doVisible)
   Point(onShow)
   Point(onHide)
   link(onShow,15485636:doEvent1,[])
   link(onHide,16235182:doWork1,[(116,118)(116,101)(165,101)])
  }
  Add(DSC_Query,6515777,168,112)
  {
   SQL="SELECT * FROM marka ORDER BY marka;"
   DSManager="parent.mdb"
   link(onQuery,14592529:doAdd,[])
  }
  Add(ListBox,14592529,224,112)
  {
   Left=10
   Top=25
   Width=220
   Height=205
   Font=[Courier New,11,1,0,204]
   Point(onMouseDown)
   Point(String)
   Point(Data)
   link(onMouseDown,792695:doEvent,[])
  }
  Add(Hub,15485636,140,105)
  {
   InCount=2
   link(onEvent1,16235182:doWork2,[])
   link(onEvent2,6515777:doQuery,[])
  }
  Add(IndexToChanel,792695,273,126)
  {
   link(onEvent2,5783544:doPopupHere,[])
  }
  Add(PopupMenuEx,5783544,322,133)
  {
   Menu=#11:Новий запис|10:Редагуавти|
   Bitmaps=[]
   link(MenuItemIdx,6603922:doEvent,[])
  }
  Add(IndexToChanel,6603922,371,133)
  {
   link(onEvent1,9252556:doData,[(413,139)(413,97)])
   link(onEvent2,7868609:doString,[])
  }
  Add(Memory,9987830,581,147)
  {
  }
  Add(MT_MultiData,6511585,532,140)
  {
   link(onData1,8642877:doText2,[])
   link(onData2,9987830:doValue,[])
  }
  Add(Edit,8642877,623,133)
  {
   Left=240
   Top=95
   Width=220
   Text=""
  }
  Add(Button,7093209,24,182)
  {
   Left=240
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ВIДМIНИТИ"
   Data=Integer(0)
   link(onClick,9351585:doWork3,[(74,188)])
  }
  Add(Button,14422029,535,203)
  {
   Left=358
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ЗБЕРЕГТИ"
   link(onClick,3360994:doString,[])
  }
  Add(FormatStr,7868609,427,140)
  {
   Mask="SELECT * FROM marka WHERE id=%1; "
   link(onFString,16541283:doWork2,[])
   link(Str1,14592529:Data,[(433,129)(419,129)(419,170)(258,170)])
  }
  Add(DoData,9252556,427,91)
  {
   Data=String(SELECT "","NULL";)
   link(onEventData,16541283:doWork1,[(473,97)])
  }
  Add(DSC_Query,15751572,490,140)
  {
   DSManager="parent.mdb"
   link(onQuery,6511585:doSeparateMT,[])
  }
  Add(HubEx,16541283,469,140)
  {
   link(onEvent,15751572:doQuery,[])
  }
  Add(FormatStr,3360994,581,203)
  {
   Mask="INSERT OR REPLACE INTO marka VALUES("%2", %1);"
   link(onFString,6564502:doExec,[])
   link(Str1,9987830:Value,[])
   link(Str2,8642877:Text,[(594,184)(629,184)])
  }
  Add(HubEx,9351585,70,105)
  {
   link(onEvent,10652149:doVisible,[])
  }
  Add(HubEx,16235182,161,105)
  {
   link(onEvent,14592529:doClear,[(212,111)(212,125)])
  }
  Add(DSC_Exec,6564502,623,203)
  {
   DSManager="parent.mdb"
   link(onExec,15485636:doEvent2,[(668,209)(668,244)(128,244)(128,118)])
  }
  Add(Label,14366544,224,70)
  {
   Left=240
   Top=78
   Width=220
   Font=[Courier New,10,3,16711680,204]
   Caption="Марка транспортного засобу."
   AutoSize=1
   Alignment=2
  }
END_SDK
Add(ChildGroupBox,10066168,378,252)
{
}
BEGIN_SDK
  Add(EditMulti,5782616,21,21)
  {
   EventCount=1
   WorkCount=1
   Width=671
   Height=256
   link(doWork1,6333756:doWork2,[(28,27)(28,111)])
  }
  Add(GroupBox,4126286,77,105)
  {
   Left=35
   Top=105
   Width=488
   Height=248
   Font=[MS Sans Serif,10,1,255,1]
   Visible=1
   Caption="ВИРОБНИКИ"
   Point(doVisible)
   Point(onShow)
   Point(onHide)
   link(onShow,8860037:doEvent1,[])
   link(onHide,776313:doWork1,[(116,118)(116,101)(165,101)])
  }
  Add(DSC_Query,16524017,168,112)
  {
   SQL="SELECT * FROM factory ORDER BY name;"
   DSManager="parent.mdb"
   link(onQuery,854081:doAdd,[])
  }
  Add(ListBox,854081,224,112)
  {
   Left=10
   Top=25
   Width=220
   Height=205
   Font=[Courier New,11,1,0,204]
   Point(onMouseDown)
   Point(String)
   Point(Data)
   link(onMouseDown,5978462:doEvent,[])
  }
  Add(Hub,8860037,140,105)
  {
   InCount=2
   link(onEvent1,776313:doWork2,[])
   link(onEvent2,16524017:doQuery,[])
  }
  Add(IndexToChanel,5978462,273,126)
  {
   link(onEvent2,8228912:doPopupHere,[])
  }
  Add(PopupMenuEx,8228912,322,133)
  {
   Menu=#11:Новий запис|10:Редагуавти|
   Bitmaps=[]
   link(MenuItemIdx,4751408:doEvent,[])
  }
  Add(IndexToChanel,4751408,371,133)
  {
   link(onEvent1,16183946:doData,[(413,139)(413,97)])
   link(onEvent2,9940701:doString,[])
  }
  Add(Memory,15005091,581,147)
  {
  }
  Add(MT_MultiData,10480676,532,140)
  {
   link(onData1,1385728:doText2,[])
   link(onData2,15005091:doValue,[])
  }
  Add(Edit,1385728,623,133)
  {
   Left=240
   Top=95
   Width=220
   Text=""
  }
  Add(Button,13802220,24,182)
  {
   Left=240
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ВIДМIНИТИ"
   Data=Integer(0)
   link(onClick,6333756:doWork3,[(74,188)])
  }
  Add(Button,2046142,535,203)
  {
   Left=358
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ЗБЕРЕГТИ"
   link(onClick,2126852:doString,[])
  }
  Add(FormatStr,9940701,427,140)
  {
   Mask="SELECT * FROM factory WHERE id=%1; "
   link(onFString,5670947:doWork2,[])
   link(Str1,854081:Data,[(433,129)(419,129)(419,170)(258,170)])
  }
  Add(DoData,16183946,427,91)
  {
   Data=String(SELECT "","NULL";)
   link(onEventData,5670947:doWork1,[(473,97)])
  }
  Add(DSC_Query,15359568,490,140)
  {
   DSManager="parent.mdb"
   link(onQuery,10480676:doSeparateMT,[])
  }
  Add(HubEx,5670947,469,140)
  {
   link(onEvent,15359568:doQuery,[])
  }
  Add(FormatStr,2126852,581,203)
  {
   Mask="INSERT OR REPLACE INTO factory VALUES("%2", %1);"
   link(onFString,1940061:doExec,[])
   link(Str1,15005091:Value,[])
   link(Str2,1385728:Text,[(594,184)(629,184)])
  }
  Add(HubEx,6333756,70,105)
  {
   link(onEvent,4126286:doVisible,[])
  }
  Add(HubEx,776313,161,105)
  {
   link(onEvent,854081:doClear,[(212,111)(212,125)])
  }
  Add(DSC_Exec,1940061,623,203)
  {
   DSManager="parent.mdb"
   link(onExec,8860037:doEvent2,[(668,209)(668,244)(128,244)(128,118)])
  }
  Add(Label,9960533,238,70)
  {
   Left=240
   Top=78
   Width=220
   Font=[Courier New,10,3,16711680,204]
   Caption="Виробник."
   AutoSize=1
   Alignment=2
  }
END_SDK
Add(ChildGroupBox,6811841,427,245)
{
}
BEGIN_SDK
  Add(EditMulti,3576524,21,21)
  {
   EventCount=1
   WorkCount=1
   Width=839
   Height=375
   link(doWork1,15067428:doWork2,[(28,27)(28,104)])
  }
  Add(GroupBox,11549701,77,98)
  {
   Left=35
   Top=105
   Width=635
   Height=248
   Font=[MS Sans Serif,10,1,255,1]
   Visible=1
   Caption="МОДЕЛ I"
   Point(doVisible)
   Point(onShow)
   Point(onHide)
   link(onShow,2835802:doEvent1,[])
   link(onHide,14187453:doEvent1,[(125,111)(125,179)])
  }
  Add(DSC_Query,6437574,343,210)
  {
   DSManager="parent.mdb"
   link(onQuery,11089856:doAdd,[])
  }
  Add(ListBox,11089856,399,210)
  {
   Left=200
   Top=30
   Width=150
   Height=205
   Font=[Courier New,11,1,0,204]
   Point(onMouseDown)
   Point(String)
   Point(Data)
   link(onMouseDown,11767092:doEvent,[])
  }
  Add(Hub,5507237,196,203)
  {
   InCount=3
   link(onEvent1,9670486:doWork2,[])
   link(onEvent2,8417352:doString,[])
  }
  Add(IndexToChanel,11767092,448,224)
  {
   link(onEvent2,2794595:doPopupHere,[])
  }
  Add(PopupMenuEx,2794595,497,231)
  {
   Menu=#11:Новий запис|10:Редагуавти|
   Bitmaps=[]
   link(MenuItemIdx,13707841:doEvent,[])
  }
  Add(IndexToChanel,13707841,546,231)
  {
   link(onEvent1,1959958:doData,[(588,237)(588,195)])
   link(onEvent2,6340165:doString,[])
  }
  Add(Memory,9630045,756,245)
  {
  }
  Add(MT_MultiData,9090491,707,238)
  {
   link(onData1,14237620:doText2,[])
   link(onData2,9630045:doValue,[])
  }
  Add(Edit,14237620,798,231)
  {
   Left=370
   Top=95
   Width=220
   Text=""
  }
  Add(Button,12256840,24,175)
  {
   Left=370
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ВIДМIНИТИ"
   Data=Integer(0)
   link(onClick,15067428:doWork3,[(74,181)])
  }
  Add(Button,3022511,710,336)
  {
   Left=488
   Top=205
   Width=100
   Font=[Courier New,11,1,0,204]
   Caption="ЗБЕРЕГТИ"
   link(onClick,16618174:doString,[])
  }
  Add(FormatStr,6340165,602,238)
  {
   Mask="SELECT * FROM model WHERE id=%1; "
   link(onFString,14965911:doWork2,[])
   link(Str1,11089856:Data,[(608,227)(594,227)(594,268)(433,268)])
  }
  Add(DoData,1959958,602,189)
  {
   Data=String(SELECT "","NULL";)
   link(onEventData,14965911:doWork1,[(648,195)])
  }
  Add(DSC_Query,13730976,665,238)
  {
   DSManager="parent.mdb"
   link(onQuery,9090491:doSeparateMT,[])
  }
  Add(HubEx,14965911,644,238)
  {
   link(onEvent,13730976:doQuery,[])
  }
  Add(FormatStr,16618174,756,336)
  {
   DataCount=4
   Mask="INSERT OR REPLACE INTO model VALUES("%2", %1,%3,%4);"
   link(onFString,4091218:doExec,[])
   link(Str1,9630045:Value,[])
   link(Str2,14237620:Text,[(769,282)(804,282)])
   link(Str3,13157638:Var,[])
   link(Str4,3815653:Var,[])
  }
  Add(HubEx,15067428,70,98)
  {
   link(onEvent,11549701:doVisible,[])
  }
  Add(HubEx,9670486,217,203)
  {
   link(onEvent,11089856:doClear,[(387,209)(387,223)])
  }
  Add(DSC_Exec,4091218,798,336)
  {
   DSManager="parent.mdb"
   link(onExec,5507237:doEvent3,[(844,342)(844,377)(184,377)(184,223)])
  }
  Add(Label,1306194,476,168)
  {
   Left=365
   Top=78
   Width=235
   Font=[Courier New,10,3,16711680,204]
   Caption="Модель транспортного засобу."
   AutoSize=1
   Alignment=2
  }
  Add(ComboBox,9542330,245,119)
  {
   Left=10
   Top=55
   Width=180
   Height=21
   ReadOnly=0
   Point(doAdd)
   Point(doClear)
   Point(Data)
   link(onClick,10305671:doWork1,[(284,125)])
  }
  Add(ComboBox,1068468,364,119)
  {
   Left=10
   Top=100
   Width=180
   Height=21
   ReadOnly=0
   Point(doAdd)
   Point(doClear)
   Point(Data)
   link(onClick,10305671:doWork2,[(411,125)(411,171)])
  }
  Add(Hub,2835802,133,98)
  {
   OutCount=5
   link(onEvent1,6820911:doWork2,[])
   link(onEvent2,9846004:doQuery,[(295,111)(295,125)])
   link(onEvent3,4766941:doWork2,[])
   link(onEvent4,4097902:doQuery,[])
   link(onEvent5,5507237:doEvent2,[(171,132)(171,216)])
  }
  Add(DSC_Query,4097902,182,119)
  {
   SQL="SELECT * FROM type ORDER BY type;"
   DSManager="parent.mdb"
   link(onQuery,9542330:doAdd,[])
  }
  Add(DSC_Query,9846004,301,119)
  {
   SQL="SELECT * FROM marka ORDER BY marka;"
   DSManager="parent.mdb"
   link(onQuery,1068468:doAdd,[])
  }
  Add(FormatStr,8417352,245,210)
  {
   Mask="SELECT * FROM model WHERE id_type=%1 AND id_marka=%2 ORDER BY model;"
   link(onFString,6437574:doQuery,[])
   link(Str1,10806242:Var2,[])
   link(Str2,1899563:Var1,[(258,163)])
  }
  Add(InfoTip,3049325,574,91)
  {
   Info=#13: model TEXT, |40: id INTEGER PRIMARY KEY,-- iдентифiкатор|42: id_marka INTEGER,  -- iдентифiкатор Марки|41: id_type INTEGER ); -- iдентифiкатор type|
   HAlign=0
   Width=246
   Height=74
   Margin=5
  }
  Add(Hub,14187453,133,175)
  {
   OutCount=3
   link(onEvent1,6820911:doWork3,[(158,181)])
   link(onEvent2,4766941:doWork3,[(165,188)])
   link(onEvent3,9670486:doWork1,[(221,195)])
  }
  Add(HubEx,6820911,154,98)
  {
   link(onEvent,1068468:doClear,[(424,104)(424,132)])
  }
  Add(HubEx,4766941,161,112)
  {
   link(onEvent,9542330:doClear,[(304,118)(304,132)])
  }
  Add(HubEx,10305671,280,165)
  {
   Angle=2
   link(onEvent,5507237:doEvent1,[(184,171)(184,209)])
  }
  Add(GetDataEx,1899563,364,158)
  {
   link(Data,1068468:Data,[])
  }
  Add(LineBreak,15850111,378,182)
  {
   Type=1
   link(Data,1899563:Var3,[(384,163)])
   Primary=[13157638,392,105]
  }
  Add(GetDataEx,10806242,245,154)
  {
   link(Data,9542330:Data,[])
  }
  Add(LineBreak,14020693,210,175)
  {
   Type=1
   link(Data,10806242:Var3,[(216,159)])
   Primary=[3815653,567,133]
  }
END_SDK

SELECT 1 From to1 WHERE текущие показания одометра - показания одометра последнего to1 >= периодичность to1 в км