OraFAQ Forum: Forms » How to execute query on insert mode

Home » Developer & Programmer » Forms » How to execute query on insert mode

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to execute query on insert mode [message #224638]

Wed, 14 March 2007 20:40

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

When I press F6 and insert new data, I validate the it and if I found that it already exist I have to display the details on my details block. So I have to get out of insert mode and go to query mode instead. how shoul I do?

I put these codes but it's just work as query all, not by the two fields I have specified values.

	clear_form(no_validate);
        :clm_usr.user_no := :parameter.user_no;
	:clm_usr.username := :parameter.username;
	execute_query(no_validate);

[Mod-edit: corrected closing /code-tag]

[Updated on: Thu, 15 March 2007 03:18] by Moderator

Report message to a moderator

Re: How to execute query on insert mode [message #224676 is a reply to message #224638]

Thu, 15 March 2007 02:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In order to query records by some criteria, you have to enter it while in ENTER-QUERY mode. But, it can not be coded. Once you issue ENTER-QUERY, form waits until you press EXECUTE-QUERY.

Therefore, you'll have to put those 'parameter.user_no' and 'parameter.username' into the DEFAULT_WHERE clause (using the SET-BLOCK-PROPERTY built-in (see how to use it in Forms Online Help System) procedure) and EXECUTE-QUERY.

Report message to a moderator

Re: How to execute query on insert mode [message #224724 is a reply to message #224638]

Thu, 15 March 2007 04:29

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

got it littlefoot! I forgot to add extra single for my criteria in default_where then I give up on it. I get back to it as you advised and is now runnig fine.
thanks!

Report message to a moderator

Previous Topic:	replacing characters with *
Next Topic:	POST-CHANGE trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 09:51:52 CST 2025