Вверх ↑
Ответов: 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] [290]