<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=078454404-23012006><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial size=2>qry.sql.add('select
* from mytable)</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2>qry.open</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial size=2>if you put a break
point on the qry.open bit then in the debug evaluate/modify fomr, you can
go</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2>qry.sql.savetofile('myfile.txt') and it will save it to file
from the evaluate/modify form!!</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial size=2>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
:-)</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial size=2>saves having to
comment and uncomment or use compiler directives to save the sql to file
!</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2>Jeremy</FONT></SPAN></DIV>
<DIV><SPAN class=078454404-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>
<BR>
<P><FONT SIZE=2>--<BR>
No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.1.371 / Virus Database: 267.14.21/236 - Release Date: 20/01/2006<BR>
</FONT> </P>