query using '?' in string parameter

Article View: borland.public.vdbase.data.sql

Article #496

Back to borland.public.vdbase.data.sql Previous Next

#496

From: Karen Elmquist
Date: Wed, 02 Sep 1998 00:00

17 lines
908 bytes

when I execute an update or insert SQL statement and there is a '?' in a
string value, I get exceptions.

for example:

Query1.SQL.Add('Update table set description = :value1 where number =
:value2');
Query1.Params[0].AsString := 'hello?';
Query1.Params[1].AsInteger := 1;
Query1.ExecSql;

      ---  boom!!

any suggestions on how to get around this?
please respond to kelmquis@WisdomWare.com

thanx in advance ..... karen

Technical Details

Message-ID: <6sjidu$eq98@forums.borland.com>

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: ff5a1,87f82f8ff4ab83fc,start
X-Google-Attributes: gidff5a1,public
From: "Karen Elmquist" <kelmquis@wisdomwareNOSPAM.com>
Subject: query using '?' in string parameter
Date: 1998/09/02
Message-ID: <6sjidu$eq98@forums.borland.com>
X-Deja-AN: 387125604
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql