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?