Cant update records with joined table select TOracleDataset in 3-tier env.

[donychao]

I cant update records of joined tables using
TOracleDataset under 3-tier infrastructure.
They are read-only. I search the whole forum
about 3-tier info, but there is just a few messages regarding it. Can you tell me do I have any good idea to use the TOracleDataset instead of TQuery or some ohters in 3-tier env?

------------------

 

[Marco Kalter]

If the dataset is readonly, then my first guess would be that you have not included the rowid field. Could this be the case?

It doesn't really matter if this is a 3-tier application or not.

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

 

[donychao]

I use TOracleDataSet for over 2 years, how
could I forget to include the table.rowid
in the SQL.Text? This couldn't be the case.
But since you said that's not about 2 or 3-tier. I will try it again to make sure
what really happen, thanks a lot.

------------------