I am receiving ORA-01410: Invalid ROWID when I try to edit a record. This has worked in the past but I had to change the SQL to obtain an associated name from one of four other tables. I believe the problem started with I put in the select for determining the name. Do you see anything in the sql that would prevent the rowid from being returned and if so how do I get around the problem? The SQL is shown below. Thanks, Sidney
Select tran.rowid,tran.*,
slbtch.batchdate,
slbtch.batchseq,
taxccode.title TaxCodeTitle,
trancode.title TransactionCodeTitle,
tfmtcode.title RecordFormatTitle,
txclcode.updateovertolerance OverTolerance,
return.delinquentdate DelinquentDate,e
return.returnstatus ReturnStatus,
return.limit LimitAmount,
taxccode.tableno TableNo,
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
Select tran.rowid,tran.*,
slbtch.batchdate,
slbtch.batchseq,
taxccode.title TaxCodeTitle,
trancode.title TransactionCodeTitle,
tfmtcode.title RecordFormatTitle,
txclcode.updateovertolerance OverTolerance,
return.delinquentdate DelinquentDate,e
return.returnstatus ReturnStatus,
return.limit LimitAmount,
taxccode.tableno TableNo,
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
