Add(MainForm,14842589,140,189)
{
 Left=20
 Top=105
 Width=390
 Height=322
 Caption="SQLite_with_SQLiteDataSource"
 Position=1
 link(onCreate,12397080:dbRead,[])
}
Add(MTStrTbl,3870454,140,98)
{
 Width=382
 Height=263
 Align=2
 Name="mtst"
 Layout="vert_1"
 HeightScale=100
 NIdxIcon=0
 NColorRow=1
 FlatScroll=1
 ColDelimiter="_"
 ColumnClick=1
 ColorItems=0
 Grid=0
 SmallIconsManager="icm"
 DrawManager="mtst_draw"
 link(onClick,14726324:doData,[(180,104)(180,94)(135,94)(135,153)])
 link(onColumnClick,11980953:doSort,[])
}
Add(MST_SortInCol,11980953,196,105)
{
 MSTControl="mtst"
}
Add(MultiElementEx,12397080,196,203)
{
 @Hint=#14:Read db SQLite|
 link(onQuery,14744427:doText,[])
}
BEGIN_SDK
  Add(EditMultiEx,11993176,21,21)
  {
   WorkCount=#6:dbRead|8:doSelect|
   EventCount=#7:onQuery|
   Width=370
   Height=235
   link(dbRead,7707573:doOpen,[(31,27)(31,48)])
   link(doSelect,12509489:doString,[(26,34)(26,216)])
  }
  Add(Hub,4835456,98,42)
  {
   OutCount=3
   link(onEvent1,11760390:doExec,[])
   link(onEvent3,12956405:doQuery,[(122,62)(122,90)])
  }
  Add(DS_SQLite,7707573,49,42)
  {
   Name="sqlite_1"
   FileName="test.db"
   WaitClose=0
   link(onOpen,4835456:doEvent1,[])
  }
  Add(DSC_Query,12956405,133,84)
  {
   SQL="SELECT id AS №,name AS Имя,tel AS Телефон,adr AS Адрес FROM "tab1";"
   DSManager="sqlite_1"
   link(onQuery,5392188:doAddRow,[])
   link(onColumns,5392188:doAddCols,[])
  }
  Add(MST_DB,5392188,196,84)
  {
   MSTControl="parent.mtst"
  }
  Add(DSC_Exec,11760390,133,42)
  {
   SQL="CREATE TABLE tab1 (\r\nid INTEGER  PRIMARY KEY AUTOINCREMENT,\r\nname TEXT,\r\ntel TEXT,\r\nadr TEXT);\r\nINSERT INTO "tab1" VALUES(1,'Пупкин Николай Владимирович','2123456','Москва');\r\nINSERT INTO "tab1" VALUES(2,'Витя','+79283052877','Киев');\r\nINSERT INTO "tab1" VALUES(3,'Оля','+79658348877','Орел');\r\nINSERT INTO "tab1" VALUES(4,'Олег','+79255679017','Москва');\r\nINSERT INTO "tab1" VALUES(5,'Тимофей','+79023174133','Москва');\r\nINSERT INTO "tab1" VALUES(6,'Виктор','567432','Брянск');\r\nINSERT INTO "tab1" VALUES(7,'Валентин','908070','Киев');\r\nINSERT INTO "tab1" VALUES(8,'Вячеслав','+79256173445','Москва');\r\nINSERT INTO "tab1" VALUES(9,'Леонид','+79333790876','Москва');\r\nINSERT INTO "tab1" VALUES(10,'Григорий','890890','Мурманск');\r\nINSERT INTO "tab1" VALUES(11,'Григорий','+79563777654','Уфа');\r\nINSERT INTO "tab1" VALUES(12,'nesco','461594','Сочи');"
   DSManager="sqlite_1"
  }
  Add(DSC_QueryScalar,11859715,98,210)
  {
   DSManager="sqlite_1"
   link(onQuery,11993176:onQuery,[(382,216)(382,27)])
  }
  Add(FormatStr,12509489,49,210)
  {
   DataCount=1
   Mask="SELECT "name" FROM "tab1" WHERE id = %1 +1"
   link(onFString,11859715:doQuery,[])
  }
END_SDK
Add(Edit,14744427,245,203)
{
 Top=265
 Width=382
 Color=12639424
 Font=[MS Sans Serif,8,1,8388608,1]
 Layout="vert_1"
 Text=""
}
Add(DoData,14726324,147,147)
{
 link(onEventData,12397080:doSelect,[(187,153)(187,216)])
 link(Data,3870454:Index,[])
}
Add(VBoxLayout,905065,196,147)
{
 Name="vert_1"
}