Yeah, I already do that, but the problem is sometimes you need to check a bit of code/sql that’s not part of your normal "write this to file" trap.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 23 January 2006 21:24 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] the things you learn ! well why not add a run time paramater to save QTofile from your exe then you can turn it on any time to debug dynamic sql. a graet help with reports that have extensive selection options ian > > From: "Jeremy Coulter" <[EMAIL PROTECTED]> > Date: 2006/01/23 Mon PM 05:48:41 GMT+13:00 > To: <[email protected]> > Subject: [DUG] the things you learn ! > > 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 > > -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.21/236 - Release Date: 20/01/2006 -- 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
