Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Oracle - MSAccess data type problem
0 views
Skip to first unread message
Dave
Aug 11, 2002, 10:10:04 AM8/11/02
to
When I attempt to use Oracle nvl or decode functions on date fields in
pass-through queries from Access 2K the Jet error "Invalid precision for
pass-through queries from Access 2K the Jet error "Invalid precision for
decimal data type" is returned. This happens with both ODBC and ADODB
connections to the table in question. A check of the table fields
verifies the data type to be date/time. I have tried various
combinations and permutations of TO_DATE and TO_CHAR on these fields
with no success.
Does anybody have any suggestions?
Thanks
Dave
0 new messages