Discussions
Categories
- 385.5K All Categories
- 4.9K Data
- 2.5K Big Data Appliance
- 2.4K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
onClick how to get Entry Form in Edit or Insert Mode.

i have created 'Form on Table with Report' and use 'studentdata' table below. it works fine. what i have to do to get the following;
- as soon as i click the 'Create' button on Report page, a window with only one field/column get input from user i.e 'STUDENTNUMBER:________' as soon as user input its value and on press Enter it (system) will search this value in STUDENTDATA table if value found then Form StudentData displays with populated all values in Edit Mode. as shown (user enter student number 20030 and press enter);
- as soon as i click the 'Create' button on Report page, a window with only one field/column get input from user i.e 'STUDENTNUMBER:________' as soon as user input value and on press Enter it (system) will search this value in STUDENTDATA table if value NOT found then Form StudentData displays in New Record mode, as shown (user enter student number 20031 and press enter)
thanks for assistance in advance; im using oracle xe apex release 4.0.2.00.09 ,2010.05.13
data |
---|
CREATE TABLE STUDENTDATA ( STUDENTNUMBER NUMBER, FIRSTNAME VARCHAR2(50 BYTE) NOT NULL, LASTNAME VARCHAR2(50 BYTE) NOT NULL, HOMEADDRESS VARCHAR2(50 BYTE), HOMEPHONE VARCHAR2(50 BYTE), MOBILEPHONE NUMBER(10) ); ALTER TABLE STUDENTDATA ADD (CONSTRAINT STUDENTDATA_PK PRIMARY KEY (STUDENTNUMBER)); insert into studentdata values (20030,'DANIEL','EMMA','Lorem ipsum home address 20030','1234567830','12345630'); insert into studentdata values (20029,'BEN','Charlotte','Lorem ipsum home address 20029','1234567829','12345629'); insert into studentdata values (20028,'ALEX','MEGAN','Lorem ipsum home address 20028','1234567828','12345628'); insert into studentdata values (20025,'JACK','CHOLE','Lorem ipsum home address 20025','1234567825','12345625'); insert into studentdata values (20021,'JAMES','EMILY','Lorem ipsum home address 20021','1234567821','12345621'); |
Answers
-
i have try some time but unsuccess. i have set above data at following link if some one can do assist;
https://apex.oracle.com/pls/apex/f?p=1917:4:105406604454294:::::
user test
password- studentdata