Well, then, Sami, I'd say it's worth $5.00. Remind us again who we should make the checks (there are lots pending to be written, right?) out to and the deadline for mailing it to you, I assume at your 'lovely home' address of 19312 W 63rd Terr, Shawnee KS 66218. ~Claudine ;)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sami Aaron Sent: Friday, January 31, 2003 1:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: OPEN cursor RESET Claudine - We're just at $.25 for regular DUH's - but, as you stated, this is a major DUH - so you tell me... <g> Sami ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 12:28 PM Subject: [RBASE-L] - RE: OPEN cursor RESET > Well, Ben, pardon me while I fall off my chair! This is so obvious, but > like I said this was coded many years ago and I never again looked at it > until the open cursor tripped up... And it works just the way you wrote > it since it is really just a simple lookup. > > I do love this list!!! Thanks, that's a major duh removed from my > skull! Sami, let me know how much this one cost me... > > Now, let me read through my code all over again... > > ~Claudine :) > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ben > Petersen > Sent: Friday, January 31, 2003 4:16 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: OPEN cursor RESET > > Hi Claudine, > > This caught my attention also since cursors as usually associated > with loops. But was a little stumped when there was no where > clause with the update. > > Would > > Update wsOrder Set CustName = Rolodex.co_Name + > from Rolodex, WsOrder + > Whe Rolodex.co_Code = wsOrder.CustCode > > do the same thing as the first block? Assuming I've got the syntax > right (I always struggle a bit with these) and assuming Update > allows referencing the same table as target and source... > > Ben Petersen > > > >
