jwsacksteder@ramprecision.com wrote at 2003-6-20 15:26 -0400:
I am attempting to call a ZSQL method from within a python script with parameters and the result object I get back is not what I expected. Specifically, if I print len(results) inside my python script, it tells me that there are zero elements in my result. If I test the ZSQL method in the ZMI and supply the two parameters it needs by hand, I see the results I expect to see. Obviously my query is incorrect in some way. Is there a way to observe the literal sql statement that is being passed into my DBMS?
I have found it extremely useful to consult the 'SQL used' area on the test tab of ZSQL method when troubleshooting composed SQL statements. Is there anyway to get the same information programmatically inside a Python script?
ZSQL Method's "__call__" has an "src__" parameter. When you pass a true value, the method returs the generated SQL source (without executing it). Dieter