Re: SYSDATE in Oracle Forms?

Hi,

Simplest way : create dummy item (DISPLAY=FALSE) default value $$DBTIME$$. When you need time just take it from this item.

eugenef_at_tidalwave.net wrote in message <7habrc$p5e$1_at_nnrp1.deja.com>...
>Hello Gurus,
>
>Originally we thought SYSDATE in Oracle Forms meant the database
>server's date.
>At least it seemed that way in Forms 4.5. In Forms 5.0, SYSDATE
>definitely gives
>us the PC's operating system date while we wanted the database one.
>
>We have a lot of forms that have WHEN-NEW-RECORD-INSTANCE or
>PRE-INSERT triggers that all assign some date field with SYSDATE.
>We tried changing SYSDATE to $$DBDATE$$, but that only works as
>the Initial Value in the field's property palette.
>Syntatically, you can't do this, for example:
>
>:block_name.last_update_date := $$DBDATE$$;
>
>So how can we write something that has the same meaning as above,
>without actually using $$DBDATE$$? Is there another built-in function
>or pseduo-column that means the same thing?
>
>You might say, simply don't assign anything and fill in all the
>Initial Values with $$DBDATE$$. But what if you need to do the
>assignment on a conditional basis?
>
>Thanks in advance for any suggestions.
>
>===================
>Eugene Fan
>CEXEC / IMCEN
>fane_at_hqda.army.mil
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 13 1999 - 10:21:47 CEST