Print Thread
Wrong tablename in InternalEdit->FetchRecord
#150 11/10/99 12:39 AM
Joined: Nov 1999
Posts: 2
Dallas, Texas, USA
M
Member
OP Offline
Member
M
Joined: Nov 1999
Posts: 2
Dallas, Texas, USA
We're seeing the error 'ORA-08103 Object no longer exists' in the FetchRecord method, called by InternalEdit. The DMLQuery.Sql statement which fails is 'select * from LOOKUP_DATE where rowid= :doa_rowid' The probem is that LOOKUP_DATE is not the name of the table begin edited, but rather is name of the dataset assigned to the currently edited field's LookupDataset property. It appears we're asking TableB for a record that is in TableA. If I modify the Sql with Evaluate/Modify, there is no error. The editing is being done in a TdbGrid. ??

Re: Wrong tablename in InternalEdit->FetchRecord
#151 11/10/99 09:47 PM
Joined: Nov 1999
Posts: 2
Dallas, Texas, USA
M
Member
OP Offline
Member
M
Joined: Nov 1999
Posts: 2
Dallas, Texas, USA
It seems the problem is with the method used the derive the table name in the getUpdatingTable method from the OracleData unit: getUpdatingTable parses the FROM statement and returns the first table found as the updating table. The problem application is a generic table viewer which builds sql at run time. The sql engine has been modified comply with this assumption.

All's well that ends well.


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.074s Queries: 12 (0.005s) Memory: 2.4990 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-20 16:02:14 UTC
Valid HTML 5 and Valid CSS