This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

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

AQH
AQH Member Posts: 298 Blue Ribbon
edited Oct 31, 2019 10:27AM in APEX Discussions

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

Answers