Re: Business objects, subset of collection



What about metrics for your SQL queries?

I have no metrics.  I started rewriting it using datasets instead of
business objects, but when I hit the problem I posted about earlier I
continued working on the business object based version of the
application.  It is now almost completed and is working very well so
far, so it is unlikely that I will rewrite it.  But I am still
interested in learning more about your approach since that could come
in handy for the next project.

You can look at the source code of http://www.sourceforge.net/projects/therp..
Unfortunately the application targets MySQL version 4, so view or
stored procedures is not used. But otherwise, it is a good example of
putting as much logic possible in SQL statement, and let the host
language focus on presentation logic.

//frebe
.