SYSDATE in Oracle Forms?

From: <eugenef_at_tidalwave.net>
Date: Tue, 11 May 1999 22:43:56 GMT
Message-ID: <7habrc$p5e$1_at_nnrp1.deja.com>

[Quoted] Hello Gurus,

[Quoted] [Quoted] Originally we thought SYSDATE in Oracle Forms meant the database server's date.
[Quoted] 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/ ==-- [Quoted] ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 00:43:56 CEST