Link fails on VMS Date column

[Joe Boyle]

the access statement that I wrote on Friday was a bit on the loose side, I
was thinking of cursors along the lines below, and only to see if this
created more links,

can cle

declare mdat  cursor for &
select count(*) as mycnt from cust_orders a, cust_orders b 

acc mdat where (trunc(a.cust_order_date)  &
= trunc(b.cust_order_date)  and a.cust_order_date is not null )

rep all

go


Regards, Joe.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Joe Boyle
Sent: 26 February 2005 00:45
To: 'Drewbrook, Neil EDUC:EX'; powerh-l@lists.sowder.com
Subject: RE: Link fails on VMS Date column

my knowledge of rdb datatypes is pretty slim, could a timestamp be playing a
part in the problem, and would code (pseudo) along the lines below help ?

acc TABLE_1  link truncate (R_DATE)  &
to truncate (R_DATE ) of TABLE_1 alias a1

Regards, Joe.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Drewbrook, Neil
EDUC:EX
Sent: 25 February 2005 22:36
To: 'powerh-l@lists.sowder.com'
Subject: Link fails on VMS Date column

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?
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.