Вверх ↑
Ответов: 413
Рейтинг: 57
#1: 2013-03-22 17:28:28 ЛС | профиль | цитата
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,[])
}


Не могу сделать поиск по части ФИО. Пробовал конвертовать в UTF-8, но что-то делаю не так и все равно не работает.
Помогите реализовать поиск по части ФИО.
карма: 0

0