Ed Leafe writes:
I'm learning to use sqlgroup to eliminate a lot of nearly identical queries, and so far have been happy with the results. But every so often I get a result that doesn't jibe with what should be returned, and I'm having a hard time figuring out where my mistake is.
Is there any way to view the actual SQL that gets sent to the server after all the sqlgroup and sqltest tags are evaluated? That would be a really big help in debugging complex expressions. Someone else already told you about the "Test" tab of ZSQL methods.
In cases, this is not feasible, you can call a ZSQL method with an "src__=1" keyword parameter. In this case, it will just generate the SQL command and return it. It will not send the generated SQL to the database. Dieter