[DUG] the things you learn !

Jeremy Coulter vss at vss.co.nz
Mon Jan 23 21:47:00 NZDT 2006


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: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of i_j_fear at xtra.co.nz
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" <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
> 
> 

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






More information about the Delphi mailing list