Re: : in SQL statement

Article View: borland.public.cppbuilder.database.ado

Article #4883

Back to borland.public.cppbuilder.database.ado Previous Next

#4883

From: Mark Cashman
Date: Fri, 24 Aug 2001 11:17

19 lines
1746 bytes

Hi, Yongduk Lee!

: is never valid except when used in parameters, and even there, it
cannot be used in all portions of the SQL statement. Basically it can
only be used in place of the literal part of a WHERE clause.

If you need to parameterize a SQL statement elsewhere, you can do that.
However, you must do it by either constructing the statement with
strings or by writing a search and replace against the SQL statement. I
have done both and neither is that hard.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Technical Details

Message-ID: <3B8637C2.A9601C01@temporaldoorway.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3b84c211_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,45cd64bbd7c0b0e6
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-24 04:26:42 PST
Message-ID: <3B8637C2.A9601C01@temporaldoorway.com>
Date: Fri, 24 Aug 2001 07:17:22 -0400
From: Mark Cashman <mcashman@temporaldoorway.com>
Reply-To: mcashman@temporaldoorway.com
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: : in SQL statement
References: <3b84c211_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.14.197.193
X-Trace: dnews 998652052 24.14.197.193 (24 Aug 2001 04:20:52 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message