How to start form in 'ENTER-QUERY' mode?
Stefan Röhle
I have created a form using FormBuilder. When I start the form it is in
:System.Mode='NORMAL', but I would prefer it to be in 'ENTER-QUERY' mode
so that I can start a query right away. Is this possible?
Thanks,
Stefan
PS: Please answer via email as well.
Y.M.
trigger.
Following is a copy of the HELP screen for DO_KEY built in.
Moreno Y.
ORACLE Developer 2000 programmer,
Daemon Systems Ltd.
===============================
(Visit our website at http://www.daemon.co.il )
------------ DO_KEY
Built-in ---------------------------------------------------
-----------
Syntax:
DO_KEY(built-in_subprogram_name);
Built-in Type: restricted procedure
Enter Query Mode: yes
Description:
Executes the key trigger that corresponds to the specified
built-in subprogram. If no such key trigger exists, then
the specified subprogram executes. This behavior is
analogous to pressing the corresponding function key.
Parameters:
built-in_subprogram_name Specifies the name of a valid
built-in subprogram.
Restrictions:
DO_KEY accepts built-in names only, not key names:
DO_KEY(ENTER_QUERY). To accept a specific key name, use the
EXECUTE_TRIGGER built-in: EXECUTE_TRIGGER('KEY_F11').
Built-in Key Trigger Associated Function Key
ABORT_QUERY Key-EXIT [Exit/Cancel]
BLOCK_MENU Key-MENU [Block Menu]
CLEAR_BLOCK Key-CLRBLK [Clear Block]
CLEAR_FORM Key-CLRFRM [Clear Form]
CLEAR_RECORD Key-CLRREC [Clear Record]
COMMIT_FORM Key-COMMIT [Commit]
COUNT_QUERY Key-CQUERY [Count Query Hits]
CREATE_RECORD Key-CREREC [Insert Record]
DELETE_RECORD Key-DELREC [Delete Record]
DOWN Key-DOWN [Down]
DUPLICATE_ITEM Key-DUP-ITEM [Duplicate Item]
DUPLICATE_RECORD Key-DUPREC [Duplicate Record]
EDIT_TEXTITEM Key-EDIT [Edit]
ENTER Key-ENTER [Enter]
ENTER_QUERY Key-ENTQRY [Enter Query]
EXECUTE_QUERY Key-EXEQRY [Execute Query]
EXIT_FORM Key-EXIT [Exit/Cancel]
HELP Key-HELP [Help]
LIST_VALUES Key-LISTVAL [List]
LOCK_RECORD Key-UPDREC [Lock Record]
NEXT_BLOCK Key-NXTBLK [Next Block]
NEXT_ITEM Key-NEXT-ITEM [Next Item]
NEXT_KEY Key-NXTKEY [Next Primary Key Fld]
NEXT_RECORD Key-NXTREC [Next Record]
NEXT_SET Key-NXTSET [Next Set of Records]
PREVIOUS_BLOCK Key-PRVBLK [Previous Block]
PREVIOUS_ITEM Key-PREV-ITEM [Previous Item]
PREVIOUS_RECORD Key-PRVREC [Previous Record]
PRINT Key-PRINT [Print]
SCROLL_DOWN Key-SCRDOWN [Scroll Down]
SCROLL_UP Key-SCRUP [Scroll Up]
UP Key-UP [Up]
Example:
/*
** Built-in: DO_KEY
** Example: Simulate pressing the [Execute Query] key.
*/
BEGIN
Do_Key('Execute_Query');
END;
Copyright (c) 1994, Oracle Corporation.
Stefan Röhle
>
> Try the DO_KEY (ENTER_QUERY) in your WHEN_NEW_FORMS_INSTANCE
> trigger.
Thanks!
Stefan
Matt B.
news:3986D8ED...@mail.uni-mainz.de...
On WHEN-NEW-FORM-INSTANCE do either of these (whichever you prefer):
DO_KEY('ENTER_QUERY');
ENTER_QUERY;
-Matt
Stomil
set
Enter_query;
Michal