Home » Developer & Programmer » Forms » check box value insertion in table
check box value insertion in table [message #481553] Thu, 04 November 2010 03:00 Go to next message
wreesha
Messages: 2
Registered: October 2010
Junior Member
Hi All
I am using oracle form builder 6i and oracle database 10g
here i'm posting my problem that i'm facing in form.
kindly help me.
1:
I have table named 'info' column name 'InfoId'and some other.
And another table named 'Handing' with column names HtId, Value1 and value2..
2:
I made form that consist of three data blocks, first block takes criteria and second block display record against that criteria from table 'info'.

3:
i want checkboxes agianst that display record,
and want that when I select some checkboxes against 'InfoId' these selected 'InfoIds'

should save in another table named 'handing' in column 'HtId'.
and in same table data in column value1 and value2 will be inserted through textboxes

that are in the third datablock of the thae same form .


how can i do it?
waiting for your precious reply
thanks in advance.
Re: check box value insertion in table [message #481559 is a reply to message #481553] Thu, 04 November 2010 04:11 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

you will need to write a trigger on the check box and manually write the insert statement.

insert into handing as select ..........
Re: check box value insertion in table [message #481685 is a reply to message #481559] Fri, 05 November 2010 05:18 Go to previous message
wreesha
Messages: 2
Registered: October 2010
Junior Member
Thanks for reply
I am new in programming so that is why not getting you, how can i do it?
should i write it on when-checkbox-change trigger?
can anyone help me in writing code?
Regards
Previous Topic: need Auto-Email PROCEDURE (merged)
Next Topic: Days, Hours, Min and Seconds Calculation
Goto Forum:
  


Current Time: Thu Sep 19 17:20:37 CDT 2024