Home » Developer & Programmer » Forms » why it happen ?
why it happen ? [message #249740] Thu, 05 July 2007 13:16 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi everyone,
i have a module in forms6i in which there are 4 blocks having mater and detail relations with the first block.
all are database blocks.
now the problem is that when i press F7 ( for enter_query mode ) and
after that when i press F8 (execute_query) it asks for save.

when i say yes it throws an integrity error because of constraints.
and when i press no then it retrieves the values in second ,third, and forth blocks before that only first block having fetched data.

what the possibilities that the prompt is coming while execute query..........

and to do to fix it...........

Thanks in advance........

Rajat Chaudhary
Re: why it happen ? [message #250080 is a reply to message #249740] Sat, 07 July 2007 12:58 Go to previous messageGo to next message
athensromania
Messages: 46
Registered: July 2007
Location: Valencia,Spain
Member
The only solution that comes to my mind with your explanation is that you have to controll the key-triggers associated to that keys.

Are you inheriting properties from another form?
Re: why it happen ? [message #250113 is a reply to message #250080] Sun, 08 July 2007 01:30 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

no i am not inheriting any property from any form.........
please do try to give me the solution of that problem........

thanks
REGARDS
RAJAT CHAUDHARY
Re: why it happen ? [message #251136 is a reply to message #250113] Thu, 12 July 2007 07:59 Go to previous message
samidc
Messages: 35
Registered: February 2006
Member
Please check if anywhere in pre-query or key-exec query you are setting any database item value explicitly.

Regards,
SaMiR.
Previous Topic: list item
Next Topic: ORA-12560:TNS:protocol adapter error
Goto Forum:
  


Current Time: Fri Sep 27 00:12:54 CDT 2024