Re: SYSDATE in Oracle Forms?

[Quoted] You could try creating a database function (e.g. fn_dbdate) that returns a date parameter.
[Quoted] This would be executing the 'sysdate' command actually on the database and returning the result to the form, so no actual forms processing would be used the calculate the data. In theory, this should work.

Simon Hedges
Gloucester
UK

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 Wed May 12 1999 - 01:06:19 CEST