Skip to content
English
  • There are no suggestions because the search field is empty.

How to Add Extra Output Columns to QA

How to Add Extra Output Columns to Query Anything (QA)



The following are the steps you need to follow to add extra output columns to QA:

  1. In the DB schema, add one extra column in table_query_objs for each output and path. For example, for a 13th column, you'd add "out13" and "path13" to the schema (with the same properties as the other columns in the table.

  2. Change the constant "MAX_NUM_COLS" to the proper number. This is changed in the following code modules: qa2210.cbs, qa2213.cbs, qa2215.cbs, qa2217.cbs

  3. In qa2217.cbs, add the output columns to the "output_type" structure.

  4. In query_global_fd.cbs, add the output columns to the "output_type" structure.

  5. In qa2217.cbs, in the "show_partial" subroutine, you must add one extra line for each new output column. For example, if you add a 13th column, you'd add:

    If num_out_cols > 12 Then new_rec.SetField "out13", dummy_out.out13

  6. Add the new column(s) to the CLB_RESULT grid in form 2217.
    For example, if you added out13 to your schema, then you would add a new column to the grid:
    Name: "_" (This is an underscore)
    CObj: LOR_RESULT
    Field Name: out13
    Width: Set it to be the same as the other columns

Also, because you will be increasing the amount of data you're using, I would suggest adding the following lines to your client clarify.env file in order to increase the amount of memory space Clarify can use:
cbPublicSize=1000000
cbStackSize=8192