Re: Date Data Type in Index

From: dreder <deredes_at_hotmail.com>
Date: 13 Oct 1999 08:43:05 -0500
Message-ID: <Z_%M3.7751$yn1.197023@newscene.newscene.com>

Not in Oracle, but MS Access does have aproblem with having either a datetimestamp, null or float in an index. If happens when doing ODBC to an Oracle table, and also natively. Basically if works fine as long as you don't touch the underlying oracle table, if you trunc or delete or insert , Acess will be unable to see rows anymore will give a #Deleted error

In article <7tmbpv$ul2$1_at_nntp4.atl.mindspring.net>, "Charlie Briney" <cbriney_at_mindspring.com> wrote:
>I have been told there is a problem using a column which is a date data type
>in an index. The person telling me this did not know what that problem is.
>Does anyone know what problem can be caused by this? If there is one, is it
>version dependent? Is there a work around for it?
>
>Thanks,
>Charlie
>
>
Received on Wed Oct 13 1999 - 08:43:05 CDT