Print Thread
Cant update records with joined table select TOracleDataset in 3-tier env.
#3672 07/10/02 07:02 AM
Joined: May 2001
Posts: 14
Taiwan
D
Member
OP Offline
Member
D
Joined: May 2001
Posts: 14
Taiwan
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?

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

Re: Cant update records with joined table select TOracleDataset in 3-tier env.
#3673 07/10/02 05:45 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
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


Marco Kalter
Allround Automations
Re: Cant update records with joined table select TOracleDataset in 3-tier env.
#3674 07/10/02 08:06 PM
Joined: May 2001
Posts: 14
Taiwan
D
Member
OP Offline
Member
D
Joined: May 2001
Posts: 14
Taiwan
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.



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


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.043s Queries: 14 (0.013s) Memory: 2.5013 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-21 07:31:25 UTC
Valid HTML 5 and Valid CSS