Hi Guys,
my xfm project is as follow:
I store the spatial data in DGN but a descriptive attributes in oracle. In oracle I have inter alia three tables:
CREATE TABLE ASSETS( mslink NUMBER NOT NULL, asset_name VARCHAR2(255) NOT NULL, status_id NUMBER NOT NULL, mapid NUMBER);
CREATE TABLE STATUS( id NUMBER NOT NULL, status_name VARCHAR2(60) NOT NULL,);
CREATE TABLE MSCATALOG( tablename CHAR(32), entitynum NUMBER, screenform CHAR(64), reporttable CHAR(64), sqlreview CHAR(240), fencefilter CHAR(240), dastable CHAR(32), formtable CHAR(64));
I have a foreign key:
ALTER TABLE assets ADD CONSTRAINT assets_status_fk FOREIGN KEY (status_id) REFERENCES status (id) ON DELETE CASCADE;
In GSA I Connected with oracle; created Feature with properties database (ASSETS) where status_id is comboBox. And at this point the problem starts :)
I want that a status_id was a domain list. Where should I put a SQLquery so it works. The Attachments (unfortunatelly in polish) can see how I did it but it does not work.
TIA
ABA
It sounds like you want to see both the status id and the status in the drop down list , so yoiu can change the status of the field ? You want to see the 'status' value, but store the status_id in the table right ? So the SQL Query would be :
select id,status_name from status;
Then in the 'value col name' field of the property, you put the text string 'id'. This is the value that will be placed in the database table. In the 'Edit col name' you would put the text string 'status_name'. This is the value the user will see. When the user selects one of the status_name options, the associated id will be palced in the table for that record.
HTH
Jerry