I think it depends on what flavour you are in as well - a number of the older pickies I work with keep forgetting this behaviour so i assume it is newer rather than older... it is rather annoying when you are building up some associated arrays and for some reason a null pops up in the data somewhere - it throws the arrays out of synch
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan McGrath Sent: 03 May 2010 07:13 To: U2 Users List Subject: Re: [U2] <-1> and Null values Actually, I think I've just remembered part of it, but not the rest. Appends an empty string: REC = "A" REC<-1> = "" Doesn't append an empty string: REC = "" REC<-1> = "" Sets REC<2> to an empty string: REC = "A" REC<2,-1> = "" Doesn't append an empty string: REC = "" REC<1,-1> = "" I think my mind hasn't returned from vacation yet... Interesting that it changed in UniVerse though, Kate. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kate Stanton Sent: Monday, May 03, 2010 3:53 PM To: U2 Users List Subject: Re: [U2] <-1> and Null values Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: [email protected] ----- Original Message ----- From: "Dan McGrath" <[email protected]> To: "U2 Users List" <[email protected]> Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] <-1> and Null values > Hi all, > > > > Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that > doing a <-1> to append an empty string would not actually appended > anything. For example: > > > > REC = 'A' > > REC<-1> = '' > > > > Would result in REC equaling 'A', not 'A':@AM > > > > In fact, I even have some in-house tools I wrote that rely on <-1> > trimming out empty strings. Now, it appears in UD 7.2.5 that this is no > longer the case and it does equal 'A':@AM. I've been through all the > release notes and cannot see any changes that would have affected this. > I've also looked through all the UDT.OPTIONS and see nothing relevant... > > > > Am I going crazy or has this indeed changed? > > > > Cheers, > > Dan > > > > > > > ######################################################################## ################### > The information transmitted in this message and attachments (if any) is > intended only > for the person or entity to which it is addressed. The message may contain > confidential > and/or privileged material. Any review, retransmission, dissemination or > other use of > or taking of any action in reliance upon this information by persons or > entities other > than the intended recipient is prohibited. If you received this in error, > please > contact the sender and delete the material from any computer. > > The intended recipient of this e-mail may only use, reproduce, disclose or > distribute > the information contained in this e-mail and any attached files with the > permission of IMB. > ######################################################################## ################### > _______________________________________________ > 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 ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ############################################################################ ############### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ############################################################################ ############### _______________________________________________ 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
