Re: Is there a way to use arrays in Form 4.5?
Date: 25 Feb 1999 16:49:52 GMT
Message-ID: <7b3uvg$7d5$1_at_nntp.csufresno.edu>
In article <36D56C08.7FDA8527_at_singnet.com.sg>,
Damon Chong <damon_at_singnet.com.sg> wrote:
>Hi, sorry i'm very new to Oracle tools. I need to open a file, read the
>content which is in comma delimited values and store the values in
>variables. I using purely Forms 4.5 to do the above. I'm unable to find
>a way to make use of arrays to store the values in the help file.
>Currently, i'm using many declared variables to store the values which
>is very cumbersome. I would really appreciate if anyone have better
>suggestions.
Record Groups are available in Forms to store two-dimensional arrays. Go to Forms on-line help and look up Record Groups, and select the topic "About Record Groups". I have used Non-Query record groups to store data, but I set them up at design-time by creating a "Select... from Dual" query to establish the columns at design-time, rather than write the code to create the group and all the columns at run-time.
Using record groups takes a bit of code writing, but when the form runs, processing is really quick.
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Thu Feb 25 1999 - 17:49:52 CET