Strangely query does not seem to properly handle a zoned field as a key
when doing wild card retrievals in query. Consider the following;
ITEMS:
CLIENT-EMP-NUM, Z12 <<SEARCH,INDEX ITEM>>
>F CLIENT-EMP-NUM >= 000220000000 AND CLIENT-EMP-NUM < 000230000000
369 ENTRIES QUALIFIED
>F CLIENT-EMP-NUM = "00022@"
0 ENTRIES QUALIFIED
>F CLIENT-EMP-NUM = 00022@
0 ENTRIES QUALIFIED
>F CLIENT-EMP-NUM = "22@"
0 ENTRIES QUALIFIED
>F CLIENT-EMP-NUM = 22@
0 ENTRIES QUALIFIED
We had some problems using MS ACCESS with an ODBC driver and Z type keys
because of confusion on the spec circulated by HP. The ODBC vendor fixed
the
problem very quickly, but maybe QUERY suffers from the same problem?
any ideas?
thanks,
shawn