On 26 Apr 2005 at 17:32, Grant Brown wrote:

>My lack of knowledge is preventing me from fixing the problem as I can
>not work out what the problem is.

Firebird does not use implicit casts in expression.

> FTime= 'Now' - (3/1440); /*create the check time stamp*/

FTime = CAST('Now' as TIMESTAMP) - CAST(3 as DOUBLE
PRECISION)/1440;

Without second cast this expression won't work because in dialect 3
1/1440 = 0.
--
SY, Dimitry Sibiryakov.