English

Bug: Importing JTX queries does not import the expected information

Description

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.

Cause

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.

Workaround

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.

  1. Open .jtq file in a text editor, such as Notepad.
  2. Examine each line of the file to ensure each line of the file contains the complete clause. Each line should contain the following:

    Line 1 - From clause
    Line 2 - Select clause
    Line 3 - Name As clause
    Line 4 - Order By clause
    Line 5 - Where clause