UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> <DATE> field name in Pass-Through    
 
   
jjturner
post Mar 19 2008, 02:26 PM
Post #1

UtterAccess Veteran
Posts: 465
From: Boston
Is there any way to pull in a field named "DATE" from an Oracle db in a pass-throught query ?

I know - no one should use that as field name, but unfortunately I don't own the Oracle db

The error is: [Oracle][ODBC][Ora] . . .: missing expression (#936)

TIA,
John
Go to the top of the page
 
+
Troulcortex
post Mar 19 2008, 04:43 PM
Post #2

UtterAccess Guru
Posts: 946
From: Pennsylvania, USA
I am assuming you've tried aliasing it...

Select Date AS dtmDate
Go to the top of the page
 
+
jjturner
post Mar 19 2008, 04:44 PM
Post #3

UtterAccess Veteran
Posts: 465
From: Boston
correct
Go to the top of the page
 
+
Troulcortex
post Mar 19 2008, 04:52 PM
Post #4

UtterAccess Guru
Posts: 946
From: Pennsylvania, USA
The pass-through is executed by Oracle itself - that is why the error you are getting has the [Oracle][ODBC]- this tells me that 'Date' is probably reserved in Oracle itself...


Oracle reserved words

...

I know I'm not helping much, but I am a little curious on how your Oracle DBA managed to name a field 'Date'....

G
Go to the top of the page
 
+
Troulcortex
post Mar 19 2008, 04:53 PM
Post #5

UtterAccess Guru
Posts: 946
From: Pennsylvania, USA
Can you share the SQL of your pass-through?
Go to the top of the page
 
+
jjturner
post Mar 19 2008, 05:00 PM
Post #6

UtterAccess Veteran
Posts: 465
From: Boston
believe me when I tell you this was a total amateur job on the Oracle side (either that, or they just wanted to stick it to someone) - - I was shocked when I first started linking in the tables

Your list actually helps a bit, since all I was working with was the Access reserved words list . .

Normally, I'd just link tables, but the darned table has 255+ fields !!! How do you like that?

So naturally, DATE is beyond the initial 255 - - which is why I'm trying to use a pass-thru to get to the remaining fields (I was given a complete field list for reference - all 433 of them)
Go to the top of the page
 
+
jjturner
post Mar 19 2008, 05:02 PM
Post #7

UtterAccess Veteran
Posts: 465
From: Boston
It's just bare basic:

SELECT ACC2,ACCT,ACT2,ADDR,AKPS,AMBY,AMSL,AMTT,AMTV,ANKY,ARCB,ARCP,ASD1,ASD2,ASI2,ASID,
ASIT,DATE, (etc.)
FROM ZHIST
Go to the top of the page
 
+
Troulcortex
post Mar 19 2008, 05:09 PM
Post #8

UtterAccess Guru
Posts: 946
From: Pennsylvania, USA
Wow man - I'm at a loss here... If it is reserved in both Oracle and Access, I don't see how you could do it...

That really [censored] about >255 fields...

I've been in my fair share of pickles but this one takes the brine...

I have one more buddy I can ask - I'll get back to you tomorrow if I find out anything.


Good luck...

Gabe
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 09:34 PM