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/2006

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to