stored procedures - configure behaivour issue

stored procedures - configure behaivour issue

Postby akash.hegde@gmail.com » Wed 07 Dec 2011 21:50

Hi
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)
all_attributes
attribute_type


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

p_id is mapped to all_attributes.id
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 attribute_type.id)


The problem is with the last mapping. I need to map that parameter to the description column, however only attribute_type.id is displayed in the Property drop down list. How can i get the description property to appear?
akash.hegde@gmail.com
 
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 attribute_type.id property is available for mapping because you have set an association between attribute_type.id and all_attributes.attribute_type_id.
Shalex
Devart Team
 
Posts: 7793
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL