RE: Strings
David Wright <[email protected]>
| Newsgroups | gmane.comp.lang.delphi.programming |
|---|---|
| Message-ID | <[email protected]_la_us.celsinc.com> |
Hi Eduardo, Quite a few ways to approach: 1) 'Select * from table where field=' + '''' + edit1.text + ''''; 2) 'Select * from table where field=' + QuotedString(edit1.text); 3) Use Format(query1.sql.text, [edit1.text]); Where query1.sql.text = Select * from table where field='%s' 4) Or user parameters with your query, which will improve speed. The sql for that would look like: Select * from table where field= :FieldParm And I am sure there are others.... David -----Original Message----- From: Eduardo Meyer [mailto:[email protected]] Sent: Wednesday, July 23, 2003 12:54 PM To: Delphi Programming Subject: [Delphi] Strings Hi people! I'm in a trouble with a string concatenation.. I mean, I'm trying to make an SQL Query in a string var... This the problem: strQuery = 'SELECT * FROM TABLE WHERE FIELD=' ??? Edit1.Text I would like to get the text of this TEdit, but how if ( ' ) limits the string?? How confusing was my explanation! LOL Sorry... Thanks! Eduardo [Non-text portions of this message have been removed] Yahoo! Groups Sponsor <http://rd.yahoo.com/M=249982.3604094.4873438.1261774/D=egroupweb/S=1705115362:HM/A=1524963/R=0/SIG=12omjm5nk/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3604094&prop=egroupweb&pos=HM> <http://us.adserver.yahoo.com/l?M=249982.3604094.4873438.1261774/D=egroupmail/S=:HM/A=1524963/rand=400916593> CodeCoffer - new Delphi code protection Tool! http://www.delphicollection.com/public/CodeCoffer.htm <http://www.delphicollection.com/public/CodeCoffer.htm> --------------------------------------------------------------- Unsubscribe:[email protected] List owner:[email protected] --------------------------------------------------------------- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Free shipping on all inkjet cartridge & refill kit orders to US & Canada. Low prices up to 80% off. We have your brand: HP, Epson, Lexmark & more. http://www.c1tracking.com/l.asp?cid=5510 http://us.click.yahoo.com/GHXcIA/n.WGAA/ySSFAA/i7folB/TM ---------------------------------------------------------------------~-> CodeCoffer - new Delphi code protection Tool! http://www.delphicollection.com/public/CodeCoffer.htm --------------------------------------------------------------- Unsubscribe:[email protected] List owner:[email protected] --------------------------------------------------------------- Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/