| FRM-40505: unable to perform query error [message #455944] |
Thu, 13 May 2010 13:23  |
doug145
Messages: 4
Registered: November 2008
|
Junior Member |
|
|
I am getting the same error on a form I am setting up under version 10.1.2 Form Builder. But when I press Shift-F1 I get a Getting Started with Internet Explorer popup. I am running the form under OAS. I have a parent/child relationship between 2 tables that I query on the form. Any advice?
A copy of the fmb file is attached for anyone that can access it.
Doug
[Topics split by LF]
[Updated on: Wed, 19 May 2010 14:13] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: URGENT: 'FRM-40505: unable to perform query error [message #456837 is a reply to message #455965] |
Wed, 19 May 2010 11:26  |
doug145
Messages: 4
Registered: November 2008
|
Junior Member |
|
|
Cookiemonster,
When I display the error from the help menu, I get:
SELECT ROWID,REF(O),O.PIIN,O.VENDOR_CODE,O.DODAAC,O.TOP_DATE,O.TOP_CODE,O.TOP_AMT,O.REMIT_TO_CODE,O.COMPANY_NAME,O.ADDRESS_LINE_1,O.ADDRESS_ LINE_2,O.CITY,O.STATE_CODE,O.ZIP_CODE,O.COUNTRY,O.TRANS_DATE,O.CLERK_CODE,O.STATUS,O.TOP_BAL,O.TOP_YEAR,O.TOP_FLAG,O.CURRENCY_CODE,O. US_TOP_AMT FROM OLDOFFSETDB O WHERE (O.PIIN=:1)
ORA-00904: "O": invalid identifier
Why would O be an invalid indentifier, since it is defined as an alias here for OLDOFFSETDB?
Doug
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
