VB4, Oracle, ODBC

Article View: comp.databases.oracle.misc

Article #147

Back to comp.databases.oracle.misc Previous Next

#147

From: Jonathan Sayce
Date: Mon, 23 Feb 1998 00:00

22 lines
1583 bytes

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'

The date is sent as a string, enclosed in single quotes.

If anyone can suggest how to get round this - either the correct way to
query a date via ODBC to Oracle or where in the Oracle system I can find
the full date syntax - I and many others will be eternally grateful.

Cheers,
Jon.

Technical Details

Message-ID: <01bd406d$7a6208e0$9af982c1@sedgely>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,9167d3a68f653c69,start
X-Google-Attributes: gidfb53f,public
X-Google-Thread: 104586,9167d3a68f653c69,start
X-Google-Attributes: gid104586,public
X-Google-Thread: 10be7f,9167d3a68f653c69,start
X-Google-Attributes: gid10be7f,public
X-Google-Thread: f99a8,9167d3a68f653c69,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 114664,9167d3a68f653c69,start
X-Google-Attributes: gid114664,public
X-Google-Thread: 112235,9167d3a68f653c69,start
X-Google-Attributes: gid112235,public
From: "Jonathan Sayce" <jon.sayce@iname.com>
Subject: VB4, Oracle, ODBC
Date: 1998/02/23
Message-ID: <01bd406d$7a6208e0$9af982c1@sedgely>
X-Deja-AN: 327850097
Organization: UUNET
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