Вверх ↑
Ответов: 45
Рейтинг: 4
#1: 2015-02-18 23:30:43 ЛС | профиль | цитата
Почему вылетает с ошибкой при переборе строк? Подскажите пожалуйста. Доходит до 219 с OLEDB и до 263 с ODBC
code_35130.txt
Ссылка на xlsx https://dl.dropboxusercontent.com/u/43215472/test.xlsx

Ошибка разная бывает. Сейчас выскакивает:

------------ Дoбавленo в 23.30:
Странно. Почему так работает? Добавил таймер ожидания ответа после отправки запроса.
Add(MainForm,2953706,21,105)
{
Width=745
Height=596
Point(onClose)
}
Add(FormatStr,5564056,364,266)
{
Mask="Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=%1;
Extended Properties="Excel 12.0 xml;HDR=YES;IMEX=1";"
Point(FString)
link(onFString,5366140:doOpen,[(415,272)(415,300)(352,300)(352,328)])
link(Str1,9736921:Var3,[(370,254)(324,254)(324,296)])
link(Str2,1388409:Value,[])
AddHint(-74,-167,193,52,Mask)
}
Add(DS_OLEDB,5366140,364,322)
{
Name="ole_driver_1"
Point(onError)
link(onCreate,7180539:doWork2,[(408,328)(408,300)])
link(Driver,5564056:FString,[])
link(onError,586960:doMessage,[(426,335)(426,440)])
}
Add(FilePart,6971676,294,217)
{
link(onPath,1388409:doValue,[])
link(onName,15808613:doValue,[(513,230)(513,237)])
}
Add(ODialog,13669467,203,217)
{
Filter="All|*.xlsx"
link(onExecute,8178195:doEvent1,[])
}
Add(Hub,8178195,259,217)
{
OutCount=3
link(onEvent1,6971676:doPart,[])
link(onEvent2,2264967:doData,[(285,230)(285,244)(261,244)(261,258)])
link(onEvent3,5564056:doString,[(319,237)(319,272)])
}
Add(Memory,1388409,371,217)
{
}
Add(Message,586960,455,434)
{
}
Add(ChanelToIndex,4797571,420,287)
{
link(onIndex,15176345:doOn,[(464,293)(464,195)(212,195)(212,97)])
}
Add(Hub,13483931,287,336)
{
link(onEvent1,5366140:doClose,[(333,342)(333,335)])
link(onEvent2,11790626:doClose,[(313,349)(313,395)(212,395)(212,440)])
}
Add(DS_ODBC,11790626,224,427)
{
Name="qwe"
Point(onError)
link(onCreate,1996932:doEvent1,[])
link(Driver,15125627:FString,[])
}
Add(FormatStr,15125627,224,371)
{
Mask="Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
DriverId=790;
DBQ=%1;"
Point(FString)
link(onFString,11790626:doOpen,[(268,377)(268,405)(212,405)(212,433)])
link(Str1,9736921:Var1,[(230,296)])
}
Add(HubEx,7180539,406,294)
{
link(onEvent,4797571:doWork2,[])
}
Add(LED,15176345,224,77)
{
Left=110
Top=15
Width=15
Height=15
}
Add(Button,429211,77,343)
{
Left=5
Top=45
link(onClick,13669467:doExecute,[(156,349)(156,223)])
}
Add(Memory,15808613,700,231)
{
}
Add(Hub,4938214,735,315)
{
OutCount=4
link(onEvent1,4441257:doEvent1,[])
}
Add(FormatStr,2760181,672,315)
{
@Color=11184810
DataCount=3
Mask="SELECT * FROM [%1].[A%2:A%3]"
Point(FString)
link(onFString,4938214:doEvent1,[])
link(Str1,15808613:Value,[(678,289)(706,289)])
link(Str2,6645373:Var2,[(685,226)(860,226)])
link(Str3,9630627:Var2,[(692,239)(776,239)])
}
Add(DSC_Query,13233332,665,413)
{
DSManager="ole_driver_1"
link(onQuery,13287351:doEvent1,[(758,419)(758,363)])
link(SQL,2760181:FString,[(671,380)(678,380)])
}
Add(Hub,13287351,819,357)
{
InCount=2
OutCount=4
link(onEvent1,14377942:doValue,[(843,363)(843,307)])
link(onEvent2,16116178:doText,[(845,370)(845,216)(625,216)(625,62)])
link(onEvent3,2131945:doText,[(845,377)(845,219)(534,219)(534,62)])
link(onEvent4,10013294:doLength,[(847,384)(847,363)])
}
Add(Math,15717822,854,105)
{
OpType=1
Op2=1
link(onResult,16447514:doWork1,[(898,111)(898,216)(660,216)])
link(Op1,14672392:Var2,[(860,101)(776,101)])
}
Add(GetDataEx,14672392,770,84)
{
Angle=3
link(Data,13057087:Var,[(767,89)(767,78)(853,78)])
}
Add(GlobalVar,13057087,847,49)
{
Name="vava"
Data=Real(8)
link(onValue,15717822:doOperation,[(903,55)(903,83)(842,83)(842,111)])
}
Add(Math,11883328,777,112)
{
Op2=1
link(onResult,13057087:doValue,[(828,118)(828,55)])
link(Op1,14672392:Var3,[(783,89)])
}
Add(Button,13015458,525,308)
{
Left=5
Top=75
link(onClick,12800749:doStart,[])
}
Add(Label,16116178,637,56)
{
Left=15
Top=10
}
Add(HubEx,580074,702,168)
{
Angle=3
link(onEvent,11883328:doOperation,[(706,118)])
}
Add(GetDataEx,6645373,854,147)
{
link(Data,15717822:Result,[])
}
Add(GetDataEx,9630627,770,168)
{
link(Data,11883328:Result,[(776,159)(783,159)])
}
Add(EventFromData,2264967,273,252)
{
}
Add(Thread,12800749,581,308)
{
FastStop=0
link(onExec,580074:doWork3,[(706,314)])
}
Add(If_else,7221533,791,420)
{
Op2=Integer(0)
link(onFalse,3907620:doEvent1,[(842,433)(842,426)])
link(Op1,10013294:Result,[(797,404)(867,404)])
}
Add(Length,10013294,861,357)
{
link(onLength,7221533:doCompare,[(905,363)(905,395)(779,395)(779,426)])
link(Str,14377942:Value,[(867,345)(860,345)])
}
Add(GetDataEx,9736921,273,291)
{
link(Data,2264967:GetData,[])
}
Add(Hub,3907620,861,420)
{
link(onEvent1,580074:doWork1,[(887,426)(887,174)])
}
Add(Hub,4441257,763,315)
{
OutCount=4
link(onEvent2,15456387:doEvent1,[(789,328)(789,346)(506,346)(506,363)])
link(onEvent3,13233332:doQuery,[(789,335)(789,377)(653,377)(653,419)])
}
Add(Label,2131945,546,56)
{
Left=20
Top=105
link(Text,9630627:Var1,[(552,44)(662,44)(662,173)])
}
Add(Hub,1996932,308,427)
{
link(onEvent1,7180539:doWork3,[(410,433)])
}
Add(Memory,14377942,854,301)
{
}
Add(Hub,15456387,539,357)
{
link(onEvent1,9879665:doStop,[(574,363)(574,370)])
link(onEvent2,9879665:doTimer,[(574,370)(574,363)])
}
Add(MMTimer,9879665,595,357)
{
Resolution=0
Enable=1
link(onTimer,16447514:doWork3,[(660,363)])
}
Add(HubEx,16447514,656,315)
{
link(onEvent,2760181:doString,[])
}


карма: 1

0
файлы: 1code_35130.txt [4.1KB] [186]