frm error 40505 Shubuta Mississippi

Thank you for choosing West Computers as your local computer service provider. West Computers is a locally owned and operated business that provides quality sales, service, and support to the Hattiesburg-Laurel-Waynesboro regional area. We believe in giving quality service at affordable rates, while still holding the customer number one. West Computers you, the customer, are our focus. We will make every effort to suit your needs and weguarantee our service.

Address 1654 Highway 184, Laurel, MS 39443
Phone (601) 425-0300
Website Link http://www.westcomputers.com
Hours

frm error 40505 Shubuta, Mississippi

Thanks so much in advance for your help!SELECT DISTINCT (RCRAPP1_PIDM)FROM RCRAPP1WHERE RCRAPP1_INFC_CODE IN ('ISIR','EDE')AND RCRAPP1_CURR_REC_IND = 'Y'AND (EXISTS (SELECT 'X' FROM RORSTAT WHERE RORSTAT_PIDM = RCRAPP1_PIDM AND RORSTAT_AIDY_CODE = RCRAPP1_AIDY_CODE AND You're making the assumption that both form_global.ctry_cd and form_global.part_nr are never NULL. (And never in 'programming-time' sometimes is remarkebly short...) The saying 'it works when I put it in sql*plus' doesn't All product names are trademarks of their respective companies. The block name is -BLK_CLA_COLUMBO_WORKBUFFER I am populating that block dynamically by setting its WHERE clause at the Block level by using following code in PRE-QUERY trigger of the block BLK_CLA_COLUMBO_WORKBUFFER

Well anyhow, we got rid of the other validations and now we're running smoothly. If you're able to get the form without any errors then write execute_query in when_new_form_instance. Thanks, Amit Sharma Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85205 is a reply to message #85200] Wed, 09 June 2004 In its bottom part you should be able to scroll through the whole statement that raised an error and compare columns with actual columns in your table.

LOG( l_query ); Set_property.... ... Kindly let me know why this is happening ??? daniel perlmutter replied Nov 7, 2012 Hendracy hi You must check the line number 1743 to see what your are fetching By example if there is more than one receipt in and possibly in other Oracle Forms environments, shows the query as constructed and the ORA error message.

Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM Re: FRM-40505: unable to perform query 567066 Feb 12, 2008 5:20 PM (in response to Tony Garabedian) Guess what you have to do is assuming ( if I inderstood your issue Maggie Reply With Quote 03-17-04,16:59 #9 mhamilton View Profile View Forum Posts Registered User Join Date Oct 2003 Location Missouri, USA Posts 18 Well, I said I'd let you know the If this is your first visit, be sure to check out the FAQ by clicking the link above.

Reset Post Submit Post Software Forums Software · 43,580 discussions Open Source · 248 discussions Web Development · 11,534 discussions Browser · 1,205 discussions Mobile Apps · 47 discussions Latest From The SQL Statement in Error is: SELECT ROWID, PIG_BASIS_ACCOUNTS.FY, PIG_BASIS_ACCOUNTS.ACCOUNT, PIG_BASIS_ACCOUNTS.ID, PIG_BASIS_ACCOUNTS.PIG_ID, PIG_BASIS_ACCOUNTS.CREATE_DATE, PIG_BASIS_ACCOUNTS.CREATED_BY FROM PIG_BASIS_ACCOUNTS PIG_BASIS_ACCOUNTS WHERE ( SELECT PIG_BASIS_ACCOUNTS.ACCOUNT FROM BASIS_ACCOUNTS_VW, PIG_BASIS_ACCOUNTS WHERE BASIS_ACCOUNTS_VW.FY = PIG_BASIS_ACCOUNTS.FY ) and (PIG_BASIS_ACCOUNTS.PIG_ID=:1) i was sorry for not explaining u correctly Like Show 0 Likes(0) Actions 9. displaying the dept with the feilds of dept table and ename on the canvas exuting query and it is showing error- unable to perform query.

If you need any further info to solve this problem, plz revert. My schema name is G_HRS, Table Name - HRS_MSTEMPLOYEE. Re: FRM-40505: unable to perform query Tony Garabedian Feb 12, 2008 1:42 PM (in response to 622640) You need to have some sort of relation between the DEPT Block. Review all of the possible values that can be assigned to form_global.ctry_cd and form_global.part_nr.

Home | Invite Peers | More Oracle Groups Your account is ready. For example from 01-Oct-2012 to 30-Oct-2012. Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Re: How do I capture FRM-40505 when executing query? Are you passing any parameters to the called form from calling form ?

Maggie Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft i have tried as you told but it is not exucuting the value for dname.if i keep dname as non database item.it is only executing the columns for emp Like Show Original answer by daniel perlmutter Nov 7, 2012 Contributors: Top You have a select like SELECT A INT0 B FROM C WHERE ?... Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference kevinsky View Member Profile Dec 2 2008, 09:35 AM Post #3 Advanced Member Group: Members Posts: 37 Joined: 22-October 04 From: Show 14 replies 1. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Results 1 to 9 of 9 Thread: How do I capture FRM-40505 when executing query?

Re: FRM-40505: unable to perform query Ade2 Apr 8, 2008 4:54 PM (in response to 628374) Make tot a display item and in your post-change :tot := :salary + nvl(:commission_pct,'0'); Like I'm not sure what we will do, but will hash it out and get back with actions taken. Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 Well that SQL is certainly invalid: SELECT ROWID, PIG_BASIS_ACCOUNTS.FY, PIG_BASIS_ACCOUNTS.ACCOUNT, PIG_BASIS_ACCOUNTS.ID, PIG_BASIS_ACCOUNTS.PIG_ID, PIG_BASIS_ACCOUNTS.CREATE_DATE, PIG_BASIS_ACCOUNTS.CREATED_BY FROM PIG_BASIS_ACCOUNTS PIG_BASIS_ACCOUNTS WHERE ( SELECT I can go into the Database and see that the correct relationship exists.

rajthampi replied Nov 7, 2012 Unless this is a customized apps form, you shouldn't try to fix it yourself. i want to display the values for all the above mentioned columns along with dname also. Select a Product... Where the select result is more than one row.

Please let us know what your solution will be. I know which query is inducing the error message, but I see nothing wrong with it, and have successfully run it in SQLPlus. Buy/Market/Sell/Service Smarter eBook Avoiding the Shoebox: Managing Expenses in Small and ... This solves the problem I set, although after some investigation I may be back with a deeper question. 0Votes Share Flag Back to Web Development Forum 4 total posts (Page 1

Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-16-04,10:25 #1 mhamilton View Profile Reply from daniel perlmutter | Nov 7, 2012 Popular White Paper On This Topic Top 5 Reasons ERP Installs Fail and What You Can Do About Them All Replies (8) Best Can you help me capture this error/message/alert so that the user will not see it? It shows "ORA-00904: invalid column name" and that is correct.

Start a new thread here 4998634 Related Discussions ORACLE error: Unable to Perform Query Misc Receipt Unable to perform Transact Move Order (Serial Numbers) - which gives Fatal Failure (India Localization... So I'm not asking it to query the child when I query the parent. Please enter a title. Re: FRM-40505: unable to perform query 628374 Apr 8, 2008 4:43 PM (in response to 622640) i have same problem but with another way i have 2 table employees & departments

Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Sridhar Kallepalli replied Sep 16, 2010 Hi First try to call the form from the menu without any Execute_query trigger in the called form. and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. In find receipt menu i only use parameter for "Receipt Dates".

You will find out the cause of your problem. The only proof is seeing the values for exactly what they are, so logging and more logging... MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement A ZDNet site | Visit other CBS Interactive sites: Select SiteCBS CaresCBS FilmsCBS RadioCBS.comCBS InteractiveCBSNews.comCBSSports.comChowhoundClickerCNETCollege NetworkGameSpotLast.fmMaxPrepsMetacritic.comMoneywatchmySimonRadio.comSearch.comShopper.comShowtimeTech

hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form. SELECT ROWID, PIG_BASIS_ACCOUNTS.FY, PIG_BASIS_ACCOUNTS.ACCOUNT, PIG_BASIS_ACCOUNTS.ID, PIG_BASIS_ACCOUNTS.PIG_ID, PIG_BASIS_ACCOUNTS.CREATE_DATE, PIG_BASIS_ACCOUNTS.CREATED_BY FROM PIG_BASIS_ACCOUNTS PIG_BASIS_ACCOUNTS WHERE ( SELECT PIG_BASIS_ACCOUNTS.ACCOUNT FROM BASIS_ACCOUNTS_VW, PIG_BASIS_ACCOUNTS WHERE BASIS_ACCOUNTS_VW.FY = PIG_BASIS_ACCOUNTS.FY ) > 100 and (PIG_BASIS_ACCOUNTS.PIG_ID=:1) Tony Andrews http://tinyurl.com/tonyandrews Reply