[DUG] the things you learn !

[Rohit Gupta]

I knew that, but I wouldnt have thought of using it for this purpose.  
:-)

From:	"Jeremy Coulter" <vss at vss.co.nz>
To:	<delphi at delphi.org.nz>
Date sent:	Mon, 23 Jan 2006 17:48:41 +1300
Copies to:	Subject:	[DUG] the things you learn !
Send reply to:	NZ Borland Developers Group - Delphi List <delphi at ns3.123.co.nz>
	<mailto:delphi-request at ns3.123.co.nz?subject=unsubscribe>
	<mailto:delphi-request at ns3.123.co.nz?subject=subscribe>


This is sad but true, i ONLY just found out that if say you have an 
sql query that you are building up to be executed from a TQuery, i.e.

qry.sql.add('select * from mytable)
qry.open

if you put a break point on the qry.open bit then in the debug 
evaluate/modify fomr, you can go

qry.sql.savetofile('myfile.txt') and it will save it to file from the 
evaluate/modify form!!

For those of you who already knew that, then you woud think after 8 
years of Delphi I SHOULD HAVE KNOW THAT, but I didnt.....for 
those of you who didnt, well I hope it helps :-)

saves having to comment and uncomment or use compiler 
directives to save the sql to file !


Jeremy


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.21/236 - Release Date: 
20/01/2006Regards

Rohit

====================================================
==================
CFL - Computer Fanatics Ltd.  21 Barry's Point Road, AKL, New 
Zealand
PH    (649) 489-2280 
FX    (649) 489-2290
email rohit at cfl.co.nz  or  r.gupta at xtra.co.nz
====================================================
==================