Re: Help with SQL

From: <michael_bialik_at_my-deja.com>
Date: Thu, 30 Mar 2000 21:53:04 GMT
Message-ID: <8c0ibn$r7e$1@nnrp1.deja.com>

Hi.

Use VB to duplicate any quote sign ( Craig''s data exchange ).

HTH. Michael.

In article <8c04ak$pio_at_portal.gmu.edu>, Sundeep Kumargoswami <skumargo_at_osf1.gmu.edu> wrote:
> Hi,
> I am trying to execute a SQL statement against an oracle database
> the field (customer_name) I am querying on contains records with
> embedded single quotes (') for example, Craig's data exchange. When
> the query hits one of these records it fails with improperly quoted
> string error. The front-end is VB and the connection is made using
ODBC
>
> Do While Not .EOF
>
> mySql = "SELECT * FROM all_customer_acct WHERE " & _
> "customer_name = '" & UCase(!customer_nm) & "'"
>
> frmValidator.Text1.Text = UCase(!customer_nm)
> frmValidator.Refresh
>
> outString = UCase(!customer_nm) & "|"
>
> How can I change the Sql Statment so it will not fail in the above
> situation.
>
> Thanks,
> Sundeep
>
> --
> -----------------------------------
> Sundeep Goswami
> skumargo_at_gmu.edu
> goswamis_at_hotmail.com
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 15:53:04 CST