Work with outer-join based views

[redskin]

When trying to insert/update OraDataSet retrieving data from outer-join based view i get error message that rowid for such view can't be retrieved. For all iserts and updates i wrote triggers instead of, and from SQL environment they work perfect.
How can i with minimal coding work with such type views? I tried to use UniqueFiels property but the problem remaind.

 

[Marco Kalter]

You must include the rowid in the query, and specify the column(s) that identify a record in the UniqueFields property.

------------------
Marco Kalter
Allround Automations

 

[redskin]

I tried to use rowid in select statement of view but i got error msg that for rowid i have to specify column name in quotes "".
But specifying "ROWID" name (in capitals, of course) gives the same error and specifying any other name (for example, "Rowid") doesn't give any positive results.
All necessary unique fields are in view select statement.

 

[jpickup]

I've been using the following for views (including those with outer joins) without any problems:

CREATE OR REPLACE VIEW xxx AS
SELECT
x.rowid as "rowid",
x.y,
...

 

[suntechangelo]

I'm having the same problem. I want to insert/delete and update in a view, but I don't get work. Just to remenber in my VIEW have a union table.
Ever happened the same error ORA-01446. I put ROWID in the view and set the UniqueFields but I don't work. If you have a solutions, can you help me.

Thanks

Angelo Andrade

 

[Marco Kalter]

If a record cannot uniquely be identified, then you cannot insert, update or delete records with standard dataset processing. It would require an OnApplyRecord event handler.

Is the union from 2 different tables? Or from 2 subsets of the same table?