Author: Ed Leafe
Posted: 2004-03-31 at 15:00:10
Quote: >>Quote: >>(short of a redesign of your data)
Any suggestion for such a requirement.
When you have a variable column structure, it is best to redesign
things into an atribute-centric design. IOW, instead of adding or
removing columns, you add rows to a related attribute table, with the
"column" name as the key field. It's more work, especially in creating
SQL joins, but it is amazingly flexible.
Quote: >>Better still in the BO's DE I switched iDynamicViewCursor to
cDistinctDynamicViewCursor but that didn't do the job.
I didn't mean to use that class; it would only come into play when two
bizobjs try to use the same view. All I meant was you could grab some
of the DBC and view creation code from that class's code.