Re: Table for FlexiFields, Base table fields have been chang

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.

©2004 Ed Leafe