[MAYBE SPAM] Link fails on VMS Date column

[Chris Sharman]

Drewbrook, Neil EDUC:EX wrote:

> 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

Is it a locking problem ?
Would the 8 you are seeing correspond to a few non-unique datestamps in 
the data ? If not, it's very odd to see 8 out of 24k rather than 0.
Quiz really shouldn't exhibit locking problems - I'd only expect them in 
Quick & qtp. However, I'm blissfully ignorant of Oracle/rdb.

Chris

> 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?
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> --------------------------------------------------------------------------------
> Date: Fri, 25 Feb 2005 14:35:56 -0800
> 
> .
> 



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.