"Nesting" record layout
Wondering if it is possible to "nest" a record definition. We have a record layout where we have a field array that gets mapped to another layout to extract the details. We would like to define the entire structure as one layout so that the detail data can be exposed to SQL.
Example:
record porder ponum, d9 pocust, d6 podate, d8 poline, 10a40 ... record polin poprod ,d8 podesc ,a20 poqty, d6 poprice, d4.2
Note: this is not an exact representation but is styled in a similar form to explain the problem.
In the programs we set polin=poline to get at the details but now that we are trying to expose the "polin" details without having to parse poline array in the extternal application. We woluld like to find away to have the porder record express the same breakdown we get from using the polin layout without creating 10 sets of variables.
Any ideas would be appreciated.
record porder ponum, d9 pocust, d6 podate, d8 group poline, [10]a poprod ,d8 podesc ,a20 poqty, d6 poprice, d4.2 endgroup endrecord
But be aware, there are no groups or arrays in SQL Server, so CodeGen and the SQL Replication templates will "flatten" the group out into 40 individual fields in the database.