Assigning time column from a grid to a time variable

David Williams

Hope someone can help with this one!

 

I have a column on a grid that holds a time that I specify in a time variable on the form. I click an update button that updates the column in the database (datetime column). The grid refreshes and displays the time in the grid column with no problems.

 

However, when I click on the row in the grid I need to read that value from the grid back into the time variable. I just cant find a way to do it without giving an error at runtime.

 

I can assign a column that holds a datetime value back into a datetime variable, but not datetime into a time variable. However this works ...

 

Local.tmpTime = Convert.ToDateTime(

"1 Jan 1900 17:00:00");

But this is obviously just a static time, and I would like to bring back the time specified. I would like to bring back the time I have specified in the grid and was using ...

 

Local.tmpTime = ProcessContext.UserInput[10];

 

But this throws an error. Is there any way of getting the UserInput into the Convert.ToDateTime ?

 

I have also tried reading a full datetime into a time column but that doesnt work either.

 

Thanks,

Dai

 

Jerome_Pearce

It works for me.

 

Are you certain you have the right field? You must use the field list from the Business Object, not the columns in the grid as was axpected in previous versions.

 

If that is not the problem, what error do you get?