OraFAQ Forum: Forms » adding values in a table from list item

Home » Developer & Programmer » Forms » adding values in a table from list item

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

adding values in a table from list item [message #267966]

Mon, 17 September 2007 00:09

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

hello!
i have list item on a form that have four values as present,absent,leave, exceptional leave.now,i want when i select one of the value from the list at runtime .these value should be store in a database table.
how is it possible.
plz help me.
regards

Report message to a moderator

Re: adding values in a table from list item [message #267969 is a reply to message #267966]

Mon, 17 September 2007 00:22

azamkhan
Messages: 557
Registered: August 2005

Senior Member

You should use a base table item as List Item. If you cannt use a base table item then on commit explicitly use insert statment with the list item.

Regards,
Azam Khan

Report message to a moderator

Re: adding values in a table from list item [message #268016 is a reply to message #267966]

Mon, 17 September 2007 02:49

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

sorry, the solution u give i cant understand.
here i attached my interface..from the first form when I select the class,session,subect and date and press on the show window.a second window should open which have "regestration_no","name","lastname "and "roll_no" which shows the record based upon the selected valus from the first form and in "attendance status" we select values from a list apear.now the problem is that how we ca save these values in the attendance table against each record.
plz help me..
regards

Attachment: interface.doc
(Size: 93.50KB, Downloaded 1237 times)

Report message to a moderator

Re: adding values in a table from list item [message #268030 is a reply to message #268016]

Mon, 17 September 2007 04:20

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

If the items of the second window associated with a database data block then it will automatically stores into the database when you use the COMMIT_FORM built-ins in SUBMIT button trigger.

Cheers
Soumen

Report message to a moderator

Re: adding values in a table from list item [message #268276 is a reply to message #267966]

Tue, 18 September 2007 01:55

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

The items on the second window does not directly associated with database datablocks but these items fetches values programatically at run time from multiple tables of databse.now the problem is that how can we send the values of "attendance status" in student_attendance table at run time.what is the query??????

plz help me.
thanks.

Report message to a moderator

Re: adding values in a table from list item [message #268287 is a reply to message #268276]

Tue, 18 September 2007 02:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I suggest that you create a view for your second block. As long as you have all of the elemetns of the primary keys used by these various tables in the 'where' clause of the view, and there is a one-to-one relationship you will be able to update through this view.

Use the 'user_updatable_columns' view to confirm that the column you wish to modify is 'updatable'.

David

Report message to a moderator

Re: adding values in a table from list item [message #268522 is a reply to message #268287]

Wed, 19 September 2007 00:12

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

sorry i can't understand what u say .
plz explain your solution in detail.
thanx,

Report message to a moderator

Re: adding values in a table from list item [message #268526 is a reply to message #268522]

Wed, 19 September 2007 00:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create a view, use the 'user_updatable_columns' view to see when the columns you want to use are updatable.

David

Report message to a moderator

Re: adding values in a table from list item [message #268532 is a reply to message #268526]

Wed, 19 September 2007 00:32

fam_bila
Messages: 43
Registered: August 2007
Location: pakistan

Member

wht is 'user_updatable_columns' view.

Report message to a moderator

Re: adding values in a table from list item [message #268533 is a reply to message #268532]

Wed, 19 September 2007 00:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

It is a view in the database.

David

Report message to a moderator

Previous Topic:	problem with runtime where clause
Next Topic:	FRM-40654

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 19:10:05 CST 2025