Спасибо, но немного не то. Решил подсмотреть в одной схеме код и меня он устроил. Старался переделать как там, но чет не заработало )
По идее после того как данные из Edit попали в компонент (Format..не знаю как называется ) c запросом на обновление данных, то данные должны были обновится, вот только этого не произошло.
В последний раз укажите пожалуйста на ошибку и все, больше не побеспокою ) Спасибо)
Add(ChildForm,9467718,546,98)
{
FirstUsage=0
}
BEGIN_SDK
Add(EditMulti,2379941,-35,-7)
{
EventCount=6
WorkCount=1
DataCount=1
VarCount=2
Width=1329
Height=823
link(doWork1,14021805:doShowModal,[(21,-1)(21,237)])
link(Var2,13311944:Var1,[(-22,82)])
}
Add(MainForm,14021805,154,203)
{
Left=35
Top=100
Width=376
Height=320
Visible=1
Point(onClose)
Point(doShowModal)
link(onActivate,11585841:doEvent1,[(250,209)(250,139)])
link(onCreate,15049992:doOpen,[])
link(onClose,15049992:doClose,[])
}
Add(Edit,8193515,609,238)
{
Left=65
Top=160
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(Edit,4896915,567,294)
{
Left=65
Top=190
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(Edit,7707199,581,336)
{
Left=65
Top=220
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(Label,3448287,1184,371)
{
Left=5
Top=10
Width=55
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Фамилия"
}
Add(Label,12074310,1182,420)
{
Left=5
Top=40
Width=28
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Имя"
}
Add(Label,16429677,1182,462)
{
Left=5
Top=100
Width=40
Height=19
Font=[Times New Roman,10,1,0,204]
Caption="Логин"
}
Add(Label,4932833,1183,511)
{
Left=5
Top=70
Width=55
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Отчество"
}
Add(Label,1072301,1176,553)
{
Left=15
Top=135
Width=4
Height=4
Font=[Times New Roman,10,0,0,204]
Caption=""
}
Add(Label,11865404,1183,595)
{
Left=5
Top=130
Width=53
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Телефон"
}
Add(Label,3469290,1183,679)
{
Left=5
Top=160
Width=45
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Диллер"
}
Add(Label,1739345,1187,641)
{
Left=5
Top=190
Width=32
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Email"
}
Add(Button,13679188,63,245)
{
Left=240
Top=45
Width=85
Height=35
Caption="ОТМЕНА"
link(onClick,13117481:doEvent1,[(111,251)(111,293)])
}
Add(Edit,8947271,511,35)
{
Left=65
Top=10
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
Point(doSetFocus)
link(onChange,15997396:doWork1,[(569,41)(569,139)(408,139)(408,237)])
}
Add(DS_SQLite,15049992,203,217)
{
Name="mdb"
FileName="C:\SOFT\mydbase.db"
WaitClose=0
link(onOpen,7388849:doWork3,[(508,223)])
}
Add(Hub,13117481,126,287)
{
InCount=3
link(onEvent1,14021805:doClose,[(147,293)(147,230)])
}
Add(Edit,9848688,526,151)
{
Left=65
Top=100
Width=160
Font=[Times New Roman,10,0,0,204]
Enabled=1
Text=""
Point(doSetFocus)
}
Add(Edit,11868430,519,95)
{
Left=65
Top=40
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(Edit,6824894,543,186)
{
Left=65
Top=70
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(Edit,8358532,550,228)
{
Left=65
Top=130
Width=160
Font=[Times New Roman,10,0,0,204]
Text=""
}
Add(DSC_Exec,1263187,785,693)
{
DSManager="parent.mdb"
}
Add(GetDataEx,13311944,511,77)
{
link(Data,8947271:Text,[])
}
Add(Hub,11585841,315,133)
{
OutCount=3
link(onEvent1,5259777:doEvent1,[(395,139)(395,48)])
link(onEvent3,7388849:doWork2,[(343,153)(343,90)])
}
Add(Hub,5259777,413,42)
{
link(onEvent1,8947271:doText,[(445,48)(445,41)])
link(onEvent2,8947271:doSetFocus,[])
}
Add(MultiElement,15997396,420,231)
{
link(onEvent1,9848688:doText,[(459,237)(459,157)])
}
BEGIN_SDK
Add(EditMulti,12137061,42,49)
{
EventCount=1
WorkCount=1
DataCount=1
Width=1549
Height=60
VOffset=21
HOffset=21
link(doWork1,7056492:doModify,[])
}
Add(Replace,11439842,112,70)
{
SubStr="а"
DestStr="a"
link(onReplace,530333:doReplace,[])
}
Add(Replace,530333,154,70)
{
SubStr="б"
DestStr="b"
link(onReplace,11128969:doReplace,[])
}
Add(Replace,11128969,196,70)
{
SubStr="в"
DestStr="v"
link(onReplace,3391353:doReplace,[])
}
Add(Replace,3391353,238,70)
{
SubStr="г"
DestStr="g"
link(onReplace,14636492:doReplace,[])
}
Add(Replace,14636492,280,70)
{
SubStr="д"
DestStr="d"
link(onReplace,12283807:doReplace,[])
}
Add(Replace,12283807,322,70)
{
SubStr="е"
DestStr="e"
link(onReplace,16094144:doReplace,[])
}
Add(Replace,16094144,364,70)
{
SubStr="ё"
DestStr="yo"
link(onReplace,15370106:doReplace,[])
}
Add(Replace,15370106,406,70)
{
SubStr="ж"
DestStr="zh"
link(onReplace,16045438:doReplace,[])
}
Add(Replace,16045438,448,70)
{
SubStr="з"
DestStr="z"
link(onReplace,7316617:doReplace,[])
}
Add(Replace,7316617,490,70)
{
SubStr="и"
DestStr="i"
link(onReplace,7859333:doReplace,[])
}
Add(Replace,7859333,532,70)
{
SubStr="й"
DestStr="i"
link(onReplace,4297793:doReplace,[])
}
Add(Replace,4297793,574,70)
{
SubStr="к"
DestStr="k"
link(onReplace,14445077:doReplace,[])
}
Add(Replace,14445077,616,70)
{
SubStr="л"
DestStr="l"
link(onReplace,2487017:doReplace,[])
}
Add(Replace,2487017,658,70)
{
SubStr="м"
DestStr="m"
link(onReplace,13580692:doReplace,[])
}
Add(Replace,13580692,700,70)
{
SubStr="н"
DestStr="n"
link(onReplace,634748:doReplace,[])
}
Add(Replace,634748,742,70)
{
SubStr="о"
DestStr="o"
link(onReplace,439275:doReplace,[])
}
Add(Replace,439275,784,70)
{
SubStr="п"
DestStr="p"
link(onReplace,10546314:doReplace,[])
}
Add(Replace,10546314,826,70)
{
SubStr="р"
DestStr="r"
link(onReplace,5604329:doReplace,[])
}
Add(Replace,5604329,868,70)
{
SubStr="с"
DestStr="s"
link(onReplace,8844822:doReplace,[])
}
Add(Replace,8844822,910,70)
{
SubStr="т"
DestStr="t"
link(onReplace,1176478:doReplace,[])
}
Add(Replace,1176478,952,70)
{
SubStr="у"
DestStr="u"
link(onReplace,2638968:doReplace,[])
}
Add(Replace,2638968,994,70)
{
SubStr="ф"
DestStr="f"
link(onReplace,2325184:doReplace,[])
}
Add(Replace,2325184,1036,70)
{
SubStr="х"
DestStr="h"
link(onReplace,7324732:doReplace,[])
}
Add(Replace,7324732,1078,70)
{
SubStr="ц"
DestStr="tс"
link(onReplace,7644681:doReplace,[])
}
Add(Replace,7644681,1118,70)
{
SubStr="ч"
DestStr="ch"
link(onReplace,5102336:doReplace,[])
}
Add(Replace,5102336,1160,70)
{
SubStr="ш"
DestStr="sh"
link(onReplace,1683350:doReplace,[])
}
Add(Replace,1683350,1202,70)
{
SubStr="щ"
DestStr="sh"
link(onReplace,713049:doReplace,[])
}
Add(Replace,713049,1244,70)
{
SubStr="ь"
DestStr="'"
link(onReplace,2888230:doReplace,[])
}
Add(Replace,12869705,1370,70)
{
SubStr="э"
DestStr="a"
link(onReplace,10021912:doReplace,[])
}
Add(Replace,12585389,1328,70)
{
SubStr="ъ"
link(onReplace,12869705:doReplace,[])
}
Add(Replace,2888230,1286,70)
{
SubStr="ы"
DestStr="y"
link(onReplace,12585389:doReplace,[])
}
Add(Replace,10021912,1412,70)
{
SubStr="ю"
DestStr="yu"
link(onReplace,7662520:doReplace,[])
}
Add(Replace,7662520,1454,70)
{
SubStr="я"
DestStr="ya"
link(onReplace,1073863:doReplace,[])
}
Add(StrCase,7056492,63,70)
{
link(onModify,11439842:doReplace,[])
link(Str,12137061:Data1,[])
}
Add(Replace,1073863,1510,70)
{
SubStr=" "
DestStr="_"
link(onReplace,12137061:onEvent1,[])
}
END_SDK
Add(FormatStr,8675650,525,700)
{
DataCount=10
Mask="UPDATE table1 SET lastname='%1', \r\n name='%2', \r\n login='%3', \r\n middle_name='%4', \r\n phone='%5', \r\n diller='%6', \r\n email='%7', \r\n password_flexta='%8', \r\n password_mmf='%9'\r\n WHERE id=%10;"
link(onFString,1263187:doExec,[(720,706)(720,699)])
link(Str1,13311944:Var2,[(531,389)(517,389)])
link(Str2,11868430:Text,[(538,410)(525,410)])
link(Str3,5483149:Var2,[(545,541)(542,541)])
link(Str4,6824894:Text,[(552,540)(549,540)])
link(Str5,8358532:Text,[(559,483)(556,483)])
link(Str6,8193515:Text,[(566,492)(615,492)])
link(Str7,4896915:Text,[])
link(Str8,7707199:Text,[(580,534)(587,534)])
link(Str9,5824197:Text,[(587,580)(671,580)])
link(Str10,8347477:Result,[(594,408)(650,408)])
}
Add(GetDataEx,5483149,536,381)
{
link(Data,9848688:Text,[(542,289)(532,289)])
}
Add(DSC_QueryScalar,8347477,644,84)
{
SQL="SELECT COUNT(*) FROM table1"
DSManager="parent.mdb"
}
Add(Label,5124501,1146,677)
{
Left=5
Top=220
Width=45
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="Flextera"
}
Add(Edit,5824197,665,420)
{
Left=65
Top=250
Width=160
Text=""
}
Add(Label,10334331,1141,672)
{
Left=5
Top=250
Width=35
Height=19
Font=[Times New Roman,10,0,0,204]
Caption="MMF"
}
Add(Button,16538821,21,357)
{
Left=240
Top=10
Width=85
Height=35
link(onClick,13441164:doEvent1,[(60,363)(60,360)])
}
Add(Hub,13441164,67,354)
{
link(onEvent1,13117481:doEvent2,[(103,360)(103,300)])
link(onEvent2,8675650:doString,[(303,367)(303,706)])
}
Add(HubEx,7388849,504,84)
{
link(onEvent,8347477:doQuery,[])
}
END_SDK
Add(MainForm,7057179,147,322)
{
Width=971
Height=501
Caption="Добавление сотрудников на портал MMF и Flextera"
Position=1
Point(onClose)
link(onCreate,16168490:doOpen,[])
link(onClose,16168490:doClose,[])
}
Add(StringTableMT,16628981,371,315)
{
Left=10
Top=55
Width=940
Height=405
Columns=#2:id|5:Логин|14:Пароль FLEXTER|10:Пароль MMF|7:Фамилия|3:Имя|8:Отчество|7:Телефон|9:Эл. адрес|6:Диллер|
StrDelimiter="\9"
ColumnWidth=100
Redaction=0
TabGrid=0
TabGridFrame=0
Grid=0
Gradient=0
IconsCheck=[]
MiscIcons=[]
Icons=[]
Point(doMT_Add)
Point(Strings)
Point(onLineChange)
Point(onDblClick)
link(onClick,1702344:doPutText,[(415,321)(415,405)(352,405)(352,426)])
link(onLineChange,3699975:doWork2,[(421,327)])
}
Add(Button,10786776,266,98)
{
Left=10
Top=25
Width=120
Font=[MS Sans Serif,8,1,0,1]
Caption="Добавить строку"
link(onClick,15092223:doEvent1,[])
}
Add(DS_SQLite,16168490,210,336)
{
Name="mdb"
FileName="C:\SOFT\mydbase.db"
link(onOpen,10454492:doExec,[])
}
Add(DSC_Exec,10454492,259,336)
{
SQL="CREATE TABLE IF NOT EXISTS table1 (\r\n id int, \r\n login TEXT, \r\n password_flexta TEXT, \r\n password_mmf TEXT,\r\n name TEXT,\r\n lastname TEXT,\r\n middle_name TEXT,\r\n phone TEXT,\r\n email TEXT,\r\n diller TEXT);"
DSManager="mdb"
link(onExec,11160510:doWork2,[])
}
Add(ArrayRW,3995575,434,322)
{
link(onRead,2831270:doWork2,[])
link(Array,16628981:Strings,[(440,315)(418,315)(418,384)(391,384)])
}
Add(DSC_Query,8749579,322,336)
{
SQL="SELECT * FROM table1"
DSManager="mdb"
link(onQuery,16628981:doMT_Add,[(362,342)(362,356)])
link(onColumns,16628981:doClear,[(362,349)(362,328)])
}
Add(DSC_Exec,2307078,742,371)
{
DSManager="mdb"
link(onExec,2225601:doWork2,[(782,377)(782,218)])
}
Add(FormatStr,6841402,560,392)
{
DataCount=10
Mask="UPDATE table1 SET login='%2',password_flexta='%3',password_mmf='%4',name='%5',\r\nlastname='%6', middle_name='%7',phone='%8',email='%9',diller='%10' WHERE id=%1"
link(onFString,14192086:doWork2,[(646,398)(646,377)])
link(Str1,2776629:Part1,[])
link(Str2,2776629:Part2,[])
link(Str3,2776629:Part3,[])
link(Str4,2776629:Part4,[])
link(Str5,2776629:Part5,[])
link(Str6,2776629:Part6,[])
link(Str7,2776629:Part7,[])
link(Str8,2776629:Part8,[])
link(Str9,2776629:Part9,[])
link(Str10,2776629:Part10,[])
}
Add(MultiStrPart,2776629,560,322)
{
Char="\9"
Count=10
link(onSplit,3059522:doWork2,[])
}
Add(Button,14428720,322,476)
{
Left=135
Top=25
Width=120
Font=[MS Sans Serif,8,1,0,1]
Caption="Удалить строку"
link(onClick,2932136:doSplit,[])
}
Add(FormatStr,214626,427,476)
{
DataCount=1
Mask="DELETE FROM table1 WHERE id=%1 "
link(onFString,14192086:doWork3,[(669,482)])
link(Str1,2932136:Part1,[(433,468)(418,468)(418,523)(384,523)])
}
Add(MultiStrPart,2932136,378,476)
{
Char="\9"
Count=1
link(onSplit,214626:doString,[])
link(Str,15748700:Var2,[])
}
Add(Hub,15092223,448,98)
{
link(onEvent1,9467718:doWork1,[])
}
Add(HubEx,14192086,665,371)
{
link(onEvent,587237:doWork2,[])
}
Add(HubEx,11160510,301,336)
{
link(onEvent,8749579:doQuery,[])
}
Add(Clipboard,1702344,357,420)
{
Point(PutText)
link(PutText,15748700:Var1,[(363,376)])
}
Add(GetDataEx,15748700,378,371)
{
link(Data,16628981:Select,[])
}
Add(HubEx,3699975,420,322)
{
link(onEvent,3995575:doRead,[])
}
Add(HubEx,2831270,532,322)
{
link(onEvent,2776629:doSplit,[])
}
Add(HubEx,3059522,641,322)
{
Angle=1
link(onEvent,6841402:doString,[(645,364)(548,364)(548,398)])
}
Add(HubEx,587237,672,371)
{
link(onEvent,2307078:doExec,[])
}
Add(FormatStr,9469642,1082,361)
{
Mask="INSERT INTO table1( id,login,password_flexta,password_mmf) VALUES(NULL,'','%1','%2');"
link(Str2,13350104:Result,[])
}
Add(StringGen,13350104,1089,319)
{
Count=8
Charset="ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%&*abcdefghijklmnopqrstuvwxyz!@#$%&*ABCDEFGHIJKLMNOPQRSTUVWXYZ"
}
Add(Hub,7231284,970,326)
{
link(onEvent1,13350104:doGenerateRnd,[])
link(onEvent2,16430948:doGenerateRnd,[(1009,339)(1009,374)])
}
Add(StringGen,16430948,1033,361)
{
Count=8
Charset="ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%&*abcdefghijklmnopqrstuvwxyz!@#$%&*ABCDEFGHIJKLMNOPQRSTUVWXYZ"
link(onResult,9469642:doString,[])
}
Add(HubEx,2225601,602,212)
{
Angle=2
}
Add(HubEx,12464817,553,212)
{
Angle=2
link(onEvent,11160510:doWork1,[(305,218)])
}
Add(HubEx,2278295,588,212)
{
Angle=2
link(onEvent,12464817:doWork2,[])
}
|
Как-то так, вроде.
Спасибо огромное. Сам бы я думаю никогда не сделал.
Поиск
Друзья
Администрация