Home » Developer & Programmer » Forms » check box and record insertion problem!
check box and record insertion problem! [message #209752] Sun, 17 December 2006 09:33 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
hello all,
I am facing problem.
1)I have two multiple data blocks with master-detail relationship,there are check boxes associated with each record.all check boxes reside in a cotrol block(non data base block)and I have set value when checked - Y,value when unchecked- N,and initial value - N it means at run time all check boxes should not be checked by default,but they are checked,and if will clik on check box then all turns to unmarked after this i select particular check box.how to solve this problem?

2)By randomly selecting the record using check box i have to insert these selected records in an another table on when button pressed.for this i am writting :-

BEGIN
IF CHECKBOX_CHECKED('BL_CTRL.CHK1')THEN
INSERT INTO DEPT_EMP VALUES(:DEPT.DEPTNO,
:DEPT.DNAME,
:DEPT.LOC,
:EMP.EMPNO,
:EMP.ENAME,
:EMP.JOB,
:EMP.MGR,
:EMP.HIREDATE,
:EMP.SAL,
:EMP.COMM,
:EMP.DEPARTMENT_ID);

END IF;
END;

but it is not working.after inserting these record in a table I have to remove it also.

plz guide me.

Thanks.


icon4.gif  Re: check box and record insertion problem! [message #209762 is a reply to message #209752] Sun, 17 December 2006 11:32 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

NOT GETTING UR PROBLEM SO IF IT POSSIBLE TO SEND THE REPORT THEN SEND IT TO ME I WILL CHECK AND MAKE IT CORRECT
SEND IT TO ME ON
1986.CHAUDHARY@GMAIL.COM
IN UR MAIL PLEASE MENTIONED UR NAME AND KEYWORD "ORAFAQ" BY WHICH I GETTING U.
Re: check box and record insertion problem! [message #209797 is a reply to message #209762] Sun, 17 December 2006 21:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@oracle06 - welcome to the forum. Please use 'code' tags. Practice ion the 'test' forum.

@rajat_chaudhary - welcome to the forum. Stop shouting. Caps only entries are only permitted from users using a TTY.

Checkboxes should be in the detail block but marked as non-database otherwise it is very difficult to associate a particular checkbox to a particular row.

After the insert you need a 'standard.commit' as the form does not 'see' the work that you do manually in the database.

David
Re: check box and record insertion problem! [message #209948 is a reply to message #209797] Mon, 18 December 2006 11:15 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

what do u mean by TTY and the final thing i want to ask u is that,what do u mean by --------

STOP SHOUTINGmentioned in ur reply.
Re: check box and record insertion problem! [message #209972 is a reply to message #209948] Mon, 18 December 2006 16:33 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TTY is an acronym for "Tampereen Teknillinen Yliopisto". I hope it is much more clear now.

Shouting is mentioned because you used all capital letters, which is against the netiquette of internet communication.
Re: check box and record insertion problem! [message #209993 is a reply to message #209948] Mon, 18 December 2006 20:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
TTY is the acronym for Teletypewriter - which only has upper case characters.

David

[Updated on: Tue, 19 December 2006 00:17]

Report message to a moderator

Re: check box and record insertion problem! [message #210020 is a reply to message #209993] Tue, 19 December 2006 00:12 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, right. Among several other possibilities, it is also acronym for Teletypewriter.

I was only joking; what would Tampere University of Technology have to do with CapsLock?
Previous Topic: Oracle Forms9i Error - HTTP 500 - Internal Server Error
Next Topic: problem with LOV..............
Goto Forum:
  


Current Time: Sat Dec 10 04:44:39 CST 2016

Total time taken to generate the page: 0.09033 seconds