Instead of triggers

[gregor.irt]

I have DOA 3.3.3 on Delphi 5 and I want to use an updateable dataset for a view with an "instead of" triggers.

I have made a TOracleDataset and write SQL
(select * from myView) and UniqueFields in this SQL. I have connected TDBGrid (through TDataSource) to this dataset. Problem is that data remains readonly. Are there any additional conditions (properties) if I want to use instead of triggers?

 

[Marco Kalter]

You'll have to include the rowid in the select statement.

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

 

[tobiroemer]

And if you cant't get the rowid, because the "tables" in the Select of the view are views ?

 

[jpickup]

Typically you need to get the rowid of the most changed table and pass this up through the views.

Creating a view with a rowid as a column requires a column alias. Here is an example:

CREATE OR REPLACE VIEW some_view
AS
SELECT
some_table.rowid as "rowid",
...

 

[F.Hinlopen]

Also, if your view consists of a join, you need to have a key-preserved table in the join. The Application Developers Guide has a number of paragraphs on this subject.

------------------
Frans

 

[F.Hinlopen]

Also, if your view consists of a join, you need to have a key-preserved table in the join. The Application Developers Guide has a number of paragraphs on this subject.

------------------
Frans