Richard, I have sent you the revised module, but it has been return by your Email host. Can you provide an alternate email address? Thanks Paul.

Discovered this issue... With extremely large Primary SQL statements, SGSV will not save the entire statement to disk. However it will save it in the cache and depending on the level of usage, the issue will not be seen until the cache is flushed and the data is read from disk. SGSV uses the M...

Alex, What version of SGSV are you running. Also, could you please end me the exported setting XML file so I can test it locally. Send the settings XML to admin [at] tressleworks [dot] ca Paul.

Sorry I missed you post early .... I am wondering if this may have something to do with the size of primary query. Just a thought. Could you export the settings and forward me the XML file? I will attempt to see where the issue may lie. Send to admin [at] tressleworks [dot] ca Also, pleas...

Mark, Absolutlely ... the substitution variable [QUERY::default] allows you to obtain any of the Query parameters used in the request. See Page 62 of the current User Guide. Based on your example, if you place the following into the Primary Select it should work as you required select * from ...