Mailing List
Untitled ODTUG-DEV2K-L - [EMAIL PROTECTED] [EMAIL PROTECTED] ---BeginMessage--- SUBSCRIBE ORACLE-L ---End Message---
Strange Behavior - forms6i
Hi all, I am experiencing the following problem ,wondering whether it's problem in my code or it's bug. There is an item in the block which has LOV associated with it. whenever I change it's value , string TRUE is displayed instead of the value that I have entered. (nowhere in the code I assign TRUE ,also validate from list is set,yet no error message displayed on save) When I save and re-query then proper values are displayed. Hope someone might able to shade some light on this. Platform: forms6i (Forms [32 Bit] Version 6.0.8.8.0), windows2000 Thanks Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sameer Ghadge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Strange Behavior - forms6i - solved(Strangely )
thanks all. I investigated and found the foll. There was a post-update trigger where I was setting some global variable. mysteriously the error is gone when I made a change in post-update, then reverted back the change and recompiled the code. now same code works fine atleast for the time being. Thanks all for the help Sameer -Original Message- Sent: Wednesday, February 05, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Sameer, Is there a trigger fires on your item where your LOV set ? Make a sure set automatic display to 'no' on LOV setting. Rgrds, Sony -Original Message- From: Sameer Ghadge [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 6:44 PM To: Multiple recipients of list ORACLE-L Subject: Strange Behavior - forms6i Hi all, I am experiencing the following problem ,wondering whether it's problem in my code or it's bug. There is an item in the block which has LOV associated with it. whenever I change it's value , string TRUE is displayed instead of the value that I have entered. (nowhere in the code I assign TRUE ,also validate from list is set,yet no error message displayed on save) When I save and re-query then proper values are displayed. Hope someone might able to shade some light on this. Platform: forms6i (Forms [32 Bit] Version 6.0.8.8.0), windows2000 Thanks Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sameer Ghadge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sameer Ghadge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: forms6i question
thanks to all for the help. I kept the separate cache. (Still question comes to mind ,was there a majorissue in giving read access to the block buffer, it would save lot of validation code) Regards Sameer -Original Message-From: Duncan Mills [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 1:59 PMTo: Multiple recipients of list ODTUG-DEV2K-LSubject: Re: forms6i question Nope - keeping a separate cache in a PL/SQL table / RG is the only way. Regards Duncan MillsSenior Principal Product ManagerOracle Application Development Tools [EMAIL PROTECTED] - Original Message - From: Sameer Ghadge To: Multiple recipients of list ODTUG-DEV2K-L Sent: Thursday, January 30, 2003 5:09 AM Subject: forms6i question Hi All ,Can anyone tell me if there is any handle or cursor to a block record buffer,which I can access in forms6i.my requirement is to restrict user from entering duplicate records in theblock while inserting'em (but before saving them).As soon as user enters the row TAB's out I want to check it with values inthe other row in WHEN-VALIDATE-RECORD trigger(Note that rows are not yet stored in the database)I have implemented this using PL-SQL table/Record Group by replicating datain the block with PL/SQL table, (but it requires coding in many triggers)I was wondering if there is more simple and efficient solution to this.ThanksSam-- Join us at Loews Miami Beach, Florida on June 22-27, 2003 for our bestODTUG Conference yet! Details and registration at: http://www.odtug.com-- Author: Sameer Ghadge INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ODTUG-DEV2K-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
forms6i question
Hi All , Can anyone tell me if there is any handle or cursor to a block record buffer ,which I can access in forms6i. my requirement is to restrict user from entering duplicate records in the block while inserting'em (but before saving them). As soon as user enters the row TAB's out I want to check it with values in the other row in WHEN-VALIDATE-RECORD trigger (Note that rows are not yet stored in the database) I have implemented this using PL-SQL table/Record Group by replicating data in the block with PL/SQL table, (but it requires coding in many triggers) I was wondering if there is more simple and efficient solution to this. Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sameer Ghadge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
