My answer to "Which is better" would be "it depends". If you're looking for run-time performance and disk is not an issue, go with the first. Although having duplicate data leaves a bad taste in most of our mouths, the purpose of the computer is to do the "grunt work" for us. Sometimes elegance has to take a back seat.
If disk space and records sizes are more important, the latter is a better answer. My 2 cents. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, August 24, 2007 8:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [ud] Question on Alpha Sorting... The issue for me is that I am using the list of employees within a program - so Virtual Dictionaries are not an option - displaying the data. I certainly don't want to sort it on use each time, which means I need to do an insert BY "AL" -- but in order to do that I have to have the list ready on read, but I insert names into the list one at a time -- hence I throught I would have to maintain two attributes -- one 'as keyed' and one in 'sort case' -- my other choice is to UPCASE the 'as keyed' each time I have to do an insert. I guess that's my question: Which is better Write a record with two sets of data, one 'as typed' one strictly for sorting, so that on the next insert, I just create a sort version of the new name, and insert it in both lists. The downside here is the record is larger. OR Use UPCASE on each need to insert to build the 'insert array' as needed, find the insert position in that array, then insert the 'AsTyped'. The downside to me was having to UPCASE each time an insert is needed. I'm trying to figure out the lesser of the evils! > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett > Sent: Friday, August 24, 2007 5:48 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [ud] Question on Alpha Sorting... > > David: > > Create a virtual dictionary that upper cases the name. Then > you sort by the UCNAME but display the normal name. This > works for me. > > Bill ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. 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 strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
