Add(MainForm,2953706,35,105) { Point(onClose) link(onCreate,11950164:doOpen,[]) link(onClose,11950164:doClose,[]) } Add(DS_SQLite,11950164,91,119) { Name="test" FileName="Gunnman.db" link(onOpen,10508021:doEvent1,[]) } Add(DSC_Exec,9745875,231,56) { SQL="CREATE TABLE IF NOT EXISTS user(\r\nuserid INTEGER PRIMARY KEY AUTOINCREMENT, \r\nusername TEXT);\r\n\r\nCREATE TABLE IF NOT EXISTS orders(\r\norderid integer primary key autoincrement, \r\niduser integer, \r\nforeign key(iduser) references user(userid));\r\n" DSManager="test" link(onExec,8283439:doQuery,[]) } Add(DSC_Query,9441597,231,126) { SQL="select orders.orderid,user.username from orders, user WHERE iduser=userid;" DSManager="test" link(onQuery,2208233:doStr,[]) link(onColumns,9187647:doEnum,[(282,139)(282,167)]) } Add(Hub,10508021,168,119) { link(onEvent1,9745875:doExec,[(206,125)(206,62)]) link(onEvent2,9441597:doQuery,[]) } Add(StringTable,13557538,357,126) { Left=10 Top=20 Width=360 Height=235 Point(doAddColumn) } Add(MT_String,2208233,301,126) { link(onResult,13557538:doAdd,[]) } Add(MT_Enum,9187647,301,161) { link(onItem,13557538:doAddColumn,[]) } Add(DSC_Query,8283439,301,56) { SQL="SELECT count() FROM user;" DSManager="test" link(onQuery,11787001:doCompare,[]) } Add(DSC_Exec,2952501,420,56) { SQL="insert into user values (NULL, 'Vasya');\r\ninsert into user values (NULL, 'Petya');\r\ninsert into user values (NULL, 'Kolya');\r\n\r\ninsert into orders values (NULL, 2);\r\ninsert into orders values (NULL, 1);\r\n" DSManager="test" } Add(If_else,11787001,357,56) { Op2=Integer(0) link(onTrue,2952501:doExec,[]) }