OracleForms Development Notes: Special default value $ variables $

OracleForms provides six special system variables:

Oracle Forms provides six special system variables:

When the target data source is a non-ORACLE database, avoid using $ DBDATE $, $ DBTIME $, $ DBDATETIME $. we recommend that you use the method specified by the data source in the WHEN-CREATE-RECORD trigger to obtain the current time using an SQL statement.

Do not forget that the $ DATE $ series variables take the current time on the client operating system, and $ DBDATE $ series variables get the current time in the target database. For example, if you log on to a server system remotely and the time zone of the server is different from the time zone of your server, the values of the two may be different.