Add(MainForm,2953706,21,105)
{
 Position=1
 Point(onClose)
 link(onCreate,6196915:doOpen,[])
 link(onClose,6196915:doClose,[])
}
Add(DS_SQLite,6196915,63,119)
{
 Name="mTest"
 FileName="SQLiteUtf8.db"
 link(onOpen,15337521:doEvent1,[])
}
Add(DSC_Exec,3859932,175,119)
{
 DSManager="mTest"
 link(onExec,12033996:doString,[])
 link(SQL,11047836:Text,[])
}
Add(StrList,11047836,175,77)
{
 Strings=#27:PRAGMA encoding = "UTF-8"; |32:CREATE TABLE IF NOT EXISTS test(|24: id INTEGER PRIMARY KEY,|11: fio TEXT);|1: |
}
Add(FormatStr,12033996,224,119)
{
 Mask="INSERT INTO test values (NULL, "Иванов Иван Иванович");"
 link(onFString,12463428:doCharset,[])
}
Add(Charset,12463428,266,119)
{
 Type=6
 link(onCharset,15836664:doExec,[])
}
Add(DSC_Exec,15836664,308,119)
{
 DSManager="mTest"
}
Add(Hub,15337521,133,119)
{
 link(onEvent1,3859932:doExec,[])
 link(onEvent2,13375599:doQuery,[(161,132)(161,188)])
}
Add(StringTable,710163,308,182)
{
 Left=10
 Top=65
 Width=355
 Height=185
 Columns=#5:id=50|25:Фамилия Имя Отчество=250 |
}
Add(DSC_Query,13375599,175,182)
{
 SQL="SELECT * FROM test;"
 DSManager="mTest"
 link(onQuery,14088101:doStr,[])
 link(onColumns,710163:doClear,[])
}
Add(Charset,3302655,266,182)
{
 Type=7
 link(onCharset,710163:doAdd,[])
}
Add(MT_String,14088101,224,182)
{
 link(onResult,3302655:doCharset,[])
}

Add(MainForm,2953706,21,105)
{
 Width=435
 Height=359
}
Add(Button,12431240,168,161)
{
 Left=25
 Top=25
 Width=355
 Height=30
 Caption="Получить данные с удаленного сервера"
 link(onClick,1711932:doOpen,[])
}
Add(DS_MySQL,1711932,259,161)
{
 Name="ytatest"
 Server="185.189.13.173"
 Username="yta"
 Password="yta"
 DBName="db_yta_test"
 link(onOpen,16728834:doQuery,[])
}
Add(DSC_Query,16728834,343,161)
{
 SQL="SELECT * FROM history_tsshp_4;"
 DSManager="ytatest"
 link(onQuery,746263:doEvent,[])
 link(onColumns,2063503:doMT_AddCols,[])
 link(onError,16612068:doMessage,[])
}
Add(StringTableMT,2063503,693,140)
{
 Left=30
 Top=70
 Width=350
 Height=230
 IconsCheck=[]
 MiscIcons=[]
 Icons=[]
 Point(doMT_Add)
 Point(doMT_AddCols)
}
Add(Message,16612068,427,175)
{
 Caption="Ошибка при запросе данных"
}
Add(Charset,15211377,588,161)
{
 Type=7
 link(onCharset,4690827:doEvent,[])
}
Add(MT_String,5857085,511,161)
{
 link(onResult,8206959:doEvent,[])
}
Add(Debug,746263,476,161)
{
 link(onEvent,5857085:doStr,[])
}
Add(Debug,8206959,560,161)
{
 link(onEvent,15211377:doCharset,[])
}
Add(Debug,4690827,637,161)
{
 link(onEvent,2063503:doAdd,[(657,167)(657,146)])
}

Add(FormatStr,15042645,126,133)
{
 DataCount=0
 Mask="SELECT ID, (SELECT Name FROM City WHERE City.ID = Gorod) AS Gorod, Adres, (SELECT Alko FROM AMinfo WHERE Object.ID = Object_ID) AS KPP,\r\n(SELECT Data_o_Gost FROM ser_egais WHERE ser_egais.Object_ID = Object.ID) AS GOST,\r\n(SELECT Data_o_Fsrar FROM ser_egais WHERE ser_egais.Object_ID = Object.ID) AS FSRAR\r\nFROM Object WHERE KPP LIKE '_________'  AND Stat = 'Действует' ORDER BY GOST"
 link(onFString,5568733:doCharset,[])
}
Add(Charset,5568733,175,133)
{
 Type=6
 link(onCharset,7753949:doQuery,[])
}
Add(DSC_Query,7753949,224,133)
{
 @Color=43520
 DSManager="parent.parent.bd"
 link(onQuery,12653439:doStr,[])
}
Add(MT_String,12653439,273,133)
{
 link(onResult,501211:doCharset,[])
}
Add(Charset,501211,322,133)
{
 Type=7
}