Re: SYSDATE VS $$DBTIME$$ - UPDATE PROBLEM

Lee,

I could write the procedure that you talk about and have thought about doing just that, I am however looking for the elegant solution that Forms is supposed to be. Another fellow pointed out that the problem with my:

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

should be:

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

do you think that Issueing four,

:item1 := to_char(sysdate, 'HH:MI:SS');
:item2 := to_char(sysdate, 'HH:MI:SS');
:item3 := to_char(sysdate, 'HH:MI:SS');
:item4 := to_char(sysdate, 'HH:MI:SS');

commands, in a WHEN_BUTTON_PRESSED trigger is slower than doing it through a procedure, The users will be connected via SQL*NET 2.X over v.34 modems?

Thanks for all the help.

levy.lee.ls_at_bhp.com.au (Lee levy) wrote:
>Why dont you write a stored database procedure, to run on the server
>when you push the refresh button, and have the server date time go
>into your item?
>I havent tried it, but it should work.
>Also try Oracle document 106573.884, called "getting client date and time"
>It looks as buggy as all these Oracle documents, but as usual points you
>in the right direction.
>
>HIH
>Lee
 

>In article <49a5pj$fq1_at_its.hooked.net>, Craig <caharper_at_hooked.net> says:
>>
>>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.
>>
>>

Craig Harper                                                                                                                        =
                                                                                                        

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