Re: VB4, Oracle, ODBC

From: Keith Lawrence <false_at_no.spam>
Date: 1998/02/23
Message-ID: <6csacm$e02$1@news.u-net.com>#1/1

Jonathan Sayce wrote in message <01bd406d$7a6208e0$9af982c1_at_sedgely>...
>The scene:
>
> An Oracle 7.1 db on Netware, a Win 3.11 pc, and an ODBC link from a 16-bit
>VB 4 app.
>
>The problem:
>
> While I can insert a date into the Oracle system in the format
>"dd-mmm-yy", I cannot run a query on a certain date. The following query
>reports that there is a 'type mismatch':
>
> SELECT field FROM table WHERE date_field = '24-Apr-96'

If using JETDAO try putting the date into JET format -

SELECT field FROM table WHERE date_field = #24-Apr-96# If using PassThru then you need Oracle format -

SELECT field FROM table WHERE date_field = TO_DATE('24-Apr-96','DD-MON-YY')

Keith L Received on Mon Feb 23 1998 - 00:00:00 CST