| execute_query problem [message #138807] |
Fri, 23 September 2005 21:55  |
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
|
Senior Member |
|
|
Dear,
I am getting the problem at the time of execute query. It ask for saving record or not. if i say no than it shows me only last record. i am fetching record from lov for view. here is the code for the same.DECLARE
B BOOLEAN;
C NUMBER;
BEGIN
B:=SHOW_LOV('GENERAL_LEDGER_DETAIL');
IF NOT B THEN
C:=SHOW_ALERT('NO_RECORD');
RAISE FORM_TRIGGER_FAILURE;
ELSE
GO_BLOCK('GENERAL_LEDGER');
EXECUTE_QUERY;
GO_ITEM('CONTROL.MODIFY');
END IF;
Samit
END;
[Updated on: Sun, 25 September 2005 21:28] by Moderator Report message to a moderator |
|
|
|
| Re: execute_query problem [message #138832 is a reply to message #138807] |
Sat, 24 September 2005 05:09  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
| Quote: |
Dear,
I am getting the problem at the time of execute query.
|
Can you tell us the error that you are getting or the error code.That will be help ful.
--Kiran.
|
|
|
|
| Re: execute_query problem [message #138935 is a reply to message #138807] |
Sun, 25 September 2005 21:32 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Yes please. Give us the full message. Also tell us in which trigger you placed this code (to which I added the 'code' tags for you).
Normally, you will get the 'Save?' message if you have changed something. Consider adding a 'commit_form' command before doing the 'show_lov' command.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
