相关文章推荐
小百科
›
Solved: Powerbuilder | Error: Array boundary exceeded at line 23 in open event of object w_available_drivers | Experts Exchange
ni
array
powerbuilder
豁达的小马驹
2 年前
About
Pricing
Community
Teams
Start Free Trial
Log in
</div><div class="contentWrapper__CenterContent-sc-1fp29y7-5 hXBTnV"><div class="questionWrapper__QuestionSection-ir5t2q-0 eGMjXE"><div class="questionHeader__HeaderSection-sc-18y0a3b-0 IVqWl"><div class="questionHeader__MetaSection-sc-18y0a3b-2 bQOgkd"><div class="questionHeader__MetaLeft-sc-18y0a3b-3 hFLAY"><img src="https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif" alt="Avatar of pemurray"/></div><div class="questionHeader__MetaRight-sc-18y0a3b-4 engfSe"><span><div class="author">pemurray</div> asked on<!-- --> <time datetime="2005-06-18T04:26:10Z">6/17/2005</time></span><h1 class="questionHeader__Title-sc-18y0a3b-1 jLLeIg">Powerbuilder | Error: Array boundary exceeded at line 23 in open event of object w_available_drivers</h1></div></div></div><div class="questionBodyWrapper__QuestionBodyWrapper-sc-57cwyz-0 jucnGB"><div id="q21462624" class="questionBody__BodyContent-q874ge-0 csPTmo wysiwyg-content"><div> Hi everyone and thanks for your help to date!!<br/> I have a right click event on a datawindow that is supposed to open a new window with a list of available resources. I thought it was working fine. Then I tried it at home and it seems to be blowing up without any ryhme or reason:<br/> When I right click on the datawindow, it kicks off my event but sometimes ends with "Error: Array boundary exceeded at line 23 in open event of object w_available_drivers"<br/> Here is my code for defining and working with the array:<br/> drvr_req_end_dt = uf_rez_calc_end_datetime(2<wbr/>,drvr_req_<wbr/>start_dt)<br/> datastore ds_1<br/> ds_1 = create datastore<br/> ds_1.dataobject = "dws_get_drivers_from_oper<wbr/>ator_parms<wbr/>"<br/> ds_1.settransobject(sqlca)<wbr/><br/> long rows<br/> rows = ds_1.retrieve(drvr_req_sta<wbr/>rt_dt,drvr<wbr/>_req_end_d<wbr/>t)<br/> messagebox("rows returned before array definition",string(rows))<br/> string rez_drivers[]<br/> string driver_number<br/> long i<br/> long ni<br/> for i = 1 to rows<br/> driver_number = ds_1.getitemstring(i, "dr_no")<br/> ni = i - 1<br/> if not isnull(driver_number) then<br/> rez_drivers[ni] = trim(driver_number) ----IT BLOWS UP HERE---<br/> end if<br/> dw_2.settransobject(sqlca)<wbr/><br/> string day<br/> day = dayname(date(drvr_req_star<wbr/>t_dt))<br/> messagebox("Day",day)<br/> string yes<br/> yes = 'Y'<br/> string no<br/> no = ""<br/> if day = "Monday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>yes,no,no,<wbr/>no,no,no,n<wbr/>o,no)<br/> end if<br/> if day = "Tuesday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,yes,no,<wbr/>no,no,no,n<wbr/>o)<br/> end if<br/> if day = "Wednesday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,no,yes,<wbr/>no,no,no,n<wbr/>o)<br/> end if<br/> if day = "Thursday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,no,no,y<wbr/>es,no,no,n<wbr/>o)<br/> end if<br/> if day = "Friday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,no,no,n<wbr/>o,yes,no,n<wbr/>o)<br/> end if<br/> if day = "Saturday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,no,no,n<wbr/>o,no,yes,n<wbr/>o)<br/> end if<br/> if day = "Sunday" then <br/> dw_2.retrieve(rez_drivers,<wbr/>no,no,no,n<wbr/>o,no,no,ye<wbr/>s)<br/> end if<br/> dw_2.Modify("r_1.Brush.Hat<wbr/>ch='6'")<br/> Yes, I know there are some horrendous coding techniques shown here, but I am just trying to illustrate the issue. Thanks!! PEM<br/> Now I only added this line the way it is written is because I am passing the value to another window and the help said I had to pass the string as an array. Okay, so now I am learning all about arrays: here is the code:<br/> rez_drivers[ni] = trim(driver_number) ----IT BLOWS UP HERE---<br/> Thank you!!!!<br/> </div><div class="topicTags__TagsSection-sc-1axydhw-0 eOhgMg"><style data-emotion="css xllg9a">.css-xllg9a{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;vertical-align:top;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;max-width:100%;font-weight:var(--chakra-fontWeights-medium);line-height:1.2;outline:0;min-height:1.5rem;min-width:1.5rem;font-size:var(--chakra-fontSizes-sm);border-radius:var(--chakra-radii-md);-webkit-padding-start:var(--chakra-space-2);padding-inline-start:var(--chakra-space-2);-webkit-padding-end:var(--chakra-space-2);padding-inline-end:var(--chakra-space-2);background:var(--chakra-colors-gray-100);color:var(--chakra-colors-gray-800);}.css-xllg9a:focus,.css-xllg9a[data-focus]{box-shadow:var(--chakra-shadows-outline);}</style><span class="css-xllg9a">Editors IDEs</span></div></div><div class="questionFooter__FooterSection-wcye1y-0 dQkQxi"><style data-emotion="css vy21t6">.css-vy21t6{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-flex-direction:row;-ms-flex-direction:row;flex-direction:row;}.css-vy21t6>*:not(style)~*:not(style){margin-top:0px;-webkit-margin-end:0px;margin-inline-end:0px;margin-bottom:0px;-webkit-margin-start:5px;margin-inline-start:5px;}</style><div class="chakra-stack css-vy21t6"><style data-emotion="css 1vmjtia">.css-1vmjtia{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-appearance:none;-moz-appearance:none;-ms-appearance:none;appearance:none;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;-webkit-transition:all 250ms;transition:all 250ms;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;position:relative;white-space:nowrap;vertical-align:middle;outline:none;width:auto;line-height:1.2;border-radius:var(--chakra-radii-md);font-weight:var(--chakra-fontWeights-semibold);height:var(--chakra-sizes-8);min-width:var(--chakra-sizes-8);font-size:12px;-webkit-padding-start:var(--chakra-space-3);padding-inline-start:var(--chakra-space-3);-webkit-padding-end:var(--chakra-space-3);padding-inline-end:var(--chakra-space-3);background:inherit;margin-top:3px;cursor:pointer;}.css-1vmjtia:focus,.css-1vmjtia[data-focus]{box-shadow:0;}.css-1vmjtia[disabled],.css-1vmjtia[aria-disabled=true],.css-1vmjtia[data-disabled]{opacity:0.4;cursor:not-allowed;box-shadow:var(--chakra-shadows-none);}.css-1vmjtia:hover,.css-1vmjtia[data-hover]{background:none;}@media screen and (min-width: 30em){.css-1vmjtia{font-size:17px;}}.css-1vmjtia:active,.css-1vmjtia[data-active]{background:none;}@media screen and (max-width: 1146px){.css-1vmjtia{-webkit-padding-start:0px;padding-inline-start:0px;-webkit-padding-end:0px;padding-inline-end:0px;}}@media screen and (max-width: 1101px){.css-1vmjtia{-webkit-padding-start:inherit;padding-inline-start:inherit;-webkit-padding-end:inherit;padding-inline-end:inherit;}}</style><button type="button" class="chakra-button css-1vmjtia" title="Comments"><style data-emotion="css ktvjz1">.css-ktvjz1{-webkit-margin-end:0.5rem;margin-inline-end:0.5rem;}</style><span class="chakra-button__icon css-ktvjz1"><style data-emotion="css wfucoj">.css-wfucoj{width:var(--chakra-sizes-4);height:var(--chakra-sizes-4);display:inline-block;line-height:1em;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;color:700;vertical-align:middle;margin-top:-4px;margin-right:-6px;}@media screen and (min-width: 30em){.css-wfucoj{width:var(--chakra-sizes-5);height:var(--chakra-sizes-5);}}</style><svg viewbox="0 0 24 24" focusable="false" class="chakra-icon css-wfucoj" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewbox="0 0 24 24" fill="none"><path d="M12 20C16.9706 20 21 16.4183 21 12C21 7.58172 16.9706 4 12 4C7.02944 4 3 7.58172 3 12C3 13.5743 3.51156 15.0423 4.39499 16.28L3 20L7.74467 19.0511C9.01172 19.6565 10.4607 20 12 20Z" stroke="#777" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"/></svg></svg></span>4</button><style data-emotion="css 15p9n5u">.css-15p9n5u{height:24px;}</style><div class="css-15p9n5u"><style data-emotion="css u5l6o5">.css-u5l6o5{opacity:0.6;border:0;border-color:#9b9fa9;border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-u5l6o5"/></div><style data-emotion="css 16k8png">.css-16k8png{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-appearance:none;-moz-appearance:none;-ms-appearance:none;appearance:none;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;-webkit-transition:all 250ms;transition:all 250ms;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;position:relative;white-space:nowrap;vertical-align:middle;outline:none;width:auto;line-height:1.2;border-radius:var(--chakra-radii-md);font-weight:var(--chakra-fontWeights-semibold);height:var(--chakra-sizes-8);min-width:var(--chakra-sizes-8);font-size:12px;-webkit-padding-start:var(--chakra-space-3);padding-inline-start:var(--chakra-space-3);-webkit-padding-end:var(--chakra-space-3);padding-inline-end:var(--chakra-space-3);background:inherit;cursor:pointer;}.css-16k8png:focus,.css-16k8png[data-focus]{box-shadow:0;}.css-16k8png[disabled],.css-16k8png[aria-disabled=true],.css-16k8png[data-disabled]{opacity:0.4;cursor:not-allowed;box-shadow:var(--chakra-shadows-none);}.css-16k8png:hover,.css-16k8png[data-hover]{background:none;}@media screen and (min-width: 30em){.css-16k8png{font-size:17px;}}.css-16k8png:active,.css-16k8png[data-active]{background:none;}@media screen and (max-width: 1146px){.css-16k8png{-webkit-padding-start:0px;padding-inline-start:0px;-webkit-padding-end:0px;padding-inline-end:0px;}}@media screen and (max-width: 1101px){.css-16k8png{-webkit-padding-start:inherit;padding-inline-start:inherit;-webkit-padding-end:inherit;padding-inline-end:inherit;}}</style><button type="button" class="chakra-button css-16k8png" title="Solutions"><span class="chakra-button__icon css-ktvjz1"><style data-emotion="css 8gliu5">.css-8gliu5{width:var(--chakra-sizes-4);height:var(--chakra-sizes-4);display:inline-block;line-height:1em;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;color:#1EA000;vertical-align:middle;margin-right:-6px;}@media screen and (min-width: 30em){.css-8gliu5{width:var(--chakra-sizes-5);height:var(--chakra-sizes-5);}}</style><svg viewbox="0 0 24 24" focusable="false" class="chakra-icon css-8gliu5" aria-hidden="true"><svg viewbox="0 0 17 17" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M4.26701 1.45496C4.91008 1.40364 5.52057 1.15077 6.01158 0.732335C7.15738 -0.244112 8.84262 -0.244112 9.98842 0.732335C10.4794 1.15077 11.0899 1.40364 11.733 1.45496C13.2336 1.57471 14.4253 2.76636 14.545 4.26701C14.5964 4.91008 14.8492 5.52057 15.2677 6.01158C16.2441 7.15738 16.2441 8.84262 15.2677 9.98842C14.8492 10.4794 14.5964 11.0899 14.545 11.733C14.4253 13.2336 13.2336 14.4253 11.733 14.545C11.0899 14.5964 10.4794 14.8492 9.98842 15.2677C8.84262 16.2441 7.15738 16.2441 6.01158 15.2677C5.52057 14.8492 4.91008 14.5964 4.26701 14.545C2.76636 14.4253 1.57471 13.2336 1.45496 11.733C1.40364 11.0899 1.15077 10.4794 0.732335 9.98842C-0.244112 8.84262 -0.244112 7.15738 0.732335 6.01158C1.15077 5.52057 1.40364 4.91008 1.45496 4.26701C1.57471 2.76636 2.76636 1.57471 4.26701 1.45496ZM11.7071 6.70711C12.0976 6.31658 12.0976 5.68342 11.7071 5.29289C11.3166 4.90237 10.6834 4.90237 10.2929 5.29289L7 8.58579L5.70711 7.29289C5.31658 6.90237 4.68342 6.90237 4.29289 7.29289C3.90237 7.68342 3.90237 8.31658 4.29289 8.70711L6.29289 10.7071C6.68342 11.0976 7.31658 11.0976 7.70711 10.7071L11.7071 6.70711Z" fill="#078604"/></svg></svg></span>1</button><style data-emotion="css 17xejub">.css-17xejub{-webkit-flex:1;-ms-flex:1;flex:1;justify-self:stretch;-webkit-align-self:stretch;-ms-flex-item-align:stretch;align-self:stretch;}</style><div spacing="0" align="stretch" class="css-17xejub"/><style data-emotion="css 10jkc2x">.css-10jkc2x{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-flex-direction:row;-ms-flex-direction:row;flex-direction:row;height:45px;max-width:275px;padding-right:5px;}.css-10jkc2x>*:not(style)~*:not(style){margin-top:0px;-webkit-margin-end:0px;margin-inline-end:0px;margin-bottom:0px;-webkit-margin-start:0.5rem;margin-inline-start:0.5rem;}@media screen and (max-width: 1250px){.css-10jkc2x{padding-right:0px;}}</style><div class="chakra-stack css-10jkc2x"><div class="css-0"><img class="avatar" src="https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif" alt="Avatar of undefined"/></div><style data-emotion="css tmdwry">.css-tmdwry{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:start;-webkit-box-align:start;-ms-flex-align:start;align-items:start;-webkit-flex-direction:column;-ms-flex-direction:column;flex-direction:column;height:75%;}.css-tmdwry>*:not(style)~*:not(style){margin-top:0px;-webkit-margin-end:0px;margin-inline-end:0px;margin-bottom:0px;-webkit-margin-start:0px;margin-inline-start:0px;}</style><div class="chakra-stack css-tmdwry"><style data-emotion="css 1b4l9yh">.css-1b4l9yh{height:20px;color:var(--chakra-colors-gray-700);font-size:11px;font-weight:600;}</style><div class="css-1b4l9yh">Last Comment</div><style data-emotion="css 1wjumf6">.css-1wjumf6{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-flex-direction:row;-ms-flex-direction:row;flex-direction:row;font-size:11px;max-width:210px;height:10px;}.css-1wjumf6>*:not(style)~*:not(style){margin-top:0px;-webkit-margin-end:0px;margin-inline-end:0px;margin-bottom:0px;-webkit-margin-start:5px;margin-inline-start:5px;}@media screen and (max-width: 768px){.css-1wjumf6{max-width:175px;}}</style><div class="chakra-stack css-1wjumf6"><style data-emotion="css 1y32vh0">.css-1y32vh0{font-weight:600;color:var(--chakra-colors-blue-600);max-width:105px;white-space:nowrap;overflow:hidden;text-overflow:ellipsis;}@media screen and (max-width: 1160px){.css-1y32vh0{max-width:80px;}}</style><div class="css-1y32vh0">AxfordA</div><style data-emotion="css 1kp9ddg">.css-1kp9ddg{opacity:0.6;border:0;border-color:var(--chakra-colors-gray-700);border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-1kp9ddg"/><div class="questionFooter__TimeDisplayWrap-wcye1y-1 jKYDiG">8/22/2022 - Mon</div></div></div></div></div></div></div><div id="a14247160" class="solutionComment__SolutionWrapper-sc-1c98d1v-0 cSGvtG solutionCard"><div class="solutionComment__CertifiedSolutionHead-sc-1c98d1v-1 hcxomb"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" fill="currentColor" class="w-6 h-6"><path fill-rule="evenodd" d="M2.25 12c0-5.385 4.365-9.75 9.75-9.75s9.75 4.365 9.75 9.75-4.365 9.75-9.75 9.75S2.25 17.385 2.25 12zm13.36-1.814a.75.75 0 10-1.22-.872l-3.236 4.53L9.53 12.22a.75.75 0 00-1.06 1.06l2.25 2.25a.75.75 0 001.14-.094l3.75-5.25z" clip-rule="evenodd"/></svg>ASKER CERTIFIED SOLUTION</div><div class="solutionComment__AuthorWrapper-sc-1c98d1v-4 jruGKM"><div class="solutionComment__MetaSection-sc-1c98d1v-2 dKmMjE"><div class="lazyload-wrapper "><div style="height:77px" class="lazyload-placeholder"/></div><div class="solutionComment__MetaRight-sc-1c98d1v-3 gXUVYv"><style data-emotion="css 79elbk">.css-79elbk{position:relative;}</style><div class="notFlexed css-79elbk"><a href="/members/diasroshan.html" class="nameDisplay">diasroshan</a><div class="lazyload-wrapper "><div style="height:24px" class="lazyload-placeholder"/></div><style data-emotion="css 1b08fi0">.css-1b08fi0{height:12px;}</style><div class="headerMetaDivider css-1b08fi0"><style data-emotion="css 1bdoq9b">.css-1bdoq9b{opacity:0.6;border:0;border-color:#2C2E31;border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-1bdoq9b"/></div><time datetime="2005-06-18T05:03:17Z" class="submitDate">6/17/2005</time></div></div></div><div class="solutionComment__ObscuredCopy-sc-1c98d1v-5 cUkemn"><div class="lazyload-wrapper "><div style="height:120px" class="lazyload-placeholder"/></div></div></div><div id="blockerCTA" class="solutionComment__CommentWrapper-sc-1c98d1v-7 fLwhqr"><div class="solutionComment__ContentBlock-sc-1c98d1v-8 iRRoFI"><div class="solutionComment__MembersOnlyHeading-sc-1c98d1v-9 hTHJZK"><svg viewbox="0 0 17 17" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M4.26701 1.45496C4.91008 1.40364 5.52057 1.15077 6.01158 0.732335C7.15738 -0.244112 8.84262 -0.244112 9.98842 0.732335C10.4794 1.15077 11.0899 1.40364 11.733 1.45496C13.2336 1.57471 14.4253 2.76636 14.545 4.26701C14.5964 4.91008 14.8492 5.52057 15.2677 6.01158C16.2441 7.15738 16.2441 8.84262 15.2677 9.98842C14.8492 10.4794 14.5964 11.0899 14.545 11.733C14.4253 13.2336 13.2336 14.4253 11.733 14.545C11.0899 14.5964 10.4794 14.8492 9.98842 15.2677C8.84262 16.2441 7.15738 16.2441 6.01158 15.2677C5.52057 14.8492 4.91008 14.5964 4.26701 14.545C2.76636 14.4253 1.57471 13.2336 1.45496 11.733C1.40364 11.0899 1.15077 10.4794 0.732335 9.98842C-0.244112 8.84262 -0.244112 7.15738 0.732335 6.01158C1.15077 5.52057 1.40364 4.91008 1.45496 4.26701C1.57471 2.76636 2.76636 1.57471 4.26701 1.45496ZM11.7071 6.70711C12.0976 6.31658 12.0976 5.68342 11.7071 5.29289C11.3166 4.90237 10.6834 4.90237 10.2929 5.29289L7 8.58579L5.70711 7.29289C5.31658 6.90237 4.68342 6.90237 4.29289 7.29289C3.90237 7.68342 3.90237 8.31658 4.29289 8.70711L6.29289 10.7071C6.68342 11.0976 7.31658 11.0976 7.70711 10.7071L11.7071 6.70711Z" fill="#078604"/></svg><span>THIS SOLUTION ONLY AVAILABLE TO MEMBERS.</span></div><div class="solutionComment__Heading-sc-1c98d1v-10 dHAmvB">View this solution by signing up for a free trial.</div><div class="solutionComment__UnansweredText-sc-1c98d1v-13 hPMmhd">Members can start a<!-- --> <!-- -->7-Day free trial<!-- --> <!-- -->and enjoy unlimited access to the platform.</div><div class="solutionComment__ButtonSection-sc-1c98d1v-11 ciydZt"><style data-emotion="css 1h7v26a">.css-1h7v26a{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-appearance:none;-moz-appearance:none;-ms-appearance:none;appearance:none;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;-webkit-transition:all 250ms;transition:all 250ms;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;position:relative;white-space:nowrap;vertical-align:middle;outline:none;width:auto;line-height:1.2;border-radius:var(--chakra-radii-md);font-weight:var(--chakra-fontWeights-semibold);height:var(--chakra-sizes-10);min-width:var(--chakra-sizes-10);font-size:var(--chakra-fontSizes-md);-webkit-padding-start:var(--chakra-space-4);padding-inline-start:var(--chakra-space-4);-webkit-padding-end:var(--chakra-space-4);padding-inline-end:var(--chakra-space-4);background:var(--chakra-colors-gray-100);}.css-1h7v26a:focus,.css-1h7v26a[data-focus]{box-shadow:var(--chakra-shadows-outline);}.css-1h7v26a[disabled],.css-1h7v26a[aria-disabled=true],.css-1h7v26a[data-disabled]{opacity:0.4;cursor:not-allowed;box-shadow:var(--chakra-shadows-none);}.css-1h7v26a:hover,.css-1h7v26a[data-hover]{background:var(--chakra-colors-gray-200);}.css-1h7v26a:hover[disabled],.css-1h7v26a[data-hover][disabled],.css-1h7v26a:hover[aria-disabled=true],.css-1h7v26a[data-hover][aria-disabled=true],.css-1h7v26a:hover[data-disabled],.css-1h7v26a[data-hover][data-disabled]{background:var(--chakra-colors-gray-100);}.css-1h7v26a:active,.css-1h7v26a[data-active]{background:var(--chakra-colors-gray-300);}</style><a class="chakra-button pricingButton blockerButtons link-with-ref-id css-1h7v26a" href="https://go.experts-exchange.com/pricing?mixedRegTrack=SolutionBlocker_Pricing&refType=question&refId=21462624&redirect=https%3A%2F%2Fwww.experts-exchange.com%2Fquestions%2F21462624%2FPowerbuilder-Error-Array-boundary-exceeded-at-line-23-in-open-event-of-object-w-available-drivers.html">See Pricing Options</a><div class="solutionComment__ButtonSpacer-sc-1c98d1v-12 gsDNtj"/><style data-emotion="css 1h7v26a">.css-1h7v26a{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-appearance:none;-moz-appearance:none;-ms-appearance:none;appearance:none;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;-webkit-transition:all 250ms;transition:all 250ms;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;position:relative;white-space:nowrap;vertical-align:middle;outline:none;width:auto;line-height:1.2;border-radius:var(--chakra-radii-md);font-weight:var(--chakra-fontWeights-semibold);height:var(--chakra-sizes-10);min-width:var(--chakra-sizes-10);font-size:var(--chakra-fontSizes-md);-webkit-padding-start:var(--chakra-space-4);padding-inline-start:var(--chakra-space-4);-webkit-padding-end:var(--chakra-space-4);padding-inline-end:var(--chakra-space-4);background:var(--chakra-colors-gray-100);}.css-1h7v26a:focus,.css-1h7v26a[data-focus]{box-shadow:var(--chakra-shadows-outline);}.css-1h7v26a[disabled],.css-1h7v26a[aria-disabled=true],.css-1h7v26a[data-disabled]{opacity:0.4;cursor:not-allowed;box-shadow:var(--chakra-shadows-none);}.css-1h7v26a:hover,.css-1h7v26a[data-hover]{background:var(--chakra-colors-gray-200);}.css-1h7v26a:hover[disabled],.css-1h7v26a[data-hover][disabled],.css-1h7v26a:hover[aria-disabled=true],.css-1h7v26a[data-hover][aria-disabled=true],.css-1h7v26a:hover[data-disabled],.css-1h7v26a[data-hover][data-disabled]{background:var(--chakra-colors-gray-100);}.css-1h7v26a:active,.css-1h7v26a[data-active]{background:var(--chakra-colors-gray-300);}</style><a class="chakra-button CTAbutton blockerButtons link-with-ref-id css-1h7v26a" id="join-link" href="https://www.experts-exchange.com/checkout.jsp?planCode=premium_annually_2018&redirect=%2Fquestions%2F21462624%2FPowerbuilder-Error-Array-boundary-exceeded-at-line-23-in-open-event-of-object-w-available-drivers.html%3FanchorAnswerId%3D14247160&mixedRegTrack=SolutionBlocker&refId=21462624&refType=question">Start Free Trial</a></div></div></div></div><div class="askQuestionCta__VariantWrapper-sc-6zf70-0 dShdZO"><style data-emotion="css kjhuys">.css-kjhuys{display:block;-webkit-appearance:none;-moz-appearance:none;-ms-appearance:none;appearance:none;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;-webkit-transition:all 250ms;transition:all 250ms;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;position:relative;white-space:normal;vertical-align:middle;outline:none;width:auto;line-height:1.2;border-radius:4px;font-weight:var(--chakra-fontWeights-semibold);height:auto;min-width:var(--chakra-sizes-10);font-size:var(--chakra-fontSizes-md);-webkit-padding-start:var(--chakra-space-4);padding-inline-start:var(--chakra-space-4);-webkit-padding-end:var(--chakra-space-4);padding-inline-end:var(--chakra-space-4);background:#edffd7;padding:26px;margin-top:30px;border:1px solid #dbdde2;}.css-kjhuys:focus,.css-kjhuys[data-focus]{box-shadow:var(--chakra-shadows-outline);}.css-kjhuys[disabled],.css-kjhuys[aria-disabled=true],.css-kjhuys[data-disabled]{opacity:0.4;cursor:not-allowed;box-shadow:var(--chakra-shadows-none);}.css-kjhuys:hover,.css-kjhuys[data-hover]{background:#CFF9BC;}.css-kjhuys:active,.css-kjhuys[data-active]{background:var(--chakra-colors-gray-300);}</style><a class="chakra-button askQuestionCta link-with-ref-id css-kjhuys" id="askQuestionCta" href="https://go.experts-exchange.com/pricing?mixedRegTrack=LO_Solution_Inline_AskYourOwn&refType=question&refId=21462624&redirect=https%3A%2F%2Fwww.experts-exchange.com%2Fquestions%2F21462624%2FPowerbuilder-Error-Array-boundary-exceeded-at-line-23-in-open-event-of-object-w-available-drivers.html"><style data-emotion="css pyim7d">.css-pyim7d{font-size:14px;font-weight:700;line-height:20px;color:#078604;}</style><div class="css-pyim7d"><svg viewbox="0 0 40 40" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M13.125 18.5L16.7083 22.0833L23.875 14.9166M11.0372 5.4155C12.3228 5.31291 13.5432 4.80738 14.5248 3.97088C16.8154 2.01882 20.1845 2.01882 22.4751 3.97088C23.4567 4.80738 24.6771 5.31291 25.9627 5.4155C28.9627 5.6549 31.345 8.03717 31.5844 11.0372C31.687 12.3228 32.1925 13.5432 33.029 14.5248C34.9811 16.8154 34.9811 20.1845 33.029 22.4751C32.1925 23.4567 31.687 24.6771 31.5844 25.9627C31.345 28.9627 28.9627 31.345 25.9627 31.5844C24.6771 31.687 23.4567 32.1925 22.4751 33.029C20.1845 34.9811 16.8154 34.9811 14.5248 33.029C13.5432 32.1925 12.3228 31.687 11.0372 31.5844C8.03717 31.345 5.6549 28.9627 5.4155 25.9627C5.31291 24.6771 4.80738 23.4567 3.97088 22.4751C2.01882 20.1845 2.01882 16.8154 3.97088 14.5248C4.80738 13.5432 5.31291 12.3228 5.4155 11.0372C5.6549 8.03717 8.03717 5.6549 11.0372 5.4155Z" stroke="#65676b" stroke-width="3" stroke-linecap="round" stroke-linejoin="round"/></svg><span>GET A PERSONALIZED SOLUTION</span></div><style data-emotion="css pv8oh5">.css-pv8oh5{font-size:20px;font-weight:700;line-height:32px;margin-bottom:2px;color:#2C2E31;}</style><div class="css-pv8oh5">Ask your own question & get feedback from real experts</div><style data-emotion="css 1o7sphg">.css-1o7sphg{font-size:14px;font-weight:400;line-height:20px;color:#4E5259;}</style><div class="css-1o7sphg">Find out why thousands trust the EE community with their toughest problems.</div></a></div><div id="a14248934" class="commentCard__CardWrapper-urxmpo-0 mugGS commentCard"><div class="commentCard__AuthorWrapper-urxmpo-3 kUYDQw"><div class="commentCard__MetaSection-urxmpo-1 cDLsha"><div class="lazyload-wrapper "><div style="height:30px" class="lazyload-placeholder"/></div><div class="commentCard__MetaRight-urxmpo-2 haCfBO"><div class="css-0"><div class="metaSubWrap css-0"><div class="nameDisplay">pemurray</div><style data-emotion="css 1b08fi0">.css-1b08fi0{height:12px;}</style><div class="metaDivider css-1b08fi0"><style data-emotion="css 1bdoq9b">.css-1bdoq9b{opacity:0.6;border:0;border-color:#2C2E31;border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-1bdoq9b"/></div><time datetime="2005-06-18T15:04:39Z" class="submitDate">6/18/2005</time></div><style data-emotion="css 179faxr">.css-179faxr{display:inline-block;-webkit-flex:0 0 auto;-ms-flex:0 0 auto;flex:0 0 auto;min-width:0px;-webkit-margin-end:5px;margin-inline-end:5px;}</style><div class="chakra-stack__item css-179faxr"><style data-emotion="css 1qqage7">.css-1qqage7{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;border-radius:4px;height:18px;width:57px;border:1px solid;color:var(--chakra-colors-blue-800);border-color:var(--chakra-colors-blue-300);font-size:10px;font-weight:600;background:#d2e7f8;padding-right:0px;}@media screen and (min-width: 30em){.css-1qqage7{padding-right:5px;}}</style><div title="Question Asker" class="askerTag css-1qqage7"><style data-emotion="css 1jatiol">.css-1jatiol{width:auto;height:12px;display:inline-block;line-height:1em;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;color:currentColor;}</style><svg width="18" height="18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.4 7.11538C9.4 8.00754 8.66127 8.73077 7.75 8.73077C6.83873 8.73077 6.1 8.00754 6.1 7.11538C6.1 6.22323 6.83873 5.5 7.75 5.5C8.66127 5.5 9.4 6.22323 9.4 7.11538Z" fill="#0054A2"/><path d="M7.75 9.26923C9.26878 9.26923 10.5 10.4746 10.5 11.9615V12.5H5V11.9615C5 10.4746 6.23122 9.26923 7.75 9.26923Z" fill="#0054A2"/><path fill-rule="evenodd" clip-rule="evenodd" d="M13 7.5C13 8.32843 12.3548 9 11.5588 9C11.239 9 10.9435 8.89155 10.7044 8.70806C10.5447 8.58552 9.91176 8.57143 9.5 8.25C10.1176 7.92857 10.1177 7.77322 10.1177 7.5C10.1177 6.67157 10.7629 6 11.5588 6C12.3548 6 13 6.67157 13 7.5ZM11.5588 6.9375C11.4924 6.9375 11.4341 6.97485 11.4027 7.03139C11.3529 7.12102 11.2427 7.15165 11.1565 7.0998C11.0704 7.04795 11.041 6.93325 11.0908 6.84361C11.184 6.67597 11.3586 6.5625 11.5588 6.5625C11.8573 6.5625 12.0993 6.81434 12.0993 7.125C12.0993 7.36992 11.9489 7.57827 11.739 7.65549V7.6875C11.739 7.79105 11.6583 7.875 11.5588 7.875C11.4593 7.875 11.3787 7.79105 11.3787 7.6875V7.5C11.3787 7.39645 11.4593 7.3125 11.5588 7.3125C11.6583 7.3125 11.739 7.22855 11.739 7.125C11.739 7.02145 11.6583 6.9375 11.5588 6.9375ZM11.5588 8.4375C11.6583 8.4375 11.739 8.35355 11.739 8.25C11.739 8.14645 11.6583 8.0625 11.5588 8.0625C11.4593 8.0625 11.3787 8.14645 11.3787 8.25C11.3787 8.35355 11.4593 8.4375 11.5588 8.4375Z" fill="#0054A2"/></svg><span class="askerText">ASKER</span></div></div></div></div></div></div><div class="commentBody__CommentBodyWrapper-qtsrh5-0 fhlaeB wysiwyg-content"><div class="content wysiwyg-content fr-view"><div> Rosh,<br/> You were right on the money. Thanks!!<br/> Can you tell me WHY there was problem?<br/> Thank you again (I was nauseous over that one).<br/> </div></div></div><div id="a14250647" class="commentCard__CardWrapper-urxmpo-0 mugGS commentCard"><div class="commentCard__AuthorWrapper-urxmpo-3 kUYDQw"><div class="commentCard__MetaSection-urxmpo-1 cDLsha"><div class="lazyload-wrapper "><div style="height:30px" class="lazyload-placeholder"/></div><div class="commentCard__MetaRight-urxmpo-2 haCfBO"><div class="css-0"><div class="metaSubWrap css-0"><div class="nameDisplay">diasroshan</div><div class="lazyload-wrapper "><div style="height:24px" class="lazyload-placeholder"/></div><style data-emotion="css 1b08fi0">.css-1b08fi0{height:12px;}</style><div class="metaDivider css-1b08fi0"><style data-emotion="css 1bdoq9b">.css-1bdoq9b{opacity:0.6;border:0;border-color:#2C2E31;border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-1bdoq9b"/></div><time datetime="2005-06-19T04:45:22Z" class="submitDate">6/18/2005</time></div></div></div></div></div><div class="commentBody__CommentBodyWrapper-qtsrh5-0 fhlaeB wysiwyg-content"><div class="content wysiwyg-content fr-view"><div> the problem is simply bcoz in PB array size starts with ONE...<br/> as per ur code below....<br/> for i = 1 to rows<br/> driver_number = ds_1.getitemstring(i, "dr_no")<br/> ni = i - 1<br/> if not isnull(driver_number) then<br/> rez_drivers[ni] = trim(driver_number) ----IT BLOWS UP HERE---<br/> end if<br/> in ur first loop the value of ni was '0' (ni = i - 1 ..... ie ni = 1 - 1 , ni = 0 ).... hence the array boundary was out of range...<br/> Cheers,<br/> </div></div></div><div id="a14256580" class="commentCard__CardWrapper-urxmpo-0 mugGS commentCard"><div class="commentCard__AuthorWrapper-urxmpo-3 kUYDQw"><div class="commentCard__MetaSection-urxmpo-1 cDLsha"><div class="lazyload-wrapper "><div style="height:30px" class="lazyload-placeholder"/></div><div class="commentCard__MetaRight-urxmpo-2 haCfBO"><div class="css-0"><div class="metaSubWrap css-0"><div class="nameDisplay">AxfordA</div><style data-emotion="css 1b08fi0">.css-1b08fi0{height:12px;}</style><div class="metaDivider css-1b08fi0"><style data-emotion="css 1bdoq9b">.css-1bdoq9b{opacity:0.6;border:0;border-color:#2C2E31;border-style:solid;border-left-width:1px;height:100%;}</style><hr aria-orientation="vertical" class="chakra-divider css-1bdoq9b"/></div><time datetime="2005-06-20T13:41:43Z" class="submitDate">6/20/2005</time></div></div></div></div></div><div class="commentBody__CommentBodyWrapper-qtsrh5-0 fhlaeB wysiwyg-content"><div class="content wysiwyg-content fr-view"><div> Why use n+1?<br/> if rows > 0 then<br/> for i = 1 to rows<br/> driver_number = ds_1.getitemstring(i, "dr_no")<br/> if not isnull(driver_number) then<br/> rez_drivers[i] = trim(driver_number) ----IT BLOWS UP HERE---<br/> end if<br/> //get out nothing to do <br/>
推荐文章