Hi Ron,
This is the issue of "non-reversible conversions".
When you do a query such as
SELECT BILLS WITH DATE = "12 Jan 09"
the query processor converts the 12 Jan 09 to its internal form and does all
comparisons on this. Exactly the same happens for any other field with a
conversion code - the comparisons use internal form data.
Your query:
SELECT BILLS WITH QUARTER = "1"
won't work because the value 1 cannot be converted to an internal date.
So, queries of this form only work with "reversible" conversions.
Using an I-type to do the conversion as part of the evaluated expression
instead of as a conversion code in dictionary field 3 gets around this
issue.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/