Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Apostrophie Problem

Apostrophie Problem

From: Perry Hemmings <perry.hemmings_at_btinternet.com>
Date: Wed, 17 Jan 2001 20:10:24 -0000
Message-ID: <944vhs$fl8$1@uranium.btinternet.com>

Hello All

I am running Oracle 8 with a Visual Basic frontend, my program falls over when an Apostrophe is in the name i.e. O'Brien and my search needs adjusting can anyone advise me on how to achieve this??

Res = "SELECT Lastname FROM Customer WHERE Lastname = txtTEXTBOX"

Thanks in advance

Perry

Please e-mail your response to perry.hemmings_at_volteurope.com as well as responding to the NG Received on Wed Jan 17 2001 - 14:10:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US