Home » Developer & Programmer » Forms » adding values in a table from list item
adding values in a table from list item [message #267966] Mon, 17 September 2007 00:09 Go to next message
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
Re: adding values in a table from list item [message #267969 is a reply to message #267966] Mon, 17 September 2007 00:22 Go to previous messageGo to next message
azamkhan
Messages: 548
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
Re: adding values in a table from list item [message #268016 is a reply to message #267966] Mon, 17 September 2007 02:49 Go to previous messageGo to next message
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 421 times)
Re: adding values in a table from list item [message #268030 is a reply to message #268016] Mon, 17 September 2007 04:20 Go to previous messageGo to next message
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
Re: adding values in a table from list item [message #268276 is a reply to message #267966] Tue, 18 September 2007 01:55 Go to previous messageGo to next message
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.
Re: adding values in a table from list item [message #268287 is a reply to message #268276] Tue, 18 September 2007 02:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: adding values in a table from list item [message #268522 is a reply to message #268287] Wed, 19 September 2007 00:12 Go to previous messageGo to next message
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,
Re: adding values in a table from list item [message #268526 is a reply to message #268522] Wed, 19 September 2007 00:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: adding values in a table from list item [message #268532 is a reply to message #268526] Wed, 19 September 2007 00:32 Go to previous messageGo to next message
fam_bila
Messages: 43
Registered: August 2007
Location: pakistan
Member
wht is 'user_updatable_columns' view.
Re: adding values in a table from list item [message #268533 is a reply to message #268532] Wed, 19 September 2007 00:38 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It is a view in the database.

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


Current Time: Sun Dec 04 18:55:37 CST 2016

Total time taken to generate the page: 0.04441 seconds