The point? Unnecessary additional complexity not affecting the outcome.
:) My bad.
Although I'm inclined to think that the fact the original poster is
using a SQL query instead of a TCL query might be an indication that
they are not in a position to be creating dictionary items.
Oh, and I think Gordon's example is perfectly acceptable though not
optimally self documenting. Remember that not everyone is living under
your programing standards.
Womack, Adrian wrote:
A couple of points:
Gordon's example: "DATE()[EMAIL PROTECTED]<6>" should really be using a D-type
named field instead of using @RECORD<nn>
Jeff's example: DATE() - ICONV(*YOUR.DATE.FIELD.HERE*,"D4/") - the date
field should already be in internal format, so what's the point of the
ICONV ?
AdrianW
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
==========================
Jeff Schasny
jschasnyATricochetDOTcom
==========================
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/