stored procedures - configure behaivour issue

stored procedures - configure behaivour issue

Postby » Wed 07 Dec 2011 21:50

I have a stored procedure with the following signature

CREATE OR REPLACE FUNCTION cbill.insert_attributes(p_id integer, p_attribute_type character varying, p_attribute_name character varying)
RETURNS integer AS

I have 2 classes (or tables)

I want to map the all_attributes class to the above stored procedure. In terms of mapping,

p_id is mapped to
p_attribute_name is mapped to all_attributes.attribute_name
p_attribute_type is mapped to attribute_type.description (all_attributes.attribute_type_id is a foreign key to

The problem is with the last mapping. I need to map that parameter to the description column, however only is displayed in the Property drop down list. How can i get the description property to appear?
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Postby Shalex » Fri 09 Dec 2011 16:03

As we understood, you are mapping your all_attributes class to the insert_attributes procedure. In this case attribute_type.description should not be available for mapping. The property is available for mapping because you have set an association between and all_attributes.attribute_type_id.
Devart Team
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for PostgreSQL