Re: Mapping SQL Result Sets to Browsers

[Nathan Andelin <nandelin@xxxxxxxxx>]

> From: Sarah Poger Gladstone
> Did you review the sample DAO code I posted to this list?

Yes.  And it was helpful.  Although the sample appeared to demonstrate a substitute for record level access (chain, update, write) rather than working with multi-row, multi-column result sets.  And that could lead to a discussion of the "database layer", if you can call it that.

So far the discussion has pinged and ponged between "presentation layer" and "business object" layer, but we haven't really delved into a "database layer", particularly as it relates to database updates.  And the interfaces between these three layers are still a little fuzzy to me in the context of OO languages and runtime environments.

> I have no doubt you could write your own DB API for RPG programmers,
> but I don't know how you would improve on the JDBC template API.

That's funny.  It would be hard to improve on the built in RLA in RPG, and I normally wouldn't make the attempt, using a procedure interface, except if I were attempting to write a runtime utility to access any file on the system through a single interface; like the WRKDBF utility.

Nathan.