Hello,

I am trying update a string field that represents a time. I want to update the field based on the values of the field itself.

update rssched set end_time = (str(val (substr(end_time,1,2)) + 1) + ':' + substr(end_time,4,2)) where trans_no = '0600217071'

This updates end_time to blank. This same kind of script seems to work in SQL server but not in FoxPro :(

TIA,

Ken