Home » Developer & Programmer » Forms » check box
check box [message #273706] Thu, 11 October 2007 08:01 Go to next message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
I am not able to enable the check box when i run the form,my main task is to create a record_block which has set of records for example 4 so i should have 4 check boxes and all the check boxes should be enabled so wat i did is created a data block with wizard and added the check box later in layout editor and now when i run the form i am not able to see all the 4 check boxes enabled only one is enabled and the rows in the block is also one do i need to change any property,and when i run the form with out any check box i am able to view all the records but not when the check box is added,so please do help me in this

Thank You in advance
Re: check box [message #273771 is a reply to message #273706] Thu, 11 October 2007 11:14 Go to previous messageGo to next message
tiny_oracle
Messages: 20
Registered: October 2007
Location: Syria
Junior Member

Let's discuss this :

First As I understand you have created a datablock has the property "Number Of Records Displayed" equal 4 ...
So , when you add the checkbox you will see 4 check boxes in the canvas _Like Image1 in attached zip file_ , Is that right ???

After that don't forget to determine the value when checked and value when unchecked for check box item , then run th form ...
You will see the resault shown in Image2 in attached file , Is that right ???

I think you are asking about this point ...
If that the answer is that the datablock has no values untill now so you will be able just to manipulate one record

When you run Execute Query the datablock will fetch the values from the table and show them , then you will be able to manipulate

(see enabled text items and check boxes) with the number of the fetched record ...

to solve that : 1> set the check box property "Database Item" to NO
2> then add a trigger in Block-Level , When-New-Block-Instance with this code :
do_key('execute_query');

Yours , Tiny_Oracle
  • Attachment: Images.zip
    (Size: 10.48KB, Downloaded 1011 times)
Re: check box [message #273777 is a reply to message #273771] Thu, 11 October 2007 11:53 Go to previous message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
Thank you it worked.
Previous Topic: Urgent Help plzzzzzzzzz - Hierarchical Tree
Next Topic: Calling Java class from Form10G PLSQL
Goto Forum:
  


Current Time: Thu Dec 05 01:41:13 CST 2024