× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Odd Subfile question
  • From: Dave Murvin <davem@xxxxxxxx>
  • Date: Sat, 06 May 2000 18:03:10 -0700
  • Organization: DRM Enterprises, Inc

Terry,

If I understand your problem correctly, you could change the program to
load to two subfiles at the same time.  Subfile 1 contains your data and
no comments.  Subfile 2 contains your data and the comments.  When the
users want to see the comments, just switch subfiles.  Numeric fields in
these subfiles are formatted alpha fields for display.  On the comment
lines, all the alpha fields that do not apply are blanked out.  You
could do the same thing to the fields on the second line of the subfile.


Subfile 1 with no
comments                                                                        
      
Field      Field     Dec  
Position                                           
Name        Len  Typ Pos  From    To 
Text                                    
IMSLS          15 P    2    94   101  Month to Date Sales
Amount              
ICLAS           2 A        102   103  Item
Class                              
IUMS            2 A        104   105  Stocking Unit of
Measure                
IUMP            2 A        106   107  Purch Unit of
Measure                   
IUMCN          11 P    5   108   113  U/M Purchase to Stock
Conv              
IITYP           1 A        114   114  Item Type (0,1,2,3,4,5,...User
Def.) 0=P
ILEAD           3 P    0   115   116  Days Lead
Time                          
IVEND           5 P    0   117   119  Primary
Vendor                          

Subfile 2 loaded with file field info and comments
Field      Field     Dec  
Position                                          
Name        Len  Typ Pos  From    To 
Text                                   
IITYP           1 A        114   114  Item Type (0,1,2,3,4,5,...User
Def.) 0=
                                      Item type comment
1                    
                                      item type comment
2                    
                                      item type comment
3                    
ILEAD           3 P    0   115   116  Days Lead
Time                         
IVEND           5 P    0   117   119  Primary
Vendor                         


Subfile 2 with SFLDROP
 Field      Field     Dec  
Position                                           
 Name        Len  Typ Pos  From    To 
Text                                    
 IITYP           1 A        114   114  Item Type (0,1,2,3,4,5,...User
Def.) 0=P
                                      
hantom,5=T                              
                                       Item type comment
1                     
                                                                               
                                       item type comment
2                     
                                                                               
                                       item type comment
3                     
                                                                               
 ILEAD           3 P    0   115   116  Days Lead
Time                          
                                                                               
Hope this helps.  I also hope the spacing doesn't get messed up.

Terry Owen wrote:
> 
> I was fixing a subfile at work that has some odd characteristics.  The
> reason I was working on it was that it had a standard 2 line subfile but
> the sfldrop keyword wasn't there. I added it, it worked.
> 
> So far so good, but then it was returned to me from QA for a clearing
> thing.  When I started looking at it in more detail I saw that if in a
> preceding screen the user chose to see comments from a different file, the
> lines were just added to the field name for the first line in the subfile.
> Since you have no way of knowing how many comments might be added, there is
> no way for the sfldrop to work predictably.  (If you do press F1 for more
> info, you get the second line alternating with the comments from the
> additional file.)


-- 
Dave Murvin
DRM Enterprises, Inc.
davem@drme.com
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.