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

It is always a good idea to cut down on the network traffic. If you have four items into which Sysdate should go, then get sysdate once from the server, put it into a temporary variable, and use the variable to place the four values on your form.

    Declare tmp_date datetime := sysdate;     Begin

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

Forget about the stored procedure. It would not buy you anything in this case.

In our forms, we get Sysdate only once, and store it in a parameter in the form, and never ask the server for it again. If you need the server's time, then that might justify repeated requests from the server. However, I would try to do something with $$DBTIME$$ in a hidden item. I haven't tried it, but if you set it to null, the form might automatically set it to the correct time.

By the way, could you shorten the line-length of your posts? On my PC, they wrap the last word and then break to a new line. Looks terrible. And secondly, please cut back on the extra text from previous posts.

HTH,
Steve Cosner Received on Wed Nov 29 1995 - 00:00:00 CET