**
Actually I validate with a $MENU$ check. I just don't store the record ID of the validation record in my address, I keep the real state code.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Palermo, Shelia D ERDC-ITL-MS Contractor
Sent: Wednesday, August 11, 2004 8:29 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: OT:Remedy Annoyances
**
Why not set the field to be call caps, then all you have to worry about is typos.
Shelia
-----Original Message-----
From: Burkholder Anthony O Contr 83 CS/SCZA
[ mailto:Anthony.Burkholder@LANGLEY.AF.MIL]
Sent: Wednesday, August 11, 2004 5:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: OT:Remedy Annoyances
My 2 cents,
The real reason to use a separate table to store state information (or
similar static data) is to prevent users from making the following kinds of
entries; VA, va, Va, vA, VG, VI, etc for Virginia. The problem isn't how
often the states have changed its how many ways will a user enter the data.
In the example above a search for all Virginia related items would be a
nightmare. The trouble saved is well worth the 4 bytes.
Anthony O. Burkholder
AOC Weapons System Database Administrator
Dynamics Research Corporation
(757) 225-7110 / DSN 575-7110
Email: anthony.burkholder@langley.af.mil
SIPR Email: anthony.burkholder@c2fs.acc.af.smil.mil
-----Original Message-----
From: Grooms, Frederick W [ mailto:frederick.w.grooms@XO.COM]
Sent: Tuesday, August 10, 2004 6:09 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: OT:Remedy Annoyances
Of course this is not a problem when you have custom apps :)
You are correct on healthy balance. I have a couple of systems (not Remedy)
that I have to pull data from that overkill on normalization. i.e. The
state code in an address is in a separate table and all that is stored with
the address is a pointer to the correct row in the master list. I mean how
many times has the government changed the abbreviation for a state? Why
waste 4 (or more) bytes of space for a 2 byte character?
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[ mailto:ARSLIST@ARSLIST.ORG] On Behalf Of Axton W Grams/NYLIC
Sent: Tuesday, August 10, 2004 3:30 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: OT:Remedy Annoyances
1. Too many copies of the same data. When will Remedy implement a healthy
balance between a relational and copy model. There are situations where one
is definitely a better choice over the other, so why not give the option? 2.
When will login names be internally represented as a GUID so login names can
be changed without requiring 4 trillion data elements to be updated. (This
in part goes back to my first annoyance) 3. Better db utilization. Throw
the C programmers and dba's in the same room until they come up with a
product that takes advantage of the features offered by each db. Much of
this could even be done while staying inside the ANSI standards. (Again,
this in part goes back to my first annoyance)
Kind Regards,
Axton Grams
New York Life
Remedy Solutions
Provider
Mobile: 404.861.7273
Work: 770.406.4415
Email: AxtonWGrams@NewYorkLife.com
|---------+---------------------------->
| | Gidd Calden |
| |
| | TIONS.NET> |
| | Sent by: "Action |
| | Request System |
| | discussion |
| | list(ARSList)" |
| |
| | ORG> |
| | |
| | |
| | 08/10/2004 03:39 |
| | PM |
| | Please respond to|
| | arslist |
| | |
|---------+---------------------------->
>---------------------------------------------------------------------------
---------------------------------------------------|
|
|
| To: ARSLIST@ARSLIST.ORG
|
| cc:
|
| Subject: OT:Remedy Annoyances
|
>---------------------------------------------------------------------------
---------------------------------------------------|
**
Listers,
With Version 6.x poised on the horizon I have to wonder
about some annoyances still in the "core" application like:
1. Checkboxes (don't get me started)
2. Delimiter for a Menu (when append menu selection allowed, i.e. a
semicolon or etc.) 3. Control of an Integer field (i.e. do NOT roll down to
-1, -2, etc.) 4. MENU validation (i.e. allowing us to choose a MENU from a
SQL lookup and
etc.)
5. Controlling a window size in the Mid-Tier (please no Java) 6. Comparing a
Date to a Date Time field 7. AR Admin Tool - how about a progress meter when
importing ? 8. AR Admin Tool - Deleting forms with associations, once I
select delete DELETE ? 9. AR Admin Tool - minimize the tool during import
and (Windows) and it takes the task manager to restore the window ?
While I am all for the next latest and greatest, have any of these been
fixed, repaired or etc.
Anyone have anything to add to this list ?
Regards?Gidd
Glidden L. Calden
BUOYANT SOLUTIONS, INC.
"Keeping business afloat
...in a Sea of Solutions"
Office ( 916.334.0599
Cell ( 916.761.3095
Web 8 http://www.buoyantsolutions.net
E-mail + mailto:gidd@buoyantsolutions.net
Fax ? 916.339.2915
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and confidential.
If the reader of the message is not the intended recipient or an authorized
representative of the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by e-mail
and delete the message and any attachments from your system.
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com This posting was submitted via the Web interface
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com
This posting was submitted via the Web interface
This posting was submitted via the Web interface
Previous Topic
Index