🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: query using '?' in string parameter

#505
From: Karen Elmquist
Date: Thu, 03 Sep 1998 00:00
15 lines
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-mail
References: <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