Re: A quick EGL example

[Brian <system.i.lists@xxxxxxxxx>]

I can name that tune in ...

In a production setting the database is more than likely already established
or will be developed outside of RBDe. In that case, you will just connect to
the database and import the tables during your project setup. RBDe will then
automagically create the Control Records, Data Access Libraries, Data Access
Records and EGL Data Items for those tabels. This auto generation can
eliminate the need to manually code the records as Joe has illustrated. So,
after a one time setup, you can create Joe's example in... five minutes. :)


On 11/24/07, Joe Pluta wrote:
> There are two pieces of code.  One is the part that defines the records,
> much like the DDS for externally described data structures:
>
> package data;
>
> Record OrderDetail type SQLRecord
>        OHCUST decimal(8);
>        OHSTATUS string;
>        OHORDER decimal(8);
>        OHAMOUNT decimal(11,2);
> end
>
> Record CategoryTotals type SQLRecord
>        Category String {column="Category"};
>        Total decimal(11,2) {column="Total"};
> end
>
> That defines two records, one for the list and one for the totals.  And
> you
> can of course reuse those records over and over again in other
> applications,
> just the same as you would an EDS.  The job of your program then is simply
> to create arrays of that data.  The EGL code to populate those totals: