Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Relational Databases
Expertise: Beginner
Jun 15, 1998

Delphi SQL Parameters

Question:
Is it possible to use a parameter on the left side of an equality in a WHERE clause? For example:
SELECT * FROM TblName WHERE
:parm1 = :parm2
When I do this, the results I get suggest that every record passes the equality test, which shouldn't be the case. Thank you.

Answer:
This problem is one of the reasons I try to stay away from dynamic SQL, and instead construct the query strings myself using the TQuery.SQL.Add statement. I found that I have much more control over my query statements that way.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date