• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1663
  • Last Modified:

to_char/to_date and VB

Using oracle server 7.3 and VB5/Prof, I try to retrieve a record that one of the columns, CALLDATE, is defined as date.
The SQL statment is:
Set rsinvoice = dbsRemote.OpenRecordset("select PIN_NO,to_char(CALLDATE,'MM/DD/YYYY') from [ALON.INVOICE] order by PIN_NO", dbOpenSnapshot, dbRunSync)

But when executing this statment I gor an error:
3085:undefined function 'to_char' in expression.

My question is why VB doesn't recorgnize this function, and how can I make it recognize the function?

Thanks,
Alon
0
oak022097
Asked:
oak022097
1 Solution
 
xiaodongCommented:
You need to use a flag called dbSQLPassThrough when you open the recordset.  to_char is Oracle-native, and is not part of ODBC specification.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now