Home » Developer & Programmer » Forms » Changing the Mode from enter-query to normal
Changing the Mode from enter-query to normal [message #82878] Sat, 12 July 2003 01:43 Go to next message
Sun
Messages: 92
Registered: August 2002
Member
Dear Friends,

I have a problem. I have a button "Modify"

If i click the button it will go to modify mode.

Then i will be entering a Number. I will be prompting the user to select from an alert, that u want to modify the data or generate a new number. If the user want to modify i will be executing there query. i will do the changes then save the data will be updated. No problem. If want to generate a new no. i am populating the data using a procedure. Then i will be inserting the record. But now the status is in "Enterquery" mode. I want to change it to "Normal". How to proceed..

thanks
sun.

Report message to a moderator

Re: Changing the Mode from enter-query to normal [message #82892 is a reply to message #82878] Tue, 15 July 2003 03:08 Go to previous messageGo to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
se the following code
BEGIN
IF :System.mODE = ''NORMAL' THEN
:System.Mode = 'ENTER-QUERY'
END IF;
END;

Report message to a moderator

Re: Changing the Mode from enter-query to normal [message #82906 is a reply to message #82892] Wed, 16 July 2003 02:10 Go to previous message
Sun
Messages: 92
Registered: August 2002
Member
Have u tried the same in the form..
Can u try once and let me know..
It is giving error for me..before the equal to symbol of Enterquery.

If i give colon, it is giving error END when expecting one of the following..

If i give semicolon after enter query
A readonly bind variable....used in out or in-out context..

Report message to a moderator

Previous Topic: Java.Lang.NullPointer Exception
Next Topic: need to brevent dublications
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 02:27:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.