Re: Forms45 - matrix canvas???
Date: 1997/02/16
Message-ID: <5e643l$nrt_at_shadow.CSUFresno.EDU>#1/1
In article <855865336.19117_at_dejanews.com>, <karen_at_tag.com> wrote:
>I have a need to create a matrix view in forms45. I do not know the best
>way to accomplish this. I have tried using multiple blocks, but have not
>been able to get the proper response. ANY HELP WOULD BE GREATLY
>APPRECIATED!!!
>
>My table consists of LABCODE, VISIT_DATE, VISIT_RESULT, UNIT
>I want to display this in a matrix diagram for example:
>
> LABCODE VISIT_DATE(1) VISTIT_DATE(2) VISIT_DATE(3)....
> labcode (1) result for result for result for
> that day that day that day
> labcode (2) resukt for result for result for
> that day that day that day
You can do it by using a non-base-table (aka control) block to create the display. Use your own pl/sql procedure with a cursor and fetch loop to populate the block.
Here are the approximate steps:
go_block
clear_block
declare and open the cursor.
loop through the cursor, fetching a new row each pass.
for each new labcode (or when one display line is full in your block),
advance to a new record (in your block), and display the labcode.
also display the result.
for repeated fetches of the same labcode, display the result in the
next available item.
If you want to display the date above the respective columns, use another control block for that, and use the dates for the first labcode. (Of course, this assumes that each lab code has results for the same dates.)
While you can display unlimited labcodes, you can't display unlimited visit dates. You must define a column in your block for each date.
Hope this helps.
Steve Cosner
Try out my dynamic data utility form, QA. Quick display and update access to any table. http://members.aol.com/stevec5088 Received on Sun Feb 16 1997 - 00:00:00 CET