ORA-00904 Invalid Column Name

[indigo]

I have not been able to resolve a problem with an ORA-00904 Invalid column name. Yesterday, I removed all the persistent field definitions and put them back in. Then I changed display names. I ran the program and the insert/post worked. I thought the problem was resolved. This morning the problem is back. What could be causing this? Here is the SQL:

select tran.rowid,tran.*,
slbtch.batchdate,
slbtch.batchseq,
taxccode.title TaxCodeTitle,
trancode.title TransactionCodeTitle,
tfmtcode.title RecordFormatTitle,
txclcode.updateovertolerance OverTolerance,
return.delinquentdate DelinquentDate,
return.returnstatus ReturnStatus,
return.limit LimitAmount,
taxccode.tableno TableNo,
taxccode.form LicenseForm,
txclcode.updateundertolerance UnderTolerance,
(select slmast.BusinessName Name
from slmast
where return.MasterNo = slmast.MasterNo and return.AccountType = 0
union select audits.Name Name
from audits
where return.MasterNo = audits.MasterNo and return.AccountType = 1
union select case.Name Name
from case
where return.MasterNo = case.MasterNo and return.AccountType = 2
union select instag.LegalName Name
from instag
where return.MasterNo = instag.MasterNo and return.AccountType = 3) Name
from tran,
slbtch,
taxccode,
trancode,
tfmtcode,
txclcode,
return
where tran.returnno = :ReturnNo
and tran.batchno = slbtch.batchno(+)
and tran.taxno = taxccode.taxno(+)
and tran.transactioncode = trancode.transactioncode(+)
and tran.recordformat = tfmtcode.formatcode(+)
and taxccode.taxclass = txclcode.taxclass(+)
and tran.returnno = return.returnno(+)
order by tran.batchno

 

[al0]

In this case SQL withowt table definitions is absolutely useless.

 

[Marco Kalter]

To automatically determine which fields belong to the UpdatingTable, set TOracleDataSet.OracleDictionary.FieldKinds to True. If you have persistent fields, you can change the FieldKind from fkData to fkInternalCalc.

Fields with an alias in the SQL statement cannot be updated. If this is required, these fields must keep their original name.