Solved

to_char/to_date and VB

Posted on 1998-05-07
1
1,560 Views
Last Modified: 2012-08-14
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
Comment
Question by:oak022097
1 Comment
 
LVL 2

Accepted Solution

by:
xiaodong earned 70 total points
ID: 1080929
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now