Using Column Alias in Pass Through Queries

N

Neil

Using Access 97 to an Oracle 7 back end.

Within a pass through query I use an oracle function thus:
GetAntigen(DRB1X,'DR') as DRxAnt,

If I execute the PTQ in Access, Access will not allow "DRxAnt" as a column
alias name but returns "Expr1018"
However, if I amend the alias name to:
GetAntigen(DRB1X,'DR') as DRxxAnt,
"DRxxAnt" is returned.

I have no other columns in the query that use that alias and I have many
other alias' that are returned OK

If I run the Pass Through Query in Oracle the alias name is returned
If I use a query that is the Access equivalent of the Pass Through SQL the
alias name is returned.

Any ideas why "DRxAnt" isn't acceptable?
 
V

Van T. Dinh

If you run the SQL String in Oracle directly, NOT as a PTQ from Access, is
the Alias "DRxAnt" OK in Oracle?

The problem may be in the Oracle ODBC driver?
 
N

Neil

Hi,

Thanks for the quick Reply.
I've discovered a typo and have corrected the issue.
Thanks for looking.

Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Make Table 7
Pass-through queries not displaying in navigation window 1
Pass-Through Query Error 1
Reference to Alias Columns 7
Error when opening Access 2003 0
Access pass-through query to Oracle 10g stored procedure - results 1
Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
3 table select query 2

Top