Subject Re: [IBO] Date Parameter
Author Helen Borrie
At 07:49 AM 26-09-01 +0300, you wrote:
>I do not think IBO supports current_time as a default value.
>IB6 accepts 'NOW' as a default for TIME fields, but IBO does not seem to.
>Of course, supposing I am not missing something obvious.

Correct. IBO will accept Now as a Default because Delphi supports its own Now function. If you must apply a client-side default in preference to a server-side one, about all you can do is intercept the input to your insert statements in the BeforePost handler and calculate the current time. It would be a lot simpler just to apply an 'IF NULL' Before Insert trigger on the server.

Note that CURRENT_TIME is only available in Dialect 3, otherwise you would need to use a UDF.


All for Open and Open for All
InterBase Developer Initiative ยท