hmmm. might work. I'll have to try it just to see, but I'll most likely go with switching field orders, since I'd rather not do a double TRANS, in case the file I'm scanning gets a lot bigger, then processing time will be significant.
Thanks George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Bob Woodward > Sent: Thursday, October 07, 2010 7:22 PM > To: U2 Users List > Subject: Re: [U2] Stumped with TRANS... > > Can you chain two TRANS functions and compare the results? If you use > "C" the first time and "X" the second time then you would be able to > know if there is no record when the two results are different. If the > record doesn't exist, you would only have @ID in the first result but > the second result would be blank. If the record does exist and the > field you are getting is the key value, then the first AND second > results would be equal, both containing @ID. > > BobW > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
