SchemaExport and formula properties

dagda1 · **Joined:** Fri May 05, 2006 11:54 am **Posts:** 51

Hi,

I am using SchemaExport to generate my db.

I have a problem where on one class I have 4 fields with formla attributes set.

For example:

Code:

<property column="planleadercount" type="Int32" name="PlanLeaderCount" not-null="false" formula="(SELECT count(cc.uid) FROM calltreecontacts cc INNER JOIN CallTrees ct ON cc.calltreeuid = ct.Uid WHERE cc.contactUid = Uid and cc.calltreecontactroleid = 1 and ct.deleted = 'false')"/>

The problem is that the SchemaExport tool will not generate these columns if I have the formula attributes present.

If I remove the attributes SchemaExport generates the columns.

Is this a known bug?

Cheers

Paul

darioquintana · **Posted:** Mon Feb 18, 2008 1:49 am

Hi,

Formula tag, is a calcuble column, but doesn't exists at database.
No column will be generated.

The query run on the fly when you get the values of the object.

Best regards.