[DUG] the things you learn !

[i_j_fear at xtra.co.nz]

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" <vss at vss.co.nz>
> Date: 2006/01/23 Mon PM 05:48:41 GMT+13:00
> To: <delphi at delphi.org.nz>
> 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
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060123/1386a204/reply.html