Re: QMQRY QQRYSRC issues group by and order by

As I understand it, the value 1117 in the T record, merely identifies where the edit codes will be located within the T=Table. That is, the T-record identifies a "1110 table" [aka a "columns table"] that is being defined starting at that line [starting with T] and will include 013 R-records that follow the T-record, 005 of which only identify columns [e.g. as opposed to identifying /usage/ directives like SUM and BREAK1].

The QM FORM source that was previously posted had the K edit code for the numeric columns. Change one to TDY- or similar; search the manual for TDYx for an example. It seems that edit code may be available only for the Date data type, but that would seem to contradict its immediate preceding comment about how edit codes "are used to format character and numeric data for display."; i.e. date, time, timestamp are not noted in that comment, but then immediately following is documentation for each of date data, time data, timestamp data, character data, and numeric data. I see now, that since, a new post indicates the edit code "I" was used which presumably replaced a "K" shown below for the field labeled "Source".

A snippet of that query form from a prior post:

H QM4 05 F 01 E V W E R 01 03 08/08/28 08:24
V 1001 050 G/L by date range and Amt range
T 1110 013 005 1114 007 1115 006 1117 005 1118 003 1113 062
R 0 1 S_t_s
R SUM 1 2 TOTAL_Amount
R 1 3 T_y_p
R BREAK1 1 4 Receipt_or_Doc #
R 1 K 5 G/L_Date
R 1 6 G/L_Account
R 1 K 7 Source
R 1 8 Notes
R 2 K 9 Update
R 2 K 10
R 2 11
R 2 12 C_/_D
R 1 13

Regards, Chuck

Frances Denoncourt wrote:

About the numeric column editing. I can see in figure 38 that this line in my query has something
to do with it:
T 1110 013 005 1114 007 1115 006 1117 005 1118 003 1113 062 1117 is column edit; 5 I think might be from the 5th row in the
table below:
But, how does that apply to an individual column? <<SNIP>>