Add(MainForm,14842589,140,140)
{
 Left=20
 Top=105
 Width=390
 Height=302
 Caption="MTStrTbl_with_dbSQLite"
 Position=1
 link(onCreate,12397080:dbRead,[])
}
Add(MTStrTbl,3870454,140,98)
{
 Width=364
 Height=268
 Align=5
 Name="mtst"
 NIdxIcon=0
 NColorRow=4
 FlatScroll=1
 ColDelimiter="_"
 ColumnClick=1
 ColorItems=0
 Grid=0
 SmallIconsManager="icm"
 DrawManager="mtst_draw"
 link(onColumnClick,11980953:doSort,[])
}
Add(MST_SortInCol,11980953,196,105)
{
 MSTControl="mtst"
}
Add(MultiElementEx,12397080,196,154)
{
 @Hint=#14:Read db SQLite|
}
BEGIN_SDK
  Add(EditMultiEx,11993176,21,21)
  {
   WorkCount=#6:dbRead|
   Width=370
   Height=116
   link(dbRead,944731:doOpen,[(28,27)(28,48)])
  }
  Add(SQLite_Query,3749409,133,84)
  {
   SQL="SELECT\r\n  id   AS №_80__2,\r\n  name AS Имя_100__2,\r\n  tel  AS Телефон_100__2,\r\n  adr  AS Адрес___2,\r\n  color\r\nFROM\r\n  tab1"
   link(onQuery,15833769:doAddRow,[])
   link(onColumns,15833769:doAddCols,[])
  }
  Add(SQLite_DB,944731,49,42)
  {
   FileName="test.db"
   link(onOpen,4835456:doEvent1,[])
  }
  Add(Hub,4835456,98,42)
  {
   OutCount=3
   link(onEvent1,12802115:doExec,[])
   link(onEvent3,3749409:doQuery,[(122,62)(122,90)])
  }
  Add(SQLite_Exec,12802115,133,42)
  {
   SQL="CREATE TABLE tab1 (\r\nid INTEGER  PRIMARY KEY AUTOINCREMENT NULL,\r\nico INTEGER  NULL,\r\ncolor TEXT  NULL,\r\nname TEXT  NULL,\r\ntel TEXT  NULL,\r\nadr TEXT  NULL\r\n);\r\nINSERT INTO "tab1" VALUES(1,0,'33549508','Пупкин Николай Владимирович','2123456','Москва');\r\nINSERT INTO "tab1" VALUES(2,1,'46851327','Витя','+79283052877','Киев');\r\nINSERT INTO "tab1" VALUES(3,1,'64148223','Оля','+79658348877','Орел');\r\nINSERT INTO "tab1" VALUES(4,1,'83881156','Олег','+79255679017','Москва');\r\nINSERT INTO "tab1" VALUES(5,1,'97182975','Тимофей','+79023174133','Москва');\r\nINSERT INTO "tab1" VALUES(6,0,'114479871','Виктор','567432','Брянск');\r\nINSERT INTO "tab1" VALUES(7,0,'134212804','Валентин','908070','Киев');\r\nINSERT INTO "tab1" VALUES(8,1,'0','Вячеслав','+79256173445','Москва');\r\nINSERT INTO "tab1" VALUES(9,1,'164811519','Леонид','+79333790876','Москва');\r\nINSERT INTO "tab1" VALUES(10,0,'218098884','Григорий','890890','Мурманск');\r\nINSERT INTO "tab1" VALUES(11,1,'0','Григорий','+79563777654','Уфа');\r\nINSERT INTO "tab1" VALUES(12,0,'0','nesco','461594','Сочи');\r\nDELETE FROM sqlite_sequence;\r\nINSERT INTO "sqlite_sequence" VALUES('tab1',12);\r\nCREATE TABLE Pictures (\r\nidx INTEGER  NULL,\r\nMaskColor INTEGER  NULL, \r\nImage BLOB  NULL\r\n);\r\nINSERT INTO "Pictures" VALUES(1,13036287,x'3608000078DAED54A18E834010BD73C89395873BE49826AB484E20486E71C8B52B11084210FC000ED50F21A9C156F23B2B7B3CA6DBDDD236D79A53E565030BFBDEBCD919F6FB671BBC2DD7761E5FF3F83C8DF7B70FFE70FAEE5FFBF68535863C080F9B201CF2217F9EDB511A092D349E9E5599441096F2D81E5B2800A54CA3C754E09A92B102DBF101A3A07BD8A4D13D95214F234A9A82B94D31094A4AE96B703E411884D72A786F147381499412C0FD5243684A58A523D64064CE983156888C08AC60D45A01F950C2F9EC5B97B1CF36AA298C2A2525437ECDB7F91C36E03B7653806D9451D01CABA6807FDC6FF18DF2F9708B68886CF5E0134A4D51CF3A6B15C7179AF3C470D9C03F3FC51A7C910DF958ADF9886A77D945861FAE0873C76AACE24C64629E5915A38210FB5FCAA6001C177E305FD665B1867FACB233A88D55293B4205F1C5B9E60A087D8E9DC1773C339B22CE6A891500FA80BBA794960D4DDB8570C4EFC1826FACE33763D51125B6FB7AEA0873C4F5B3B02AF03D8FCC75373ACE756F4FAD64B0EBDBC05EF0DEA491513E1B35AF4F0AB5F4EBEF03D59C441A4DE2F2CFEBC9EED4EEECA35E746C958D1A726477EFBF8783A5BE1A3E76B4A35A5AF484BFF5AF53A727C0A85833AC079C648F9F7CACE2E3F9D3F385FFC62F124F4E91');\r\nINSERT INTO "Pictures" VALUES(2,13036287,x'3608000078DAA594318B134114C7CFE22012948D558A14A698E0E41CCE31971C63D85D98930DACB8C50A2906DCC62207737A42CA2BAC57121BA31F2290F2B87C82B372ED56BC0F60206836D86CC0C67DB913AF50C9CBCD9FA9667FFFFF0EF3DE938F1BB98DE56A64FB4EB66F5FEC6B1BC6F9C1C5F9E5357EF57719F2B7FEF5C5FF6448CD28A99249295776A96691C0F13DCE9DAE376E07FA4CED386FF8F53225A3FAEAE9861CF8867CAA83A5EC8EDDD9712859F52E86E40EF027EDD3E2DCBC257F06E0902B63F94510893E77E9013B2D9E290C3FF08FDBDC590407AC203F89F77E8F8FDB18FEB87DCE8FEA7D4E09FC032E3F56C0A7012585EC25DFF994E0F263152BDF4DB3FB6B962B47C2A55F149E8FD5A8EEBB8909F927A8FC3400875869A6D9A43437FB7C11E07850AC12132A3912947C56787EDBFA4AF28D9948CCC48C517CF119F02FACD66E6B37B45FEF55ED1B0F703C3878D67E33736886F6B0C5D6E06732DCEB342B4B87BB285E7480FF2E87ADD0AED4C021DFC0F1A293061FAD6F8F86ADFD2638E4EFE3F9C89A3D0187CDAD4A6DCA31BCD2C03F6F546B6176F7CAF6E6162E5F69A5D3C090A37A8F4762CAA6ECAD87E18F0E8187BAE97143266624BA1EAE7FA0062301F5CB1DDFED7A031F977F7408DDF7C7C1902E5D7DFE42DFC3ECA704A6BF663DBE3A0DF2DD49E961EE6619475D16F0F74862AECBBBF443F125E3CEBA3CBCDADC1CF857C9FF7105DE9085955EFB17FAEA2378');"
  }
  Add(Icon,7925483,329,28)
  {
   @Hint=#5:#main|
   Icon=[ZIP5E07000078DA636060044209090610C9E0C1CEC020C6C0C0A001C4402106030688380828B033100D4E335001AC80214AC04EB00973C0E44EDCB64C0423823E5A81C3771093E780D144E25C85DFE37388F3F869BC86A031F0803B84DCB9938228A04A62B8438A62DE865568880C1BD97B777B5E7DA77CFD9FD9CD7FF9CFFEF73EFFE5B2EB2EA946010DE9F9FD2FF2D53F64733C0F3EE6987B9E24A34832E734EEF822D53DB83220D09CCD7FFE6DFBF6FFD8D7FF8F7EFE7BFD1B44AE7FF23966DF7DB83977602E5901CB17ADD8CCD9F5EE9BC19EBB82CB2F09CD3FADB0E8B4E9F2B36A93F64F3AF78454F7781DBD8BE92FB6A66D340D1F86A163CEC43FFF9A7EFCCFFFF1BFEADF7F207BC19F7FC9B7BEF22EBA42AA39FFFEFCF8F2FFFFE5FFFF81090088D6FEFF0F44406349CD1A3C930E00CD01269BE3601380EE99FDFB8F70EB7AF2B22A1A2252E3FFFAFF0CFFECFF33FC916F67F81BEF0EE41F07E2ED409CCFF0FFDF7F86FF7FFF33FC90FFCFF081FF3FC30376103E0FC4CF191EB031436830FF3F0606A907E90300AAF76098]
  }
  Add(MST_DB,15833769,196,84)
  {
   MSTControl="parent.mtst"
  }
END_SDK