in a hetero query if you move from the query builder to the editor can you modify the editor query and run it from there? We seem to be having an issue when moving the query from query builder to the editor and running it from the editor, even if we do not modify the query, it still will not run, but will run from the query builder. Any suggestions?
Yes. there is no problem with sending the SQL from the QB to the editor and executing. The only issue you may run into when editing is in using the correct syntax. Code completion should help you on this.
What exactly is the error you are getting. Can you post the error as well as the SQL?