SQL Generated QueryAhhh... That's what's wrong with @SQL ----- Original Message ----- From: Robert Shubert To: [email protected] Sent: Monday, March 17, 2008 13:24 Subject: RE: Witango-Talk: SQL Generated Query
<@SQL> is populated with the last run SQL statement - except for the fact that bound values are not shown, which means that you may need to do additional work in certain places to know what was in the bindings. This is my #1 request for v6. Robert ------------------------------------------------------------------------------ From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 2:17 PM To: [email protected] Subject: Witango-Talk: SQL Generated Query Easy question. Is there any way of obtaining, from Witango, the actual SQL code generated by searches? I know the code is available in the debug dump but It would be really handy to be able to pull a variable that contains that code and be able to write it to a database file for testing and checking. I'd really like to be able to write this code to a database table where I could record employee ID, date and time requested, etc. Thoughts on how to accomplish this? Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
