*Пример работы таблицы MTStrTbl совместно с источником данных SQLite Make(delphi) ver(4.03 build 180) 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(MST_DrawManager,11772580,140,56) { Name="mtst_draw" IconSize=24 GutterStyle=1 Gradient=0 GutterColor=16764622 } Add(IconsManager,16678351,196,56) { Name="icm" ImgSize=48 Icons=[] } 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(onEvent2,7272797:doQuery,[(122,55)(122,32)(37,32)(37,174)]) link(onEvent3,12956405:doQuery,[(122,62)(122,90)]) } Add(Stream2Hex,14428262,147,175) { Mode=1 link(onResult,15235028:doDeCompress,[]) } Add(BitmapStream,114989,245,168) { link(onRead,6357221:doEvent1,[]) } Add(Hub,6357221,294,168) { link(onEvent1,2848695:doLoadFromBitmap,[(318,174)(318,139)]) link(onEvent2,14005187:doAdd,[]) } Add(Icon,2848695,343,112) { Transparent=-16777201 Point(doTransparent) Point(doLoadFromBitmap) } Add(WorkIconsManager,14232421,329,70) { IconsManager="parent.icm" } Add(ArrayRW,14005187,329,161) { link(Array,14232421:IconArray,[]) link(Value,2848695:Icon,[]) } Add(ZLIB,15235028,196,168) { link(onStream,114989:doRead,[]) } Add(Icon,7925483,329,28) { @Hint=#5:#main| Icon=[ZIP5E07000078DA636060044209090610C9E0C1CEC020C6C0C0A001C4402106030688380828B033100D4E335001AC80214AC04EB00973C0E44EDCB64C0423823E5A81C3771093E780D144E25C85DFE37388F3F869BC86A031F0803B84DCB9938228A04A62B8438A62DE865568880C1BD97B777B5E7DA77CFD9FD9CD7FF9CFFEF73EFFE5B2EB2EA946010DE9F9FD2FF2D53F64733C0F3EE6987B9E24A34832E734EEF822D53DB83220D09CCD7FFE6DFBF6FFD8D7FF8F7EFE7BFD1B44AE7FF23966DF7DB83977602E5901CB17ADD8CCD9F5EE9BC19EBB82CB2F09CD3FADB0E8B4E9F2B36A93F64F3AF78454F7781DBD8BE92FB6A66D340D1F86A163CEC43FFF9A7EFCCFFFF1BFEADF7F207BC19F7FC9B7BEF22EBA42AA39FFFEFCF8F2FFFFE5FFFF81090088D6FEFF0F44406349CD1A3C930E00CD01269BE3601380EE99FDFB8F70EB7AF2B22A1A2252E3FFFAFF0CFFECFF33FC916F67F81BEF0EE41F07E2ED409CCFF0FFDF7F86FF7FFF33FC90FFCFF081FF3FC30376103E0FC4CF191EB031436830FF3F0606A907E90300AAF76098] } Add(MT_MultiData,3410574,98,168) { link(onData1,2848695:doTransparent,[(140,174)(140,132)]) link(onData2,14428262:doConvert,[]) } 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 ico,color,id AS №_80__1,name AS Имя_100__2,tel AS Телефон_100__2,adr AS Адрес___2 FROM "tab1";" DSManager="sqlite_1" link(onQuery,5392188:doAddRow,[]) link(onColumns,5392188:doAddCols,[]) } Add(DSC_Query,7272797,49,168) { SQL="SELECT MaskColor,hex(Image) FROM "Pictures" WHERE idx <= (SELECT MAX(idx) FROM "Pictures");" DSManager="sqlite_1" link(onQuery,3410574:doSeparateMT,[]) } Add(MST_DB,5392188,196,84) { MSTControl="parent.mtst" } 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,[]) } Add(DSC_Exec,11760390,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\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');" DSManager="sqlite_1" } 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" }