• Registered: 2014-10-10
  • Posts: 156

Topic: Calculate field not updating

Sir,

In Temporary Batch Scheduling

I am adding the data from Student software deliverable table.

In SchedulingDB from Student name is not updating.

Please help me.

See attach file.


https://www.dropbox.com/s/ex270g5k87qhw … e.rar?dl=0


Regards
nitin ingale

Post's attachments

Attachment icon Calculate field.gif 188.99 kb, 309 downloads since 2017-05-23 

  • Registered: 2015-11-13
  • Posts: 652

Re: Calculate field not updating

You forgot to include the StudentNameDB combobox in your Save button action.

3 Reply by nitin.ingale08 (edited by nitin.ingale08 2017-05-24 07:17:43)

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field not updating

Thanks Sir,

My main query is why student name is not updating, when i add them from "Select from Deliverable"grid table,
Other than student name, that is class status, software, trainer etc are updating.
but student name is not updating.

Please see updated file and photo that will clear my query.   in that i save comboBox.

https://www.dropbox.com/s/ex270g5k87qhw … e.rar?dl=0

Please help in this query. how we can solve it?

Regards
Nitin Ingale.

Post's attachments

Attachment icon Calculate field not updating.gif 229.45 kb, 196 downloads since 2017-05-24 

  • Registered: 2015-11-13
  • Posts: 652

Re: Calculate field not updating

I think the following will take care of your situation.

In your SelectFromDeliverableDB_Button1_OnClick procedure replace the following line

SchedulingDB.StudentNameDB.dbItemID := SelectFromDeliverableDB.TableGrid1.dbItemID;

With

SchedulingDB.StudentNameDB.dbItemID := SqlExecute('Select id_AddCourses From DeliverablesDB Where Id = ' + SelectFromDeliverableDB.TableGrid1.sqlvalue);
  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field not updating

Thanks you very much Sir.

Have a great day.

Regards
Nitin Ingale.