Link fails on VMS Date column

Drewbrook, Neil EDUC:EX Neil.Drewbrook@gems3.gov.bc.ca
Fri, 25 Feb 2005 14:35:56 -0800


This issue is specific to OracleRdb on VMS.

I'm trying to link to a table using an index, but the link fails when a
matching record does exist.  In the example below, the link should succeed
for every record; each row should join to itself.  It also fails in Quick

R_DATE is Date VMS; it is the first column in an index.
I've dropped and re-created the index. 
Joining the table to itself using SQL works correctly.
Other tables with indexes on Date VMS columns link to themselves correctly
using quiz.

> access TABLE_1
> go

Records selected: 24623

> acc TABLE_1  link R_DATE  to R_DATE  of TABLE_1 alias a1
> go

Records selected: 8


Any ideas?