frm- 40505 Unable to query (table does not exist)
Hey,
I have a form which has two blocks that are master and detail blocks. On the form, there are 3 fields that allow the query. If there is record found in the master then it works fine. If nothing found, it shows "query causes no records" which is also fine. But afterwards, no matter what I type in to query, it always show frm-40505. Oracle error, unable to perform query. I click "display error", it shows:
SELECT ROWID,LOC,INV_NUMBER,RECNO,FACTOR,C_DESC,ADJ_TYPE,CODE,AMT FROM OE_INVOICE_ADJ
WHERE (LOC=:1) and (INV_NUMBER=:2) order by recno
frm - 09402:Table or view does not exist.
Here oe_invoice_adj is the detail table and it does exist. If I stop the form and run it again then it's fine. It only happens after "query causes no records".
Any ideas? thanks a lot in advance.