Re: QMQRY QQRYSRC issues group by and order by

[vhamberg@xxxxxxxxxxx]

Fran

Now you see why you don't want to write one of these things!!

Look at about page 141 in the Query Management Programming book - 
Figure 37. Encoded (Externalized) form field summary (Part 1 of 2) 
This tells you what each of the numbers means - e.g., in a T record, 1110 means the rows and columns in the field list that follows - the R records. In this case you have 13 rows (fields) and 5 columns.
After the 005 are the descriptions of each of the columns in the fields table 

1114 is usage - as in break level and the column width is 007
1115 is indent and is 006 characters wide
1117 is edit code (in RPG terms - heh)
1118 is order 3 wide
1113 is heading 62 wide

All the R records are then to be read according to the widths you see in the T record.

The V records are for break level settings and final text settings and general options and all like that.

See if you can get the product installed for the try / buy and see what you can do!!

HTH
Vern
-------------- Original message -------------- 
From: "Frances Denoncourt" <Frances.Denoncourt@xxxxxxxxxxxxxxxxx> 

> 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? 
>
>
> Edit Lead Negative Thousands Currency Percent Display of 
> Code Zeros Sign Separators Symbol Sign -1234567.885 
> ---- ----- -------- ---------- -------- ------- ------------ 
> E No Yes No No No -1.23456789E+06 
> D2 No Yes Yes Yes No -$1,234,567.89 
> I3 Yes Yes No No No -0001234567.885 
> J2 Yes No No No No 000001234567.89 
> K3 No Yes Yes No No -1,234,567.885 
> L2 No Yes No No No -1234567.89 
> P2 No Yes Yes No Yes -1,234,567.89% 
>
>
> Fran Denoncourt 
> Sr. Programmer/Analyst 
> Pinal County Treasurer's Office 
> Florence, AZ 85232 
> (520) 866-6404 
>
> Receipt of this message does not grant you permission to send me 
> Unsolicited Commercial Email 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l.