Почему вылетает с ошибкой при переборе строк? Подскажите пожалуйста. Доходит до 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,[]) }
|