ADO, Parameters and SQL comments - is this a bug?

From: Martijn Tonies (m.tonies_at_upscene!nospam!.com)
Date: 01/20/04 

Date: Tue, 20 Jan 2004 21:52:22 +0100

Hi,

It seems the ado components also parses for parameters
inside SQL comments /* ... */

That is, this will give you one parameter:

SELECT somecolumn
FROM sometable
/* WHERE commented out but still :param */ 

--
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Relevant Pages

  • Incorrect syntax near keyword default
    ... I have a problem with two-tier application, that uses ADO components (Delphi ... to connect to MS SQL server 2000. ... I have switched from BDE to ADO componets. ... ' FROM RACUA RS, RACU RA'+ ...
    (borland.public.delphi.database.ado)
  • RE: List of Matches in WHERE Clause
    ... In that case i would use some code to insert a new SQL to a Query ... to an Access Query from my application. ... open-ended list parameter to an Access query? ... where SomeColumn In ...
    (microsoft.public.access.queries)
  • SQl 2005 native client and the XML datatype
    ... (constant 141 in ADO datatype mapping) ... the ADO components don't recognize this type and ignore ... Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL ... Database development questions? ...
    (borland.public.delphi.database.ado)
  • Re: Get Number of Rows in Table
    ... I guess my newness to SQL is showing here... ... I've been using the ADO components so I'm a ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ...
    (borland.public.delphi.database.ado)
  • Select where in
    ... Is there a way to select to find multiple conditions? ... I.e., in SQL, you can typically SELECT from myTable where someColumn in ... instead of passing in explicit strings, I'd like to pass in an array of ... Can a nested select be used as can be used in SQL? ...
    (microsoft.public.dotnet.framework.adonet)