*Пример работы таблицы StringTableMT совместно с базой данных SQLite Make(delphi) ver(4.03 build 180) Add(MainForm,14842589,196,119) { Left=20 Top=105 Width=319 Height=302 Caption="Example" Position=1 link(onCreate,10863010:doOpen,[]) } Add(StringTableMT,11790623,385,126) { Width=392 Height=276 Align=5 ColumnClick=1 AllMT_AddCol=1 Flat=1 TableWBreak=0 Grid=0 ColorItems=0 ImgSize=48 AssignedIList=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doAddColumn) Point(doSort) Point(onColumnClick) Point(doMT_Add) Point(doMT_AddCols) link(onColumnClick,11790623:doSort,[(429,139)(429,157)(373,157)(373,174)]) } Add(SQLite_Query,9823334,329,175) { SQL="Select ico, color, id AS id_30__2, name AS name_100__2, tel, adr from tab1" link(onQuery,11790623:doMT_Add,[]) link(onColumns,11790623:doMT_AddCols,[]) } Add(SQLite_DB,10863010,245,133) { FileName="test.db" link(onOpen,4835456:doEvent1,[]) } Add(Hub,4835456,294,133) { link(onEvent1,15522512:doExec,[]) link(onEvent2,9823334:doQuery,[(318,146)(318,181)]) } Add(SQLite_Exec,15522512,329,133) { SQL="BEGIN TRANSACTION;\r\nCREATE 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,'1#16772292','Пупкин Николай Владимирович','2123456','Москва');\r\nINSERT INTO "tab1" VALUES(2,1,'2#13296895','Витя','+79283052877','Киев');\r\nINSERT INTO "tab1" VALUES(3,1,'3#13816575','Оля','+79658348877','Орел');\r\nINSERT INTO "tab1" VALUES(4,1,'4#16772292','Олег','+79255679017','Москва');\r\nINSERT INTO "tab1" VALUES(5,1,'5#13296895','Тимофей','+79023174133','Москва');\r\nINSERT INTO "tab1" VALUES(6,0,'6#13816575','Виктор','567432','Брянск');\r\nINSERT INTO "tab1" VALUES(7,0,'7#16772292','Валентин','908070','Киев');\r\nINSERT INTO "tab1" VALUES(8,1,'#','Вячеслав','+79256173445','Москва');\r\nINSERT INTO "tab1" VALUES(9,1,'9#13816575','Леонид','+79333790876','Москва');\r\nINSERT INTO "tab1" VALUES(10,0,'10#16772292','Григорий','890890','Мурманск');\r\nINSERT INTO "tab1" VALUES(11,1,'#','Григорий','+79563777654','Уфа');\r\nINSERT INTO "tab1" VALUES(12,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');\r\nCOMMIT;" }