Is This Content Helpful?
We're glad to know this article was helpful.
Importing JTX queries does not import the entire query, and/or clauses are not imported into the correct text box on the form.
For example, the information that is expected to appear in the Select clause is displayed in the Name As text box.
This is caused by a limitation with the .jtq file format used to export and import JTX queries. This format consists of each clause on its own line; therefore, if any of the clauses in the query to be exported contain a new line character or white space, the format is corrupted.
There are two different ways to correct this issue. The first is to ensure that no clause contains a newline character before exporting it. If the query has been exported, and only the .jtq file is available, the following steps can be used to repair it.