Tad писал(а):
Писать в БД и читать из БД в UTF-8Если не сложно, можно маленький пример как правильно писать и читать из БД в UTF-8
------------ Дoбавленo в 17.28:
Вот пример моей схемы (см. мультик):
Add(MainForm,2953706,182,98)
{
Width=566
Height=469
Point(onClose)
link(onCreate,6839307:doStrCat,[])
link(onClose,6839307:doClose,[])
}
Add(Button,722635,182,168)
{
Left=10
Top=255
Width=90
Caption="Добавить"
link(onClick,6839307:doOperation,[(226,174)(226,139)])
}
Add(Button,9931987,182,238)
{
Left=10
Top=320
Width=90
Caption="Удалить"
link(onClick,6839307:doString1,[(235,244)(235,160)])
}
Add(StringTableMT,5820341,483,77)
{
Left=5
Top=5
Width=550
Height=235
Font=[Calibri,10,0,0,204]
Columns=#7:Дата=70|9:Ф.И.О=210|6:ИНН=70|27:Наименование организаци=210|
StrDelimiter="\9"
Grid=0
IconsCheck=[]
MiscIcons=[]
Icons=[]
Point(doMT_Add)
Point(onMouseDown)
Point(Strings)
Point(Index)
link(onClick,15597598:doEvent1,[])
}
Add(Edit,1026152,798,84)
{
Left=255
Top=250
Width=290
Text="Иванов Иван Иванович"
link(onChange,9004869:doValue,[(842,90)(842,76)(786,76)(786,62)])
link(Str,9004869:Var,[])
}
Add(Edit,16741144,798,147)
{
Left=255
Top=275
Width=290
Text="ООО "Рага и копыта""
link(onChange,5426105:doValue,[(842,153)(842,139)(786,139)(786,125)])
link(Str,5426105:Var,[])
}
Add(Button,4801561,182,203)
{
Left=10
Top=285
Width=90
Caption="Заменить"
link(onClick,6839307:doString,[(230,209)(230,153)])
}
Add(DoData,16510775,399,91)
{
link(onEventData,5820341:doDelete,[])
link(Data,5820341:Index,[(405,59)(526,59)(526,128)(510,128)])
}
Add(MultiElementEx,6839307,287,112)
{
link(onQuery,5820341:doMT_Add,[])
link(Out,16510775:doData,[(330,125)(330,97)])
link(onError,13069546:doMessage,[])
link(Str1,2071982:Text,[])
link(_Data,1469038:Var,[])
}
BEGIN_SDK
Add(EditMultiEx,13434563,21,21)
{
WorkCount=#21:doStrCat=Открыть базу|20:doClose=Закрыть базу|29:doExec=Открыть таблицу в базе|34:doOperation=Добавить запись в базу|30:doString2=Выбор строки из базы|31:doString=Изменить строку в базе|32:doString1=Удалить строку из базы|30:In=Стереть значение переменных|20:In1=Поиск по фамилии|
EventCount=#22:onQuery=Данные из базы|18:Out=Удалить строку|23:onError=Описание ошибки|
DataCount=#23:Str1=Имя таблицы в базе|33:_Data=Строка значений для условий|
Width=1091
Height=746
VOffset=140
HOffset=210
link(doStrCat,8134644:doStrCat,[])
link(doClose,9154515:doClose,[])
link(doExec,9176302:In,[])
link(doOperation,5515677:In,[])
link(doString2,4238206:In,[])
link(doString,16115821:In,[])
link(doString1,161419:In,[])
link(In,2234141:In,[])
link(In1,1706070:In,[])
}
Add(DS_SQLite,9154515,175,161)
{
Name="db1"
Point(onError)
link(onOpen,9725937:doWork,[])
link(onError,16148190:doWork,[(215,174)(215,188)])
}
Add(VisualStrings,9988527,49,112)
{
@Hint=#17:Имя базы клеентов|
Lines=#11:Customer.db|
Width=74
AddHint(-16,-22,116,13,@Hint)
}
Add(Dir,1723842,133,112)
{
}
Add(StrCat,8134644,133,161)
{
Str2="Customer.db"
link(onStrCat,9154515:doOpen,[])
link(Str1,1723842:CurrentDir,[])
}
Add(DSC_Query,10510355,175,525)
{
DSManager="db1"
link(onQuery,6896768:doWork2,[])
link(onError,5223325:doWork,[])
}
Add(FormatStr,12839521,126,525)
{
DataCount=1
Mask="SELECT tim, fio, inn, pnorg FROM %1 "
Point(FString)
link(onFString,10510355:doQuery,[])
link(Str1,13871668:getVar,[])
}
Add(DSC_Exec,1004532,329,245)
{
SQL="CREATE TABLE Juridical_persons (tim char, fio char, inn char, vdoc char, ser char, nom char, datav char, orgv char, areg char, mgit char, gtel char, mobtel char, email char, rschet char, lschet char, bank char, korschet char, bik char, fiorp char, pnorg char, knorg char, ogrn char, kpp char, facs char, dolgruk char, dolgrukrp char)"
DSManager="db1"
link(onError,8375465:doWork3,[(368,258)])
}
Add(LineBreakEx,15717904,224,35)
{
Type=3
link(_Data,13434563:Str1,[(230,28)(237,28)])
}
Add(LineBreakEx,13871668,126,497)
{
Type=2
}
Add(DSC_Exec,15057070,329,161)
{
SQL="CREATE TABLE physical_persons (tim char, fio char, inn char, vdoc char, ser char, nom char, datav char, orgv char, areg char, mgit char, gtel char, mobtel char, email char, rschet char, lschet char, bank char, korschet char, bik char, fiorp char, pnorg char, knorg char, ogrn char, kpp char, facs char, dolgruk char, dolgrukrp char)"
DSManager="db1"
link(onError,8375465:doWork1,[(368,174)])
}
Add(DSC_Exec,1480879,329,203)
{
SQL="CREATE TABLE individual_businessman (tim char, fio char, inn char, vdoc char, ser char, nom char, datav char, orgv char, areg char, mgit char, gtel char, mobtel char, email char, rschet char, lschet char, bank char, korschet char, bik char, fiorp char, pnorg char, knorg char, ogrn char, kpp char, facs char, dolgruk char, dolgrukrp char)"
DSManager="db1"
link(onError,8375465:doWork2,[])
}
Add(Hub,15168293,294,161)
{
OutCount=3
link(onEvent1,15057070:doExec,[])
link(onEvent2,1480879:doExec,[(322,174)(322,209)])
link(onEvent3,1004532:doExec,[(317,181)(317,251)])
}
Add(GlobalVar,13892599,679,126)
{
Name="fio"
}
Add(GlobalVar,16120850,686,133)
{
Name="inn"
}
Add(GlobalVar,818294,693,140)
{
Name="vdoc"
}
Add(GlobalVar,12437345,700,147)
{
Name="ser"
}
Add(GlobalVar,11926205,707,154)
{
Name="nom"
}
Add(GlobalVar,9223001,714,161)
{
Name="datav"
}
Add(GlobalVar,445411,749,196)
{
Name="mobtel"
}
Add(GlobalVar,6267156,742,189)
{
Name="gtel"
}
Add(GlobalVar,1405004,735,182)
{
Name="mgit"
}
Add(GlobalVar,1082433,728,175)
{
Name="areg"
}
Add(GlobalVar,3968397,721,168)
{
Name="orgv"
}
Add(GlobalVar,12403810,756,203)
{
Name="email"
}
Add(GlobalVar,15637281,763,210)
{
Name="rschet"
}
Add(GlobalVar,4016686,770,217)
{
Name="lschet"
}
Add(GlobalVar,12449814,777,224)
{
Name="bank"
}
Add(GlobalVar,9583312,784,231)
{
Name="korschet"
}
Add(GlobalVar,16427640,791,238)
{
Name="bik"
}
Add(GlobalVar,8342357,798,245)
{
Name="fiorp"
}
Add(Time,5083965,672,84)
{
Time_Date=1
Format="D:M:Y"
}
Add(GlobalVar,4226709,805,252)
{
Name="pnorg"
}
Add(GlobalVar,2763689,812,259)
{
Name="knorg"
}
Add(GlobalVar,8020093,819,266)
{
Name="ogrn"
}
Add(GlobalVar,7494118,826,273)
{
Name="kpp"
}
Add(GlobalVar,13893446,833,280)
{
Name="facs"
}
Add(GlobalVar,5269966,840,287)
{
Name="dolgruk"
}
Add(GlobalVar,5504170,847,294)
{
Name="dolgrukrp"
}
Add(LineBreak,409131,973,161)
{
Caption="table"
link(Out,4307573:doWork2,[])
Primary=[1029543,-728,364]
}
Add(FormatStr,8548566,665,525)
{
DataCount=27
Mask="INSERT INTO '%1' VALUES ('%2', '%3', '%4', '%5', '%6', '%7', '%8', '%9', '%10', '%11', '%12', '%13', '%14', '%15', '%16', '%17', '%18', '%19', '%20', '%21', '%22', '%23', '%24', '%25', '%26', '%27')"
Point(FString)
link(onFString,10185917:doExec,[])
link(Str1,16489732:Var2,[])
link(Str2,7289162:Var2,[])
link(Str3,14606880:Var2,[])
link(Str4,4167785:Var2,[])
link(Str5,8482711:Var2,[])
link(Str6,8660643:Var2,[])
link(Str7,16173088:Var2,[])
link(Str8,15197140:Var2,[])
link(Str9,3425200:Var2,[])
link(Str10,4431262:Var2,[])
link(Str11,12866678:Var2,[])
link(Str12,5931188:Var2,[])
link(Str13,3174397:Var2,[])
link(Str14,13878993:Var2,[])
link(Str15,5004518:Var2,[])
link(Str16,3706642:Var2,[])
link(Str17,12381378:Var2,[])
link(Str18,7143256:Var2,[])
link(Str19,9118458:Var2,[])
link(Str20,10192554:Var2,[])
link(Str21,3474819:Var2,[])
link(Str22,7166096:Var2,[])
link(Str23,2780544:Var2,[])
link(Str24,11893112:Var2,[])
link(Str25,16512417:Var2,[])
link(Str26,15507392:Var2,[])
link(Str27,10177872:Var2,[])
}
Add(DSC_Exec,10185917,875,525)
{
DSManager="db1"
link(onExec,16487744:doAdd,[])
link(onError,14182818:doWork,[])
link(SQL,8548566:FString,[(881,513)(864,513)(864,567)(671,567)])
}
Add(LineBreakEx,15943915,665,84)
{
Type=2
}
Add(LineBreakEx,7090998,1029,196)
{
Caption="onError"
Type=1
link(OnEvent,13434563:onError,[(1097,202)(1097,181)])
}
Add(LineBreakEx,14182818,924,532)
{
Caption="onError"
}
Add(LineBreakEx,15300736,378,210)
{
Caption="onError"
}
Add(HubEx,8375465,364,210)
{
link(onEvent,15300736:doWork,[])
}
Add(MT_AddData,16487744,980,525)
{
Count=4
link(onAdd,4307573:doWork3,[(1019,531)])
link(Data1,7289162:Var3,[(986,497)])
link(Data2,14606880:Var3,[(993,489)])
link(Data3,4167785:Var3,[(1000,481)])
link(Data4,3474819:Var3,[(1007,473)])
}
Add(GetDataEx,7289162,672,492)
{
link(Data,5083965:FormatTime,[])
}
Add(GetDataEx,14606880,679,484)
{
link(Data,13892599:Var,[])
}
Add(GetDataEx,3474819,805,468)
{
link(Data,16122026:Var2,[])
}
Add(HubEx,4307573,1015,161)
{
link(onEvent,13434563:onQuery,[])
}
Add(Check,9725937,224,161)
{
Check=1
Caption="Создать"
link(onEvent,15168293:doEvent1,[])
}
Add(FormatStr,11240137,175,455)
{
Mask="DELETE FROM %1 WHERE inn='%2'"
Point(FString)
link(onFString,6512088:doExec,[])
link(Str1,11682595:getVar,[])
}
Add(DSC_Exec,6512088,224,455)
{
DSManager="db1"
link(onError,7266942:doWork,[])
link(SQL,11240137:FString,[(230,443)(216,443)(216,496)(181,496)])
}
Add(LineBreakEx,11682595,175,427)
{
Type=2
}
Add(LineBreak,10967978,1036,168)
{
Caption="-str"
link(Out,13434563:Out,[])
Primary=[13450960,-903,294]
}
Add(LineBreakEx,7266942,266,462)
{
Caption="onError"
}
Add(Hub,12847272,105,455)
{
link(onEvent1,11240137:doString,[])
link(onEvent2,13450960:In,[])
}
Add(FormatStr,16060607,476,644)
{
DataCount=31
Mask="UPDATE %1 SET tim='%2', fio='%3', inn='%4', vdoc='%5', ser='%6', nom='%7', datav='%8', orgv='%9', areg='%10', mgit='%11', gtel='%12', mobtel='%13', email='%14', rschet='%15', lschet='%16', bank='%17', korschet='%18', bik='%19', fiorp='%20', pnorg='%21', knorg='%22', ogrn='%23', kpp='%24', facs='%25', dolgruk='%26', dolgrukrp='%27' WHERE tim = '%28' AND fio = '%29' AND inn = '%30' AND pnorg = '%31'"
Point(FString)
link(onFString,7714694:doExec,[])
link(Str1,16489732:Var1,[(482,505)])
link(Str2,7289162:Var1,[(489,497)])
link(Str3,14606880:Var1,[(496,489)])
link(Str4,4167785:Var1,[(503,481)])
link(Str5,8482711:Var1,[(510,473)])
link(Str6,8660643:Var1,[(517,465)])
link(Str7,16173088:Var1,[(524,457)])
link(Str8,15197140:Var1,[(531,450)])
link(Str9,3425200:Var1,[(538,443)])
link(Str10,4431262:Var1,[(545,436)])
link(Str11,12866678:Var1,[(552,429)])
link(Str12,5931188:Var1,[(559,422)])
link(Str13,3174397:Var1,[(566,415)])
link(Str14,13878993:Var1,[(573,408)])
link(Str15,5004518:Var1,[(580,401)])
link(Str16,3706642:Var1,[(587,394)])
link(Str17,12381378:Var1,[(594,387)])
link(Str18,7143256:Var1,[(601,380)])
link(Str19,9118458:Var1,[(608,373)])
link(Str20,10192554:Var1,[(615,366)])
link(Str21,16122026:Var1,[(622,359)])
link(Str22,7166096:Var1,[(629,352)])
link(Str23,2780544:Var1,[(636,345)])
link(Str24,11893112:Var1,[(643,338)])
link(Str25,16512417:Var1,[(650,331)])
link(Str26,15507392:Var1,[(657,324)])
link(Str27,10177872:Var1,[(664,317)])
link(Str28,12609957:Part1,[])
link(Str29,12609957:Part2,[])
link(Str30,12609957:Part3,[])
link(Str31,12609957:Part4,[])
}
Add(DSC_Exec,7714694,721,644)
{
DSManager="db1"
link(onError,9356026:doWork,[])
link(SQL,16060607:FString,[(727,635)(710,635)(710,687)(482,687)])
}
Add(LineBreakEx,16148190,224,182)
{
Caption="onError"
}
Add(LineBreakEx,9356026,763,651)
{
Caption="onError"
}
Add(LineBreakEx,5223325,224,539)
{
Caption="onError"
}
Add(GetDataEx,4167785,686,476)
{
link(Data,16120850:Var,[])
}
Add(DSC_Query,15651384,329,119)
{
DSManager="db1"
link(onQuery,9298385:doSeparateMT,[])
link(onError,3707925:doWork,[])
}
Add(FormatStr,15404136,280,119)
{
DataCount=5
Mask="SELECT * FROM '%1' WHERE tim = '%2' AND fio = '%3' AND inn = '%4' AND pnorg = '%5'"
Point(FString)
link(onFString,15651384:doQuery,[])
link(Str1,12533003:getVar,[(286,112)(279,112)])
link(Str2,1209358:Part1,[])
link(Str3,1209358:Part2,[])
link(Str4,1209358:Part3,[])
link(Str5,1209358:Part4,[])
}
Add(LineBreakEx,12533003,273,91)
{
Type=2
}
Add(MT_MultiData,9298385,441,119)
{
Count=26
link(onData2,1522335:doWork2,[])
link(onData3,11683883:doWork2,[])
link(onData4,5535166:doWork2,[])
link(onData5,13555894:doWork2,[])
link(onData6,11704830:doWork2,[])
link(onData7,11226682:doWork2,[])
link(onData8,12199166:doWork2,[])
link(onData9,13529868:doWork2,[])
link(onData10,1490636:doWork2,[])
link(onData11,9449568:doWork2,[])
link(onData12,9137167:doWork2,[])
link(onData13,6992371:doWork2,[])
link(onData14,11343134:doWork2,[])
link(onData15,15047329:doWork2,[])
link(onData16,2402853:doWork2,[])
link(onData17,2224653:doWork2,[])
link(onData18,879686:doWork2,[])
link(onData19,3650367:doWork2,[])
link(onData20,14230453:doWork2,[])
link(onData21,5907521:doWork2,[])
link(onData22,4934362:doWork2,[])
link(onData23,2514624:doWork2,[])
link(onData24,6649458:doWork2,[])
link(onData25,2601392:doWork2,[])
link(onData26,14320301:doWork2,[])
}
Add(LineBreakEx,3707925,378,133)
{
Caption="onError"
}
Add(GetDataEx,16489732,665,500)
{
link(Data,15943915:getVar,[])
}
Add(GetDataEx,8482711,693,468)
{
link(Data,818294:Var,[])
}
Add(GetDataEx,8660643,700,460)
{
link(Data,12437345:Var,[])
}
Add(GetDataEx,16173088,707,452)
{
link(Data,11926205:Var,[])
}
Add(GetDataEx,15197140,714,445)
{
link(Data,9223001:Var,[])
}
Add(GetDataEx,3425200,721,438)
{
link(Data,3968397:Var,[])
}
Add(GetDataEx,4431262,728,431)
{
link(Data,1082433:Var,[])
}
Add(GetDataEx,12866678,735,424)
{
link(Data,1405004:Var,[])
}
Add(GetDataEx,5931188,742,417)
{
link(Data,6267156:Var,[])
}
Add(GetDataEx,3174397,749,410)
{
link(Data,445411:Var,[])
}
Add(GetDataEx,13878993,756,403)
{
link(Data,12403810:Var,[])
}
Add(GetDataEx,5004518,763,396)
{
link(Data,15637281:Var,[])
}
Add(GetDataEx,3706642,770,389)
{
link(Data,4016686:Var,[])
}
Add(GetDataEx,12381378,777,382)
{
link(Data,12449814:Var,[])
}
Add(GetDataEx,7143256,784,375)
{
link(Data,9583312:Var,[])
}
Add(GetDataEx,9118458,791,368)
{
link(Data,16427640:Var,[])
}
Add(GetDataEx,10192554,798,361)
{
link(Data,8342357:Var,[])
}
Add(GetDataEx,16122026,805,354)
{
link(Data,4226709:Var,[])
}
Add(GetDataEx,7166096,812,347)
{
link(Data,2763689:Var,[])
}
Add(GetDataEx,2780544,819,340)
{
link(Data,8020093:Var,[])
}
Add(GetDataEx,11893112,826,333)
{
link(Data,7494118:Var,[])
}
Add(GetDataEx,16512417,833,326)
{
link(Data,13893446:Var,[])
}
Add(GetDataEx,15507392,840,319)
{
link(Data,5269966:Var,[])
}
Add(GetDataEx,10177872,847,312)
{
link(Data,5504170:Var,[])
}
Add(Hub,12041464,448,315)
{
OutCount=25
link(onEvent1,1522335:doWork3,[(648,321)])
link(onEvent2,11683883:doWork3,[(641,328)])
link(onEvent3,5535166:doWork3,[(634,335)])
link(onEvent4,13555894:doWork3,[(627,342)])
link(onEvent5,11704830:doWork3,[(620,349)])
link(onEvent6,11226682:doWork3,[(613,356)])
link(onEvent7,12199166:doWork3,[(606,363)])
link(onEvent8,13529868:doWork3,[(599,370)])
link(onEvent9,1490636:doWork3,[(592,377)])
link(onEvent10,9449568:doWork3,[(585,384)])
link(onEvent11,9137167:doWork3,[(578,391)])
link(onEvent12,6992371:doWork3,[(571,398)])
link(onEvent13,11343134:doWork3,[(564,405)])
link(onEvent14,15047329:doWork3,[(557,412)])
link(onEvent15,2402853:doWork3,[(550,419)])
link(onEvent16,2224653:doWork3,[(543,426)])
link(onEvent17,879686:doWork3,[(536,433)])
link(onEvent18,3650367:doWork3,[(529,440)])
link(onEvent19,14230453:doWork3,[(522,447)])
link(onEvent20,5907521:doWork3,[(515,454)])
link(onEvent21,4934362:doWork3,[(508,461)])
link(onEvent22,2514624:doWork3,[(501,468)])
link(onEvent23,6649458:doWork3,[(494,475)])
link(onEvent24,2601392:doWork3,[(487,482)])
link(onEvent25,14320301:doWork3,[(480,489)])
}
Add(DoData,3340112,399,315)
{
link(onEventData,12041464:doEvent1,[])
link(Data,15642817:Value,[])
}
Add(Memory,15642817,399,266)
{
Default=String()
}
Add(LineBreak,8444648,357,315)
{
Caption="0"
link(Out,3340112:doData,[])
Primary=[2234141,-287,-105]
}
Add(HubEx,14320301,476,294)
{
link(onEvent,5504170:doValue,[])
}
Add(HubEx,2601392,483,287)
{
link(onEvent,5269966:doValue,[])
}
Add(HubEx,6649458,490,280)
{
link(onEvent,13893446:doValue,[])
}
Add(HubEx,2514624,497,273)
{
link(onEvent,7494118:doValue,[])
}
Add(HubEx,4934362,504,266)
{
link(onEvent,8020093:doValue,[])
}
Add(HubEx,5907521,511,259)
{
link(onEvent,2763689:doValue,[])
}
Add(HubEx,14230453,518,252)
{
link(onEvent,4226709:doValue,[])
}
Add(HubEx,3650367,525,245)
{
link(onEvent,8342357:doValue,[])
}
Add(HubEx,879686,532,238)
{
link(onEvent,16427640:doValue,[])
}
Add(HubEx,2224653,539,231)
{
link(onEvent,9583312:doValue,[])
}
Add(HubEx,2402853,546,224)
{
link(onEvent,12449814:doValue,[])
}
Add(HubEx,15047329,553,217)
{
link(onEvent,4016686:doValue,[])
}
Add(HubEx,11343134,560,210)
{
link(onEvent,15637281:doValue,[])
}
Add(HubEx,6992371,567,203)
{
link(onEvent,12403810:doValue,[])
}
Add(HubEx,9137167,574,196)
{
link(onEvent,445411:doValue,[])
}
Add(HubEx,9449568,581,189)
{
link(onEvent,6267156:doValue,[])
}
Add(HubEx,1490636,588,182)
{
link(onEvent,1405004:doValue,[])
}
Add(HubEx,13529868,595,175)
{
link(onEvent,1082433:doValue,[])
}
Add(HubEx,12199166,602,168)
{
link(onEvent,3968397:doValue,[])
}
Add(HubEx,11226682,609,161)
{
link(onEvent,9223001:doValue,[])
}
Add(HubEx,11704830,616,154)
{
link(onEvent,11926205:doValue,[])
}
Add(HubEx,13555894,623,147)
{
link(onEvent,12437345:doValue,[])
}
Add(HubEx,5535166,630,140)
{
link(onEvent,818294:doValue,[])
}
Add(HubEx,11683883,637,133)
{
link(onEvent,16120850:doValue,[])
}
Add(HubEx,1522335,644,126)
{
link(onEvent,13892599:doValue,[])
}
Add(LineBreak,16056819,56,455)
{
Caption="del"
link(Out,12847272:doEvent1,[])
Primary=[161419,-21,-252]
}
Add(LineBreak,16149323,385,637)
{
Caption="update"
link(Out,3249762:doEvent1,[])
Primary=[16115821,-308,-441]
}
Add(LineBreak,7817399,182,112)
{
Caption="select"
link(Out,14450212:doEvent1,[])
Primary=[4238206,-56,77]
}
Add(LineBreak,9532760,441,525)
{
Caption="+str"
link(Out,8548566:doString,[])
Primary=[5515677,-406,-343]
}
Add(LineBreak,4826130,70,525)
{
Caption="open"
link(Out,12839521:doString,[])
Primary=[9176302,7,-350]
}
Add(MultiStrPart,1209358,287,77)
{
Char="\9"
Count=4
link(Str,10669123:Var3,[(293,31)])
}
Add(Hub,14450212,238,112)
{
link(onEvent1,1209358:doSplit,[(270,118)(270,83)])
link(onEvent2,15404136:doString,[])
}
Add(LineBreak,9792410,238,56)
{
Caption="str"
Type=1
link(Data,10669123:Var2,[])
Primary=[6899892,427,518]
}
Add(GetDataEx,10669123,238,26)
{
link(Data,13434563:_Data,[])
}
Add(MultiStrPart,12609957,665,602)
{
Char="\9"
Count=4
link(Str,6899892:Var,[])
}
Add(Hub,3249762,441,637)
{
link(onEvent1,12609957:doSplit,[(468,643)(468,608)])
link(onEvent2,16060607:doString,[])
}
Add(DSC_Query,15415242,182,616)
{
DSManager="db1"
link(onQuery,6896768:doWork3,[(235,622)])
link(onError,12748304:doWork,[])
}
Add(FormatStr,9480614,133,616)
{
@Hint=#25:Поиск по базе не работает|
Mask="SELECT tim, fio, inn, pnorg FROM '%1' WHERE fio LIKE '%%2%'"
Point(FString)
link(onFString,15415242:doQuery,[])
link(Str1,726599:getVar,[(139,609)(125,609)])
link(Str2,15984887:Value,[])
AddHint(-60,53,153,13,@Hint)
}
Add(LineBreakEx,726599,119,588)
{
Type=2
}
Add(LineBreakEx,12748304,231,630)
{
Caption="onError"
}
Add(LineBreak,11596511,49,609)
{
Caption="find"
link(Out,8028307:doEvent1,[])
Primary=[1706070,63,-392]
}
Add(Hub,8028307,91,609)
{
link(onEvent1,15984887:doValue,[(113,615)(113,580)])
link(onEvent2,9480614:doString,[])
}
Add(Memory,15984887,140,574)
{
}
Add(HubEx,6896768,231,525)
{
link(onEvent,1029543:In,[])
}
END_SDK
Add(VisualStrings,2071982,287,56)
{
@Hint=#11:Имя таблицы|
Lines=#17:Juridical_persons|
Width=88
AddHint(-4,-21,83,13,@Hint)
}
Add(Message,13069546,336,126)
{
Caption="Error"
}
Add(Button,8396127,70,119)
{
Left=110
Top=255
Width=120
Caption="Прочитать базу"
link(onClick,2585416:doEvent1,[])
}
Add(GlobalVar,9004869,798,56)
{
Name="fio"
}
Add(GlobalVar,5426105,798,119)
{
Name="pnorg"
}
Add(Edit,1781402,805,217)
{
Left=255
Top=300
Width=290
Text="12342124213"
link(onChange,14852237:doValue,[(849,223)(849,209)(793,209)(793,195)])
link(Str,14852237:Var,[])
}
Add(GlobalVar,14852237,805,189)
{
Name="inn"
}
Add(DoData,14746149,616,154)
{
link(onEventData,4542299:doEvent1,[])
link(Data,16525490:Var3,[(622,131)])
}
Add(Hub,15597598,532,77)
{
OutCount=4
link(onEvent1,9927298:doEvent1,[(560,83)(560,153)])
link(onEvent2,1026152:doText,[])
link(onEvent3,16741144:doText2,[(769,97)(769,160)])
link(onEvent4,1781402:doText2,[(777,104)(777,230)])
}
Add(Edit,12733503,714,203)
{
Left=255
Top=365
Width=290
Text=""
link(Str,13614929:Part2,[])
}
Add(Edit,6763943,721,252)
{
Left=255
Top=390
Width=290
Text=""
link(Str,13614929:Part3,[])
}
Add(Edit,8150736,728,308)
{
Left=255
Top=415
Width=290
Text=""
link(Str,13614929:Part4,[])
}
Add(MultiStrPart,13614929,707,154)
{
Char="\9"
Count=4
}
Add(Hub,4542299,658,154)
{
OutCount=5
link(onEvent1,13614929:doSplit,[])
link(onEvent2,12733503:doText,[(694,167)(694,209)])
link(onEvent3,6763943:doText,[(690,174)(690,258)])
link(onEvent4,8150736:doText,[(686,181)(686,314)])
}
Add(LineBreak,1586869,490,140)
{
Caption="str"
Type=1
link(Data,16525490:Var2,[])
Primary=[1469038,-196,-56]
}
Add(Hub,9927298,574,147)
{
link(onEvent1,6839307:doString2,[(599,153)(599,186)(275,186)(275,146)])
link(onEvent2,14746149:doData,[])
}
Add(GetDataEx,16525490,490,126)
{
link(Data,5820341:Select,[])
}
Add(Edit,858575,182,273)
{
Top=365
Width=250
Text="Иванов Иван Иванович"
}
Add(Button,11824163,70,315)
{
Left=85
Top=395
Caption="Найти"
link(onClick,15368164:doEvent1,[])
}
Add(DoData,13970603,182,322)
{
link(onEventData,6839307:In1,[(250,328)(250,174)])
link(Data,858575:Text,[])
}
Add(Hub,2585416,112,119)
{
link(onEvent1,4616070:doWork2,[])
link(onEvent2,6839307:doExec,[])
}
Add(LineBreak,10289396,441,84)
{
link(Out,5820341:doClear,[])
Primary=[3844364,-294,35]
}
Add(Hub,15368164,112,315)
{
link(onEvent1,4616070:doWork3,[(137,321)])
link(onEvent2,13970603:doData,[])
}
Add(HubEx,4616070,133,119)
{
link(onEvent,3844364:In,[])
}
Помогите реализовать поиск по части ФИО.