Article View: comp.databases.oracle.misc
Article #148Re: VB4, Oracle, ODBC
From: Keith Lawrence
Date: Mon, 23 Feb 1998 00:00
Date: Mon, 23 Feb 1998 00:00
22 lines
1711 bytes
1711 bytes
Jonathan Sayce wrote in message <01bd406d$7a6208e0$9af982c1@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
Technical Details
Message-ID:
<6csacm$e02$1@news.u-net.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bd406d$7a6208e0$9af982c1@sedgely>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fb53f,9167d3a68f653c69 X-Google-Attributes: gidfb53f,public X-Google-Thread: 10be7f,9167d3a68f653c69 X-Google-Attributes: gid10be7f,public X-Google-Thread: 104586,9167d3a68f653c69 X-Google-Attributes: gid104586,public X-Google-Thread: 112235,9167d3a68f653c69 X-Google-Attributes: gid112235,public X-Google-Thread: f99a8,9167d3a68f653c69 X-Google-Attributes: gidf99a8,public X-Google-Thread: 114664,9167d3a68f653c69 X-Google-Attributes: gid114664,public From: "Keith Lawrence" <false@no.spam> Subject: Re: VB4, Oracle, ODBC Date: 1998/02/23 Message-ID: <6csacm$e02$1@news.u-net.com> X-Deja-AN: 327883637 References: <01bd406d$7a6208e0$9af982c1@sedgely> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: (Posted Via) U-NET Ltd. Newsgroups: comp.databases.oracle.misc,fido7.rdbms.oracle,hannover.uni.comp.oracle,microsoft.public.vb.database,microsoft.public.vb.database.dao,microsoft.public.vb.database.odbc