Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

onClick how to get Entry Form in Edit or Insert Mode.

AQHOct 29 2019 — edited Oct 31 2019

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);

pastedImage_0.png

  • 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)

pastedImage_9.png

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');

|

Comments

AQH

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

1 - 1

Post Details

Added on Oct 29 2019
#apex, #apex-5-1, #apex-discussions, #form, #oracle, #report, #sql-pl-sql
1 comment
195 views