ra

• May 25th, 2007

 

A record group is an internal Form Builder data structure that has a column/row framework similar to a database table.  However, unlike database tables, record groups are separate objects that belong to the form module in which they are defined.  A record group can have an unlimited number of columns of type CHAR, NUMBER, or DATE provided that the total number of columns does not exceed 64K.  Record group column names cannot exceed 30 characters.
A record group built from a query can store records from database tables much like a database view, with the added advantage that the record group is local to Form Builder, rather than existing in the database.  Also, the SELECT statement used to create and populate a query record group can be constructed dynamically at runtime.

Programmatically, record groups can be used whenever the functionality offered by a two-dimensional array of multiple data types is desirable.

g_sidhu

 Profile 

• Feb 14th, 2008

 

All LOVs are based on another Forms object called a record group. Record groups are logical objects, so they have no physical properties and are never  displayed to the user. A record group is similar to a database table in that it stores an array of values in a column and row format. A record group can be based on a query or on a set of static values.