Vatchy Feb 11, 2010   3:49 PM GMT

You can do this with a page-at-a-time subfile. That allows you to condition the fields to display or not display. Along with this use embedded SQL to define your sort using the Prepare/Execute statements.

1,415 pointsBadges:

Sloopy Feb 11, 2010   4:28 PM GMT

Actually, you can do it in one subfile, and it can be self-extending. The subfile has a single displayable line, and the subfile control has a field or fields to show the (variable) column headings. Fill the single display field from the data, set the correct heading values and display the subfile. If the user changes the view, reload the subfile with the different data, formatted into the single display field, change the column headings and display the subfile. I use this quite often, and it's especially useful when there are different views of the same selected data, because then you can store the alternate views in hidden fields in the subfile record. When the user toggles the view (for the same selection criteria), we copy the hidden data (already formatted) to the displayable field, change the column headings and redisplay - without re-reading the database. (Of course, check the volatility of the data! You may have to reload to keep the screen up-to-date.) Sloopy

2,195 pointsBadges:

filuphaze Feb 11, 2010   9:14 PM GMT

Thanks everyone for your input. I will give some of those ideas a try and see which works best.

475 pointsBadges:

philpl1jb Feb 12, 2010   1:48 AM GMT

Sloopy The long character field is a great idea but just for output fields. And the Hidden fields work well. Whwn the alternate format key is pressed the code should loop through all the records in the subfile Chaining into each on the RRN building the new character field from the hidden fields and then updating the subfile record. Vatchy My experience was that the No Display fields still took real estate, hiding any other column in the same space. Please let me know if there is a solution. Phil

54,090 pointsBadges:

Splat Feb 12, 2010   3:29 PM GMT

I've created multiple view subfile programs. I use page-at-a-time processing & different logical views for presentation (I use RRN-chaining against the physical, storing the RRN in a hidden field in the subfile), & use a combination non-display subfile / data queue to store & sort options.

12,270 pointsBadges:

Vatchy Feb 15, 2010   2:52 PM GMT

Philpl1jb Don't use NonDisplay fields, just condition the fields to show/not show with indicators. This only works with page-at-a-time subfiles, not with extendable/load-all subfiles.

1,415 pointsBadges:

philpl1jb Feb 16, 2010   0:03 AM GMT

Thanks Vatchy I'll add that to my tool set. Phil

54,090 pointsBadges:

PY Feb 16, 2010   4:22 PM GMT

You can display multiple formats by using indicators, you need to have logicals based on the key that you wanted to display and need to play with the indicators in the program. You need to use one long character field, hidden fields in the subfile format. Lets say, when Indicator X{25} is on, display subfile in one format and when it is off display subfile in other format. Like this, you can display subfile with multiple ways......

60 pointsBadges:

Kathan May 19, 2010   11:23 AM GMT

Its very simple buddy, Use window subfile , that is two different window and write subfile and exfmt other one. IN display file, create a field of any lengh with same name in both window of NON DISPLAY type, Now call your program, you will see two window and when you press TAB, it will jump to other window and it will show the records.

70 pointsBadges: