Re: SQL VB(ADO)

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 16 Jan 1999 03:15:11 GMT
Message-ID: <36a1cb49.3697194@netnews.worldnet.att.net>

On Fri, 15 Jan 1999 07:24:37 +0100, "Chr. Wounlund" <wounlund_at_hotmail.com> wrote:

>SELECT * FROM tblX WHERE strVar="SOMESTRING";
>
>I can get it to work with an access database, but in terms of ORACLE--no
>luck yet.

With Oracle, you need to use single-quotes, not double. For example:

SELECT * FROM tblX WHERE strVar='SOMESTRING';

I think this is true of relational databases in general. Access is probably being non-standard here. I'm not positive though.

Jonathan Received on Fri Jan 15 1999 - 21:15:11 CST