Вверх ↑
Ответов: 254
Рейтинг: 6
#1: 2014-01-10 21:36:09 ЛС | профиль | цитата
Tad, добрый вечер!!! не ругайтесь. Просто вчера все молчали и совета не у кого было спросить. Вообщем сам додумался методом перебора. Просто удалил файл базы и снова скомпилировал - все заработало.
code_32792.txt
------------ Дoбавленo в 19.47:
скажите в чем моя ошибка? Пытаюсь считать название ячейки по выбранной дате, но ничего не считывается

Add(MainForm,11607186,161,91)
{
 Width=954
 Height=667
 Caption="график вакцинации"
 BorderStyle=4
 Position=1
 Point(doVisible)
 Point(onClose)
 link(onCreate,7309284:doEvent1,[])
}
Add(MTStrTbl,15761846,861,651)
{
 @Color=5592575
 Left=280
 Top=50
 Width=570
 Height=215
 Name="график"
 Columns=#6:корпус|4:дата|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|
 Point(doVisible)
}
Add(Button,949453,84,609)
{
 Left=420
 Top=15
 Width=135
 TabOrder=-1
 Caption="рассчитать"
 link(onClick,11771530:doString,[])
}
Add(ComboBox,11406695,105,546)
{
 Left=300
 Top=15
 Width=110
 Height=21
 Strings=#8:корпус 1|8:корпус 2|8:корпус 3|8:корпус 4|8:корпус 5|
 Text="корпус"
 Point(EditText)
}
Add(MTStrTbl,5113738,532,378)
{
 @Color=43520
 Left=20
 Top=115
 Width=250
 Height=155
 Name="вакцинация"
 Columns=#14:ВАКЦИНАЦИЯ=150|17:ВОЗРАСТ (ДНИ)=100|
 Point(doSetFocus)
 Point(onSelect)
 Point(doVisible)
}
Add(Edit,16767801,140,329)
{
 Left=101
 Top=45
 Width=110
 Text="0"
 DataType=2
}
Add(Button,12084787,63,371)
{
 Left=15
 Top=70
 Width=195
 Height=30
 TabOrder=-1
 Caption="добавить"
 link(onClick,8126504:doString,[])
}
Add(ComboBox,4864849,98,315)
{
 Left=85
 Top=15
 Width=125
 Height=21
 Strings=#2:БМ|2:БГ|2:БН|3:ИБК|3:ИЛТ|
 Text="вакцинацияя"
 Point(EditText)
}
Add(DatePicker,9450650,147,462)
{
 Left=565
 Top=15
 Width=110
 Height=21
 Font=[MS Sans Serif,6,0,0,1]
 Point(doLeft)
 Point(doTop)
 Point(doSetFocus)
 Point(doBringToFront)
 Point(DateTime)
 Point(doSendToBack)
 link(OnChange,3123712:doEvent1,[])
}
Add(DS_SQLite,6991059,343,112)
{
 @Color=5636095
 Name="11"
 FileName="memory.db"
 Point(onError)
 link(onOpen,13846613:doExec,[(383,118)(383,97)])
 link(onError,7054140:doEvent2,[])
}
Add(Message,3808633,476,112)
{
}
Add(DSC_Exec,13846613,385,91)
{
 @Color=5636095
 SQL="CREATE TABLE IF NOT EXISTS [vakcina] (\r\n[id] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,\r\n[name] TEXT,\r\n[number] INTEGER);\r\n\r\nCREATE TABLE IF NOT EXISTS [grafikdata] (\r\n[id] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,\r\n[name] TEXT,\r\n[dtime] REAL);\r\n\r\nCREATE TABLE IF NOT EXISTS [grafikname] (\r\n[id] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,\r\n[name] TEXT,\r\n[ups] TEXT);"
 DSManager="11"
 link(onError,7054140:doEvent1,[(429,104)(429,118)])
}
Add(DSC_Exec,7884957,280,364)
{
 @Color=5636095
 DSManager="11"
 link(onExec,15277953:doEvent1,[])
 link(onError,14022728:doWork,[(317,377)(317,384)])
}
Add(FormatStr,8126504,133,371)
{
 Mask="INSERT INTO [vakcina] ([name], [number]) VALUES('%1', %2);  "
 link(onFString,15049159:doEvent2,[])
 link(Str1,4864849:String,[(139,366)(111,366)])
 link(Str2,16767801:Text,[])
}
Add(MST_DB,953009,490,378)
{
 @Color=43520
 MSTControl="вакцинация"
 Point(doClear)
}
Add(Hub,15277953,343,364)
{
 link(onEvent1,13439786:doEvent1,[(451,370)(451,398)])
 link(onEvent2,11511635:doQuery,[(364,377)(364,384)])
}
Add(DSC_Query,11511635,371,378)
{
 @Color=5636095
 SQL="SELECT [name], [number] from [vakcina]"
 DSManager="11"
 link(onQuery,953009:doAddRow,[])
 link(onError,12129855:doWork,[])
}
Add(LineBreakEx,14022728,322,378)
{
}
Add(LineBreakEx,8042414,399,126)
{
 Type=1
 link(OnEvent,7054140:doEvent3,[])
}
Add(LineBreakEx,12129855,413,392)
{
 Caption="1"
}
Add(DSC_Exec,12182020,266,602)
{
 @Color=5636095
 DSManager="11"
 link(onExec,10771421:doEvent1,[])
 link(onError,3606489:doWork,[(303,615)(303,622)])
}
Add(FormatStr,11771530,126,609)
{
 DataCount=3
 Mask="INSERT INTO [grafikdata] ([name], [dtime]) VALUES('%1', %2); \r\nINSERT INTO [grafikname] ([name], [ups]) VALUES('%1', %2); "
 link(onFString,14909773:doEvent2,[])
 link(Str1,11406695:String,[(132,600)(118,600)])
 link(Str2,16251723:Data1,[(139,597)(153,597)])
}
Add(MST_DB,10553212,861,609)
{
 @Color=5592575
 MSTControl="график"
 Point(doClearAll)
 Point(doClear)
}
Add(LineBreakEx,3606489,308,616)
{
}
Add(Hub,10771421,329,602)
{
 OutCount=5
 link(onEvent1,2288361:doEvent2,[(358,608)(358,588)])
 link(onEvent2,15451509:doData,[])
 link(onEvent3,12922371:doQuery,[(373,622)(373,648)(471,648)(471,629)])
 link(onEvent4,4614904:doQuery,[(357,629)(357,671)])
 link(onEvent5,16692340:doQuery,[(353,636)(353,853)])
}
Add(DSC_Query,4614904,364,665)
{
 @Color=5636095
 SQL="SELECT [name], strftime("%d.%m.%Y", 1721424.5 + [dtime]), [dtime] from [grafikdata]"
 DSManager="11"
 link(onQuery,13313127:doEvent1,[])
 link(onError,3923348:doWork,[])
}
Add(LineBreakEx,3923348,413,679)
{
}
Add(DSC_Query,12922371,483,623)
{
 @Color=5636095
 SQL="SELECT [name] from [vakcina]"
 DSManager="11"
 link(onQuery,9772768:doWork2,[(545,629)(545,622)])
 link(onError,4829472:doWork,[])
}
Add(LineBreakEx,4829472,532,637)
{
}
Add(DoData,15451509,385,609)
{
 Data=String(корпус)
 link(onEventData,3754311:doAdd,[])
}
Add(MT_Add,3754311,427,609)
{
 Data=String(вывод)
 link(onAdd,9772768:doWork1,[(578,615)])
}
Add(HubEx,9772768,574,616)
{
 link(onEvent,10498153:doEvent1,[])
}
Add(FormatStr,8156537,560,714)
{
 DataCount=1
 Mask="SELECT strftime("%d.%m.%Y", 1721424.5 + %1 + [number]) from [vakcina]"
 link(onFString,11422646:doQuery,[])
 link(Str1,15251959:Value3,[])
}
Add(DSC_Query,11422646,609,714)
{
 @Color=5636095
 DSManager="11"
 link(onQuery,10214565:doAdd,[])
 link(onError,6059374:doWork,[])
}
Add(LineBreakEx,6059374,651,728)
{
}
Add(MT_MultiMem,15251959,546,665)
{
 Count=3
}
Add(Hub,13313127,434,665)
{
 OutCount=4
 link(onEvent1,15251959:doValue,[])
 link(onEvent2,8156537:doString,[(536,678)(536,720)])
 link(onEvent3,10341187:doAdd,[(529,685)(529,769)])
 link(onEvent4,4303723:doClear,[(623,692)(623,727)])
}
Add(MT_Memory,4303723,735,714)
{
}
Add(MT_Add,10214565,679,714)
{
 InputMT=1
 link(onAdd,4303723:doValue,[])
 link(Data,15937933:Var3,[(685,698)(727,698)])
}
Add(MT_AddData,10341187,546,763)
{
 Count=3
 link(onAdd,10553212:doAddRow,[(774,769)(774,615)])
 link(Data1,15251959:Value1,[])
 link(Data2,15251959:Value2,[])
 link(Data3,15937933:Var1,[(566,754)])
}
Add(GetDataEx,15937933,721,749)
{
 Angle=1
 link(Data,4303723:Value,[(741,754)])
}
Add(Label,2084213,98,273)
{
 Left=15
 Top=15
 Width=64
 Height=17
 Caption="вакцинация"
}
Add(Label,6975909,140,273)
{
 Left=15
 Top=45
 Width=78
 Height=17
 Caption="возраст (дней)"
}
Add(Button,8086717,112,49)
{
 Left=865
 Top=80
 Width=65
 Height=25
 Hint="Сворачивает в трей"
 Caption="Свернуть"
 link(onClick,3126296:doEvent1,[])
}
Add(TrayIcon,6079368,273,42)
{
 Hint="софтинка"
 FormHook=0
 ShowWORemoveIcon=0
 Text="двойной клик - развернуть"
 link(onDblClick,11103182:doCase,[])
}
Add(Case,11103182,315,49)
{
 Value=Integer(0)
 link(onTrue,7275996:doEvent1,[])
}
Add(Hub,3126296,245,49)
{
 InCount=2
 OutCount=1
 link(onEvent1,6079368:doHide,[])
}
Add(ChanelToIndex,12581794,420,56)
{
 link(onIndex,11607186:doVisible,[(459,62)(459,28)(88,28)(88,125)])
}
Add(Hub,7275996,357,56)
{
 link(onEvent1,6079368:doShow,[(376,62)(376,34)(268,34)(268,48)])
 link(onEvent2,12581794:doWork2,[])
}
Add(Hub,7309284,210,105)
{
 OutCount=8
 link(onEvent1,3126296:doEvent2,[(238,111)(238,62)])
 link(onEvent2,6991059:doOpen,[])
 link(onEvent3,922736:doMTString,[(250,125)(250,146)])
 link(onEvent4,6668430:In,[(245,132)(245,174)])
 link(onEvent5,8909681:In,[(238,139)(238,188)])
 link(onEvent8,12328708:doMTString,[(242,160)(242,223)])
}
Add(Button,9281433,112,84)
{
 Left=865
 Top=50
 Width=65
 Height=25
 Caption="Закрыть"
 link(onClick,11607186:doClose,[(149,90)(149,118)])
}
Add(MT_String,922736,259,126)
{
 link(onResult,2904434:doRowAction,[])
}
Add(MST_RowAction,2904434,301,126)
{
 @Color=5592575
 MSTControl="график"
}
Add(Hub,7054140,441,112)
{
 InCount=3
 link(onEvent1,3808633:doMessage,[])
}
Add(Button,4038752,371,469)
{
 Left=20
 Top=310
 Width=195
 Height=35
 Caption="очистить"
 link(onClick,13172925:doEvent1,[])
}
Add(DSC_Exec,16152874,476,476)
{
 @Color=5636095
 SQL="delete from vakcina;\r\ndelete from grafikdata;\r\ndelete from grafikname;"
 DSManager="11"
}
Add(Hub,13172925,434,469)
{
 OutCount=5
 link(onEvent1,13439786:doEvent2,[(459,475)(459,405)])
 link(onEvent2,16152874:doExec,[])
 link(onEvent3,2288361:doEvent1,[(455,489)(455,581)])
}
Add(Hub,2288361,469,575)
{
 InCount=2
 link(onEvent1,10553212:doClearAll,[(672,581)(672,629)])
 link(onEvent2,3680842:doClearAll,[(672,588)(672,881)])
}
Add(Hub,13439786,462,392)
{
 InCount=2
 OutCount=1
 link(onEvent1,953009:doClear,[])
}
Add(Hub,14909773,238,602)
{
 InCount=2
 link(onEvent1,12182020:doExec,[])
}
Add(LineBreak,8716530,182,595)
{
 Caption="база1"
 link(Out,14909773:doEvent1,[(232,601)(232,608)])
 Primary=[6668430,77,-427]
}
Add(LineBreak,5442642,189,357)
{
 Caption="база 2"
 link(Out,15049159:doEvent1,[(244,363)(244,370)])
 Primary=[8909681,70,-175]
}
Add(Hub,15049159,252,364)
{
 InCount=2
 link(onEvent1,7884957:doExec,[])
}
Add(MT_String,12328708,259,203)
{
 link(onResult,7998381:doRowAction,[])
}
Add(MST_RowAction,7998381,301,203)
{
 @Color=22015
 MSTControl="график2"
}
Add(DSC_Query,16692340,364,847)
{
 @Color=5636095
 SQL="SELECT [name], strftime("%d.%m.%Y", 1721424.5 + [ups]), [ups] from [grafikname]"
 DSManager="11"
 link(onQuery,16307566:doEvent1,[])
 link(onError,15415209:doWork,[])
}
Add(LineBreakEx,15415209,413,861)
{
}
Add(FormatStr,13765,560,896)
{
 DataCount=1
 Mask="SELECT [name] from [vakcina]"
 link(onFString,1811127:doQuery,[])
 link(Str1,10671770:Value3,[])
}
Add(DSC_Query,1811127,609,896)
{
 @Color=5636095
 DSManager="11"
 link(onQuery,8548800:doAdd,[])
 link(onError,5022567:doWork,[])
}
Add(LineBreakEx,5022567,651,910)
{
}
Add(MT_MultiMem,10671770,546,847)
{
 Count=3
}
Add(Hub,16307566,434,847)
{
 OutCount=4
 link(onEvent1,10671770:doValue,[])
 link(onEvent2,13765:doString,[(536,860)(536,902)])
 link(onEvent3,3934086:doAdd,[(529,867)(529,951)])
 link(onEvent4,15669683:doClear,[(623,874)(623,909)])
}
Add(MT_Memory,15669683,735,896)
{
}
Add(MT_Add,8548800,679,896)
{
 InputMT=1
 link(onAdd,15669683:doValue,[])
 link(Data,7362554:Var3,[(685,880)(727,880)])
}
Add(MT_AddData,3934086,546,945)
{
 Count=3
 link(onAdd,1109619:doEvent1,[])
 link(Data1,10671770:Value1,[])
 link(Data2,10671770:Value2,[])
 link(Data3,7362554:Var1,[(566,936)])
}
Add(GetDataEx,7362554,721,931)
{
 Angle=1
 link(Data,15669683:Value,[(741,936)])
}
Add(MTStrTbl,5516318,861,903)
{
 @Color=43775
 Left=280
 Top=275
 Width=570
 Height=215
 Name="график2"
 Columns=#6:корпус|4:дата|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|
 Point(doVisible)
}
Add(MST_DB,3680842,861,861)
{
 @Color=43775
 MSTControl="график2"
 Point(doClearAll)
 Point(doClear)
}
Add(Hub,10498153,742,616)
{
 link(onEvent1,10553212:doAddCols,[])
 link(onEvent2,3680842:doAddCols,[(808,629)(808,874)])
}
Add(InfoTip,7056213,350,448)
{
 Info=#13:очистить базу|
 Font=[MS Sans Serif,9,1,0,1]
 Width=190
 Height=102
}
Add(GetData,16251723,147,553)
{
 Count=3
 link(Data,8155228:Var2,[])
}
Add(Hub,3123712,217,462)
{
 link(onEvent1,1729153:In,[])
}
Add(MST_FindText,10090767,308,1190)
{
 @Color=5592575
 MSTControl="график"
 link(onFindText,7050031:doEvent1,[])
}
Add(Button,15619008,105,1190)
{
 Left=40
 Top=510
 Width=90
 Height=30
 TabOrder=-1
 Caption="поиск"
 link(onClick,16858:doEvent1,[])
}
Add(MT_AddData,4099803,196,1190)
{
 Count=3
 link(onAdd,9984736:doEvent1,[])
 link(Data1,8582035:Var2,[])
 link(Data2,7145388:Value,[(209,1171)(167,1171)])
 link(Data3,472551:Value,[(216,1169)(223,1169)])
}
Add(Hub,7050031,357,1190)
{
 OutCount=3
 link(onEvent1,7882506:doWork3,[(378,1196)])
 link(onEvent3,7068082:doSeparateMT,[])
}
Add(MT_IndexToChanel,6486558,259,1190)
{
 Point(Index)
 link(onEvent1,10090767:doFindText,[])
 link(onEvent2,10090767:doFindNext,[])
 link(Index,11078412:Var2,[])
}
Add(Hub,16858,154,1190)
{
 OutCount=6
 link(onEvent1,4099803:doAdd,[])
 link(onEvent2,3924486:doData,[(196,1203)(196,1483)])
 link(onEvent3,10870178:doAdd,[(185,1210)(185,1532)])
 link(onEvent4,13333826:doString,[(175,1217)(175,1451)(611,1451)(611,1196)])
 link(onEvent5,259261:doString,[(296,1224)(296,1308)])
}
Add(DateConvertor,11211211,154,1078)
{
 Mode=9
 Format="dd.MM.yyyy"
 Point(Data)
 link(onResult,15313599:doValue,[])
 link(Data,16251723:Data2,[])
}
Add(Memory,15313599,196,1078)
{
 link(onData,15192790:doReset,[])
}
Add(FormatStr,13333826,616,1190)
{
 DataCount=5
 Mask="%1: запланирована вацинация %2 против %3 %4"
 link(onFString,16144821:doAdd,[])
 link(Str1,1421926:Value,[(622,1174)(594,1174)])
 link(Str2,14946120:Var2,[(629,1178)(631,1178)(631,1296)(475,1296)])
 link(Str3,436707:Value,[(636,1182)(650,1182)])
}
Add(MST_Matrix,16359836,336,1526)
{
 @Color=5592575
 MSTControl="график"
 link(onEMatrix,3972635:doEnum,[])
}
Add(MT_AddData,10870178,287,1526)
{
 link(onAdd,16359836:doEMatrix,[])
 link(Data1,14883245:Value,[])
 link(Data2,16288277:Value,[(300,1517)(328,1517)])
}
Add(MT_Enum,3972635,385,1526)
{
 link(onItem,1421926:doValue,[(719,1532)(719,1123)(574,1123)(574,1140)])
}
Add(DoData,3924486,245,1477)
{
 Data=String(Найти координаты следующего слова)
 link(onEventData,16288277:doValue,[])
}
Add(InfoTip,7388270,84,1001)
{
 Info=#27:Считывание данных с таблицы|23:и простановка данных в |14:текстовое поле|
 Font=[MS Sans Serif,9,1,0,1]
 Width=652
 Height=557
}
Add(Memory,1421926,588,1134)
{
}
Add(LineBreak,16018412,112,1078)
{
 Caption="1"
 link(Out,11211211:doConvert,[])
 Primary=[1729153,140,-616]
}
Add(Memory,7145388,161,1134)
{
 Default=Integer(0)
}
Add(Memory,472551,217,1134)
{
 Default=Integer(0)
}
Add(Switch,15192790,259,1071)
{
 DataOn=Integer(1)
 DataOff=Integer(0)
 Point(onOn)
 Point(State)
 Point(doOn)
}
Add(MT_MultiData,7068082,378,1204)
{
 Count=3
 link(onData1,4915844:doValue,[])
 link(onData2,8107948:doValue,[])
 link(onData3,15428477:doValue,[])
}
Add(Memory,15428477,469,1218)
{
 Default=Integer(0)
}
Add(Memory,14883245,287,1435)
{
 Default=Integer(0)
}
Add(Memory,16288277,322,1477)
{
 Default=Integer(0)
 Point(Data)
 link(Data,10335965:Var1,[(328,1343)])
}
Add(RichEdit,16144821,665,1190)
{
 Left=140
 Top=510
 Width=235
 Height=115
}
Add(Memory,8107948,518,1211)
{
}
Add(Memory,4915844,567,1204)
{
}
Add(Hub,1109619,609,945)
{
 link(onEvent1,3680842:doAddRow,[(742,951)(742,867)])
}
Add(GetDataEx,10335965,567,1338)
{
 link(Data,4915844:Value,[])
}
Add(Hub,9984736,231,1190)
{
 link(onEvent1,6486558:doEvent,[])
}
Add(GetDataEx,11078412,259,1162)
{
 link(Data,15192790:State,[])
}
Add(HubEx,7882506,374,1162)
{
 Angle=3
 link(onEvent,15192790:doOn,[(378,1065)(250,1065)(250,1091)])
}
Add(GetDataEx,8582035,196,1113)
{
 link(Data,15313599:Value,[])
}
Add(GetDataEx,8155228,147,532)
{
 link(Data,9450650:DateTime,[])
}
Add(DSC_Query,6976485,483,1302)
{
 @Color=5636095
 DSManager="11"
 link(onQuery,466251:doText,[])
}
Add(FormatStr,259261,425,1302)
{
 DataCount=1
 Mask="SELECT [grafikdata].[name]||'('||[vakcina].[name]||')' FROM [grafikdata], [vakcina] WHERE [grafikdata].[dtime]+[vakcina].[number] = %1; "
 link(onFString,6976485:doQuery,[])
 link(Str1,14946120:Var1,[(431,1272)])
}
Add(GetDataEx,14946120,469,1267)
{
 link(Data,15428477:Value,[])
}
Add(Memory,436707,644,1141)
{
 Default=String()
}
Add(Label,466251,532,1302)
{
 Left=395
 Top=517
 link(onClick,436707:doValue,[(579,1308)(579,1147)])
}



именно вот этот кусок кода

Add(GetDataEx,10335965,567,1338)
{
}
Add(DSC_Query,6976485,483,1302)
{
 @Color=5636095
 DSManager="11"
 link(onQuery,466251:doText,[])
}
Add(FormatStr,259261,425,1302)
{
 DataCount=1
 Mask="SELECT [grafikdata].[name]||'('||[vakcina].[name]||')' FROM [grafikdata], [vakcina] WHERE [grafikdata].[dtime]+[vakcina].[number] = %1; "
 link(onFString,6976485:doQuery,[])
 link(Str1,14946120:Var1,[(431,1272)])
}
Add(GetDataEx,14946120,469,1267)
{
}
Add(Label,466251,532,1302)
{
 Left=395
 Top=517
}



------------ Дoбавленo в 21.36:
ау.... почему все молчат?
карма: 0

0
файлы: 1code_32792.txt [10.9KB] [328]