Replicant-User Defined Schemas and replicants

Trey

I am using dd 5.5.2 and trying to get one replicant value out of ONE DCR to show up on multiple rows in a db table. The DCR only contains the one item, the replicant, so IW as having an issue finding a unique id. I thought the sort order would get at it but that does not seem to work either. What am I missing.

The DCR and dbschema files are as follows:
-------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE record SYSTEM "dcr4.5.dtd">
<record name="categories.dcr" type="content">
<item name="item">
<value>
<item name="CategName">
<value>Inside Sales</value>
</item>
</value>
<value>
<item name="CategName">
<value>blahfoo</value>
</item>
</value>
<value>
<item name="CategName">
<value>SuesCateg</value>
</item>
</value>
<value>
<item name="CategName">
<value>Outside Sales</value>
</item>
</value>
<value>
<item name="CategName">
<value>Showroom Sales</value>
</item>
</value>
<value>
<item name="CategName">
<value>Management</value>
</item>
</value>
<value>
<item name="CategName">
<value>My New Category That Has Several Spaces</value>
</item>
</value>
<value>
<item name="CategName">
<value>another new one</value>
</item>
</value>
</item>
</record>
-------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<dbschema>
<group name="JOBCATEGORY" table="JOBCATEGORY" root-group="yes">
<attrmap>
<column name="rep_order" data-type="INTEGER" value-from-field="not-used" allows-null="no" replicant-order-column="yes"/>
<column name="Path" data-type="VARCHAR(255)" value-from-field="Path" allows-null="no" is-url="no"/>
<column name="state" data-type="VARCHAR(25)" value-from-field="state" allows-null="yes" is-url="no"/>
<column name="CategName" data-type="VARCHAR(255)" value-from-field="item/[0-99]/CategName" is-replicant="yes" allows-null="yes" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="rep_order"/>
</primary-key>
</keys>
</group>
</dbschema>

Trey Wentz
Ferguson Enterprises, Inc.
e-mail: trey.wentz@ferguson.com

Edited by Trey on 05/13/03 09:23 AM (server time).

Migrateduser

can you report this to support and its recommended you upgrade to DD5.6.