FORMS 4.5 Basic Questions Please HELP

Hello and thank you for reading this. I have a few questions, for which I couldn´t find an answer during my first week working with ORACLE FORMS 4.5. Thanks for all information which could help me.

1.) How can I succeed to find the best customize for windows? I have seen so many places, where I can insert values for Height or Width. Where should I enter values and where should I leave my fingers avay to get good results?

2.) How can I parametrize the EXECUTE_QUERY command? I have a window, where I will display only the details of several selections, the user has done up to then. Master-Detail Forms are no solution. But I should build a select statement using a where clause with the selections, the user has done. How can I realize, that only these records are displayed, which fulfill the where-predicate?

3.) How can I build a fast prototype to let it run on another PC? How can I build an exe out of these different *.mmx, *.fmx -Files?

4.) I should build a table which looks like the example below. My problem is, that I do not know if using sursors in PL/SQL is the solution, the specialists would select. How can I realize the looking below, if the same letters are results of the same select statement?

     topic1  topic2  topic3  topic4
       a1        b1         c1         d1
       a2        b2         c2         d2


       :            :             :             :

      an         bn         cn         dn

and when the user switches to the next page, the following should appear

     topic5  topic6  topic7  topic8
       a5        b6         c7         d8
       a5        b6         c7         d8


       :            :             :             :

      an         bn         cn         dn

where the different headers (topic) come from table A and the values come from table B.

Thanks for every help.

Manfred Tischendorf Received on Fri Aug 29 1997 - 00:00:00 CEST