SYSDATE VS $$DBTIME$$ - UPDATE PROBLEM

From: Craig <caharper_at_hooked.net>
Date: 1995/11/26
Message-ID: <49a5pj$fq1_at_its.hooked.net>#1/1


I am attempting to get some fields to update when the refresh button is pressed. the fields are going to display the time of the db when the data was retrived. I have tried to use $$DBTIME$$but there is no way to get an item to update its default value, - set_item_property does not work, without closeing and reopening the form. I then tried to set the value of the Item to sysdate: ie

:item := to_char(sysdate, 'HH:MM:SS');

But the problem with this is that only the seconds are updating. Has anyone encountered this before? How can I get the minutes and Hours to update as well?

PLEASE SOMEONE HELP!!!!!!! Thank you all,

Craig Harper                                                                                                                        =
                                                                                                        

Thinking is more interesting than knowing, but less interesting than looking. Received on Sun Nov 26 1995 - 00:00:00 CET

Original text of this message