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