*Пример работы таблицы MTStrTbl совместно с базой данных SQLite Make(delphi) ver(4.03 build 180) Add(MainForm,14842589,140,140) { Left=20 Top=105 Width=777 Height=630 Caption="MTStrTbl_with_dbSQLite_&_HTML" BorderStyle=1 Position=1 link(onCreate,12397080:dbRead,[]) } Add(MTStrTbl,3870454,140,98) { Width=382 Height=268 Name="mtst" Columns=#8:№=80==2,|11:Имя=100==2,|15:Телефон=100==2,|9:Адрес===2| NIdxIcon=1 NColorRow=2 FlatScroll=1 ColumnClick=1 ColorItems=0 Grid=0 SmallIconsManager="icm" DrawManager="mtst_draw" 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,154) { @Hint=#14:Read db SQLite| } BEGIN_SDK Add(EditMultiEx,11993176,21,21) { WorkCount=#6:dbRead| Width=398 Height=221 link(dbRead,944731:doOpen,[(28,27)(28,48)]) } Add(SQLite_Query,3749409,133,84) { SQL="SELECT * FROM tab1" link(onQuery,15833769:doAddRow,[]) } 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(onEvent2,4515520:doQuery,[(122,55)(122,33)(35,33)(35,188)]) link(onEvent3,3749409:doQuery,[(122,62)(122,90)]) } Add(Stream2Hex,14428262,147,189) { Mode=1 link(onResult,15235028:doDeCompress,[]) } Add(BitmapStream,114989,245,182) { link(onRead,6357221:doEvent1,[]) } Add(Hub,6357221,294,182) { link(onEvent1,2848695:doLoadFromBitmap,[(318,188)(318,153)]) link(onEvent2,14005187:doAdd,[]) } Add(Icon,2848695,343,126) { Transparent=-16777201 Point(doTransparent) Point(doLoadFromBitmap) } Add(WorkIconsManager,14232421,329,84) { IconsManager="parent.icm" } Add(ArrayRW,14005187,329,175) { link(Array,14232421:IconArray,[]) link(Value,2848695:Icon,[]) } 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\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(SQLite_Query,4515520,49,182) { SQL="SELECT\r\n MaskColor,\r\n hex(Image)\r\nFROM\r\n Pictures\r\nWHERE\r\n idx <= (SELECT MAX(idx) FROM Pictures)" link(onQuery,3410574:doSeparateMT,[]) link(dbHandle,944731:dbHandle,[]) } Add(ZLIB,15235028,196,182) { link(onStream,114989:doRead,[]) } Add(Icon,7925483,329,42) { @Hint=#5:#main| Icon=[ZIP5E07000078DA636060044209090610C9E0C1CEC020C6C0C0A001C4402106030688380828B033100D4E335001AC80214AC04EB00973C0E44EDCB64C0423823E5A81C3771093E780D144E25C85DFE37388F3F869BC86A031F0803B84DCB9938228A04A62B8438A62DE865568880C1BD97B777B5E7DA77CFD9FD9CD7FF9CFFEF73EFFE5B2EB2EA946010DE9F9FD2FF2D53F64733C0F3EE6987B9E24A34832E734EEF822D53DB83220D09CCD7FFE6DFBF6FFD8D7FF8F7EFE7BFD1B44AE7FF23966DF7DB83977602E5901CB17ADD8CCD9F5EE9BC19EBB82CB2F09CD3FADB0E8B4E9F2B36A93F64F3AF78454F7781DBD8BE92FB6A66D340D1F86A163CEC43FFF9A7EFCCFFFF1BFEADF7F207BC19F7FC9B7BEF22EBA42AA39FFFEFCF8F2FFFFE5FFFF81090088D6FEFF0F44406349CD1A3C930E00CD01269BE3601380EE99FDFB8F70EB7AF2B22A1A2252E3FFFAFF0CFFECFF33FC916F67F81BEF0EE41F07E2ED409CCFF0FFDF7F86FF7FFF33FC90FFCFF081FF3FC30376103E0FC4CF191EB031436830FF3F0606A907E90300AAF76098] } Add(MT_MultiData,3410574,98,182) { link(onData1,2848695:doTransparent,[(140,188)(140,146)]) link(onData2,14428262:doConvert,[]) } Add(MST_DB,15833769,196,84) { MSTControl="parent.mtst" } Add(SQLite_Query,5910801,371,175) { 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 ico,\r\n color\r\nFROM\r\n tab1" } END_SDK Add(WebBrowser,2323487,280,175) { Top=302 Width=416 Height=290 Point(doFromText) } Add(Button,15820049,140,203) { Left=340 Top=275 Width=90 Font=[MS Sans Serif,8,1,0,1] TabOrder=-1 Caption="To HTML" link(onClick,10665518:doTabToHTML,[]) } Add(MST_HTML,10665518,196,203) { TitleText="Таблица клиентов" TitleFont=[Verdana,11,1,0,204] TitleBorderWeight=2 TitleBackColor=65535 TitlePadTop=10 TitlePadBottom=10 HeadFont=[MS Sans Serif,8,1,0,1] HeadBackColor=15780518 HeadPadTop=4 HeadPadBottom=4 NoteText="-- Сделано в HiAsm --" NoteFont=[Verdana,11,3,8388608,204] NoteBorderWeight=2 NoteBackColor=10801663 NotePadTop=10 NotePadBottom=10 MSTControl="mtst" link(onTabToHTML,8880904:doEvent1,[]) } Add(Memo,7046175,280,231) { Left=385 Width=382 Height=268 Font=[Courier New,8,0,0,0] ScrollBars=3 } Add(Hub,8880904,245,203) { link(onEvent1,2323487:doFromText,[]) link(onEvent2,7046175:doText,[(269,216)(269,258)]) }