Article View: borland.public.vdbase.data.sql
Article #505Re: query using '?' in string parameter
From: Karen Elmquist
Date: Thu, 03 Sep 1998 00:00
Date: Thu, 03 Sep 1998 00:00
15 lines
1397 bytes
1397 bytes
I'm using Delphi2, Titan Access (instead of ODBC), and MS Access as my
database. The query works in Access alone. I think that it is a delphi
thing.....ie
when I write the query like this: 'update table set name = "hello?" where
....' - the query works. The problem however is that when you don't use
parameters, access blows up on colons and special characters.
so instead I have to use: 'Update table set name = :val where...' - then
I have to follow it up with a parameter statement:
query1.parambyname('val').AsString := 'hello?'
Using parameters like this allows the use of special characters, except the
question mark. It is somehow associated with delphi as a special symbol and
I need to know how to make it into just a character in a string.
Technical Details
Message-ID:
<6sm73k$ih56@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6sjidu$eq98@forums.borland.com> <6sjugt$fq718@forums.borland.com> <6sk55h$fq825@forums.borland.com> <35f9b1c0.20420930@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,87f82f8ff4ab83fc X-Google-Attributes: gidff5a1,public From: "Karen Elmquist" <kelmquis@wisdomwareNOSPAM.com> Subject: Re: query using '?' in string parameter Date: 1998/09/03 Message-ID: <6sm73k$ih56@forums.borland.com> X-Deja-AN: 387484284 References: <6sjidu$eq98@forums.borland.com> <6sjugt$fq718@forums.borland.com> <6sk55h$fq825@forums.borland.com> <35f9b1c0.20420930@forums.inprise.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql