no. I needed to know when the "" returned data was because the record didn't exist or because it was an empty string, which is what the 'C' option give you, which isn't a problem, unless by chance your returned data just happed to be the same as the @ID (Which in our case was about a 1:100 chance).
George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Kebbon Irwin > Sent: Friday, October 08, 2010 6:25 PM > To: [email protected] > Subject: Re: [U2] Stumped with TRANS... > > > Would using the 'X' option in conjunction with the -1 field not do what > you want. No record so @1 is null, else read successful. Unless, of > course you have empty records with just @ID.... > > > From: [email protected] > > To: [email protected] > > Date: Fri, 8 Oct 2010 10:34:07 -0500 > > Subject: Re: [U2] Stumped with TRANS... > > > > When you use the 'C' parameter, Trans will return the record ID if > the record does not exist, > > and the full record if it does exist (in my case it did, since I used > -1 as the field). > > > > Problem is that occaisionally, the full record was only 1 attribute, > and that attribute > > just happened to have the value that was the same as the @ID, making > it impossible to > > tell the difference between a valid attribute data vs the TRANS's > "error" reporting method. > > > > George > > > > > -----Original Message----- > > > From: [email protected] [mailto:u2-users- > > > [email protected]] On Behalf Of Kebbon Irwin > > > Sent: Friday, October 08, 2010 11:31 AM > > > To: [email protected] > > > Subject: Re: [U2] Stumped with TRANS... > > > > > > > > > Why not read the whole record in with the TRANS and then check <1> > > > using EXTRACT? > > > > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
