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:
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.
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
In qa2217.cbs, add the output columns to the "output_type" structure.
In query_global_fd.cbs, add the output columns to the "output_type" structure.
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
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