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
