forms error 40505 Port Jervis New York

Address 1100 N Galleria Dr, Middletown, NY 10941
Phone (845) 692-7553
Website Link

forms error 40505 Port Jervis, New York

Is it a known problem in Oracle forms 6i which can be solved by use of any patch ? Your ON-ERROR trigger should look something like this: PHP Code: DECLARE

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. The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table." But if I You can not post a blank message. Kindly let me know why this is happening ???

Select a Product... Please type your message and try again. The point is, that at this moment you have too little information to get the real error cause. Register Help Remember Me?

Board index The team • Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site Home ERP About One was a validation at table level and the other... Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #158170 is a reply to message #85200] Wed, 08 February 2006 16:19 RJ.Zijlstra Messages: Join Date Sep 2002 Location UK Posts 5,171 Provided Answers: 1 What do you see when you select Help - Display Error from the form menu just after you get the

and displaying empno,ename,job,sal,comm,mgr,hiredate, and copyied dname from dept in one frame on canvas. The validation that was going on in the WHERE clause was also being done in two other places in the form. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. As Himanshu already suggested, it could be that in some cases it would be something like '... = '; (A NULL value after one of the = signs) I would strongly

prasadhoney07 replied Nov 7, 2012 Check your procedure APPS.ARP_MISC_CASH_DIST line 1743,there select query returns more than one rows so only you got that error Top Best Answer 0 Mark this reply Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218631 is a reply to message #158193] Fri, 09 February 2007 01:23 [email protected] Messages: If you are still unable to find out then post your Form & Table structure at for investigation. Amit Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #85218 is a reply to message #85206] Wed, 09 June 2004 22:56 Himanshu

instead create a SR to oracle and let them provide your datafix. Karan. Corel Lotus Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft InfoPath Microsoft OneNote Microsoft Outlook Microsoft PowerPoint Microsot Project Microsoft Publisher Microsoft Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation Reply With Quote 03-16-04,10:38 #3 andrewst View Profile View Forum Posts Visit Homepage Moderator.

This tool uses JavaScript and much of it will not work correctly without it enabled. Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your account. (LogOut/Change) You are 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 In find receipt menu i only use parameter for "Receipt Dates".

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. Sanjay Report message to a moderator Re: URGENT: 'FRM-40505: unable to perform query error [message #218643 is a reply to message #218631] Fri, 09 February 2007 02:19 Littlefoot When i click "Find" button. That means that hour where condition is not unique DANI Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

The variable form_global.part_nr & form_global.ctry_cd are never Null because i assign them before firing query over this erroroneous block and i debugged the query, it always hold the string with ctry_cd I'm not sure what we will do, but will hash it out and get back with actions taken. For example from 01-Oct-2012 to 30-Oct-2012. Original answer by daniel perlmutter Nov 7, 2012 Contributors: Top You have a select like SELECT A INT0 B FROM C WHERE ?...

Like Show 0 Likes(0) Actions 8. Am working in Designer 6i Forms. i.e begin ...... ....... More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 14 Replies Latest reply on Aug 17, 2010 6:55 AM by Suhail Faraaz FRM-40505: unable to perform query 622640 Feb

Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Happily the FRM-40505 is gone! You can also try to update or delete this record later. hendracy replied Nov 7, 2012 Actually i tried to query some receipt in oracle form.

For example from 01-Oct-2012 to 30-Oct-2012. 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 I would like to see the ORA error number and message, but when i install an On-Error trigger routine for this purpose I get ORA-00000 operation successful, which cannot be right. Subscribe Entries (RSS) Comments (RSS) Archives December 2011 August 2011 July 2011 May 2011 Categories ERP My entry Oracle Uncategorized Meta Register Log in Create a free website or blog at

The problem was with the code you, Tony, identified. When i click "Find" button. Can you help me capture this error/message/alert so that the user will not see it? 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

Re: FRM-40505: unable to perform query 791846 Aug 17, 2010 6:04 AM (in response to 622640) i have an error FRM-40505: unable to perform query want solution plz Like Show 0 As I suggested to you as sson as you get this error Press Shift+F1. Maybe a developer can help you . . .